Re: $$Excel-Macros$$ Worksheet Consolidation

2014-06-02 Thread Vaibhav Joshi
It was set to focus on row 1, so if you have additional data in column except row 1 then data is not copied. I have change code to reach out to all used columns. PFA HTH//Cheers!! On Tue, Jun 3, 2014 at 2:09 AM, Bill Q wrote: > I spoke too soon. There is an issue > > It picks up and copy

Re: $$Excel-Macros$$ Worksheet Consolidation

2014-06-02 Thread Bill Q
I spoke too soon. There is an issue It picks up and copying all the data from column "A" to column "D" inclusively. It is not picking up and copying data, if from column "E" onwards for some reason. Quick fix ? On Saturday, May 31, 2014 12:35:17 PM UTC-4, Bill Q wrote: > Perfect. T

Re: $$Excel-Macros$$ Worksheet Consolidation

2014-05-31 Thread Bill Q
Perfect. Thank you !! On Saturday, May 31, 2014 2:44:42 AM UTC-4, Vabz wrote: > > Hi > > Check Attachment.. You can goto sheet Autocopy to do the task.. > > Cheers!! > > > On Sat, May 31, 2014 at 3:10 AM, Bill Q > > wrote: > >> Hi, >> >> I am looking for a macro that would: >> >> - Copy all

Re: $$Excel-Macros$$ Worksheet Consolidation

2014-05-30 Thread Vaibhav Joshi
Hi Check Attachment.. You can goto sheet Autocopy to do the task.. Cheers!! On Sat, May 31, 2014 at 3:10 AM, Bill Q wrote: > Hi, > > I am looking for a macro that would: > > - Copy all the information from the current active worksheet that I am in > from cell A1 until it encounters the first

$$Excel-Macros$$ Worksheet Consolidation

2014-05-30 Thread Bill Q
Hi, I am looking for a macro that would: - Copy all the information from the current active worksheet that I am in from cell A1 until it encounters the first blank in column in A into a worksheet already named as "MAIN" that is within the same workbook. It will be thousands of lines. - Befor