$$Excel-Macros$$ need help in excel - data merge acorrs columns

Hi , I have data in row and column 1-3, and needs to club the data in single row and column since the data acorss three columns, Pls help me. Regards, Krish Kandy. -- -- Some important links for excel users: 1. Fol

$$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

data attached On Mon, Mar 7, 2011 at 3:47 PM, Krish wrote: > Hi , > > I have data in row and column 1-3, and needs to club the data in > single row and column since the data acorss three columns, > > Pls help me. > > Regards, > Krish Kandy. -- --

$$Excel-Macros$$ Help on merging certain sheets to final workbook

Hi, i need your help friends, in a earlier post we defined a merge from differents books to a single workbook, it excellent, i have a doubt, i have 3 workbooks i have to merge, that i want to copy in this conditions? workbook1 - copy only sheet2 but only this range of cells W4:W109 X4:X109 AR4..

Re: $$Excel-Macros$$ Fwd: Help on formula

Oh yes, thank you very much both you, it´s excellent, the more it´s simplified the better, i put in a formula with various conditions!1000 thanks :) 2011/3/7 OpenExcel.com > Hi Jorge, > > > If you want to further reduce your formula size, you can use > =IF(((P3>T3)+(Q3>U3)+(R3>V3)+(S3>W3))>=2,T

$$Excel-Macros$$ how to increse rows in excel 2007 from 65 k to more

how to increse rows in excel 2007 from 65 k to more -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http:/

$$Excel-Macros$$ Re: how to increse rows in excel 2007 from 65 k to more

Hi, You don't need to increase rows in Excel 2007/2010 to 1048576 from 65536. Also, there is no way to accomplish it. The problem you're facing is due to the use of .xls file which are of Excel 2003 or prior format. Workaround: 1. Save your .xls file as .xlsx (if there are no macros in it) or

$$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

Hi Krish, Use any of the formulas mentioned below in Cell D2. 1. =CONCATENATE(A2," ",B2," ",C2) or 2. = A2 & " " & B2 & " " & C2 -- Excel VBA Interview Questions Collection

Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

Hi Krish, use concatenate formula see attached On Mon, Mar 7, 2011 at 3:49 PM, Krish wrote: > data attached > > On Mon, Mar 7, 2011 at 3:47 PM, Krish wrote: > >> Hi , >> >> I have data in row and column 1-3, and needs to club the data in >> single row and column since the data acorss three col

$$Excel-Macros$$ very urgent

Hello all I need some pivot table examples both excel and macros. can you mail me with excel sheets.. please very urgent Thankyou -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

On 3/7/11, girish kumar wrote: > Hi Krish, > > use concatenate formula see attached > > On Mon, Mar 7, 2011 at 3:49 PM, Krish wrote: > >> data attached >> >> On Mon, Mar 7, 2011 at 3:47 PM, Krish wrote: >> >>> Hi , >>> >>> I have data in row and column 1-3, and needs to club the data in >>> sing

Re: $$Excel-Macros$$ Help on merging certain sheets to final workbook

Ah, how can i stop a macro from copying a sheet to another if the difference there´s more than 3 blank cells in a row? 2011/3/7 Jorge Marques > Hi, i need your help friends, > in a earlier post we defined a merge from differents books to a single > workbook, it excellent, i have a doubt, i have

Re: $$Excel-Macros$$ ( ) for Array Must???

It really depends on how you're using the array. Basically, using: Dim Arrayabc You're not declaring an "array", you're declaring a single variable, type Variant. Now, later you can use Redim ArrayABC(30) and change the variable to an array. Or, curiously enough: ArrayABC = Split("The big brow

$$Excel-Macros$$ Calculate Time

Hi Experts , Kindly check the attached file and tell how to calculate the hours of stay in column "I". Regards Rajesh kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks a

Re: $$Excel-Macros$$ Calculate Time

Can you tell me if the "time" in columns D and G represent actual time? or fractions of hours? for example: Is 6.25 supposed to be 06:25:00AM or is 6-1/4 hours, which is 6:15:00AM ?? Paul From: Rajesh K R To: excel-macros Sent: Mon, March 7, 2011 11:22:53 A

Re: $$Excel-Macros$$ Calculate Time

Excel has it's own internal date/time functionality. A "date" is the number of days since 1/1/1900. "time" is a fractional part of a day. So.. 3/1/2011 @ 6:25am is actually: 40238.267361 and 3/2/2011 @ 20:25 is actually 40239.850694 To find the time difference, simply subtract the two va

$$Excel-Macros$$ OT

Hi Paul, Completely OT, but it has to be "jumps", not "jumped", otherwise there's no "s" in the sentence. -:) Dave. Date: Mon, 7 Mar 2011 06:13:04 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ ( ) for Array Must??? To: excel-macros@googlegroups.com It really depends o

Re: $$Excel-Macros$$ Calculate Time

see if it helps On Mon, Mar 7, 2011 at 9:52 PM, Rajesh K R wrote: > Hi Experts , > > Kindly check the attached file and tell how to calculate the hours of > stay in column "I". > > Regards > > Rajesh kainikkara > > -- > > ---

Re: $$Excel-Macros$$ Urgent required help in excel

Dear Excel Guru, Pl help How to do page break according to conditions like ecode, place in excel after sorting out in Salary Thx Jitender On 24 February 2011 19:16, Jitender kumar wrote: > Dear Excel Guru/Ashish, > > Thanks for your valuable solution.But the problem is still here, Because

Re: $$Excel-Macros$$ ( ) for Array Must???

Hi Paul, The information you provided is AWESOME and MINDBLOWING. the way you have explained the things have cleard my all the doubts. I tried the things you provided and its absolutely fantastic. your this 1 reply have resolved my 2 issues. most of macros working on this type and this post is g

Re: $$Excel-Macros$$ Calculate Time

Dear Paul, What an excllent way of explanation for the below. Hai there Maestro. Regards Ahmed Bawazir On Mon, Mar 7, 2011 at 8:49 PM, Paul Schreiner wrote: > Excel has it's own internal date/time functionality. > A "date" is the number of days since 1/1/1900. > "time" is a fractional part of

Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

=CONCATENATE(A2, " ",B2," ",C2)DaveMar 7, 2011 06:51:07 AM, excel-macros@googlegroups.com wrote: data attached On Mon, Mar 7, 2011 at 3:47 PM, Krish  wrote: Hi ,I have data in row and column 1-3, and needs to club the data insingle row and column since the data acorss three columns,Pls help me.Reg

RE: $$Excel-Macros$$ Macro to Average a series of numbers in excel

Dilip, As I work with this process, I have found a need to sometimes reverse the process, what would the routine look like to remove / reverse the process within the same ranges defined. Thanks again for your support Dave -Original Message- From: Dilip Pandey [mailto:dilipan...@gmail.com

$$Excel-Macros$$ Re: very urgent

Hello, I'm assuming that you are trying to understand pivot tables. There are some great videos on www.youtube.com. Search for: excel pivot table excel pivot table macro Hope this helps. If I'm not understanding what you need, give me more info. Jim On Mar 7, 6:06 am, vi

Re: $$Excel-Macros$$ Help on merging certain sheets to final workbook

can you attach the source and output sheet On Mon, Mar 7, 2011 at 6:13 PM, Jorge Marques wrote: > Ah, how can i stop a macro from copying a sheet to another if the > difference there´s more than 3 blank cells in a row? > > 2011/3/7 Jorge Marques > > Hi, i need your help friends, >> in a earlie

$$Excel-Macros$$ extracting specific text from string

Hi I’m trying to extract EFT information from the following cell PAYMENT BY AUTHORITY TO SG FLEET SALARY PACKAGING PTY LTD SGFLEET EFT587544 So there are 100s of transactions with such information above. I’d like to extract only EFT587544 in the next cell (in this example). The location and the

Re: $$Excel-Macros$$ extracting specific text from string

hi find the attachment and let me know if it is not helpful. -- *Thanks & Regards Thamu * On Tue, Mar 8, 2011 at 10:22 AM, Markkim wrote: > > Hi > > I’m trying to extract EFT information from the following cell > PAYMENT BY AUTHORITY TO SG FLEET SALARY PACKAGING PTY LTD SGFLEET > EFT587544

Re: $$Excel-Macros$$ extracting specific text from string

can you attach a sample sheet try this if it is the last word in a cell ... RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","") On Tue, Mar 8, 2011 at 10:22 AM, Markkim wrote: > > Hi > > I’m trying to extract EFT information from the following cell > PAYMEN