Fill down

Hi

I have done, a v lookup between my master sheet and my raw data sheet.

Range("A5").Select
Selection.AutoFill Destination:=Selection.Resize(20, Selection.Columns.Count), Type:=xlFillDefault
Selection.Offset(1, 0).Select

This is the current code I am using... (but i know its very bad :-)

In A5 I want to filldown ONLY data taken from the raw v lookup column. The number of rows in the column will change daily.

Please kindly advise what you would advise.

Thank you very much

Hi

Thanks for replying... in A5 is the data returned form my VLOOKUP from another seperate workbook.... so basically I want to filldown A5 to last known cell with data from my raw data. My other columns are not yet generated with data as yet and normally I would fill down by linking to another column... because this is the first column with data, my code will not work.

Yes Exactly :-)

Any Ideas

Is anyone able to help on the above?


Thank you kindly.

Hi Norie....... sure.... thanks for your feedback.

I am wanting to fill down column A (from row 5 downwards)

What currently happens .... Column A5 returns the vlookup data from my RAW data (tab 2), which is fine. I now want to populate A6/7/8 etc ... I want the fill down to be smart enough to recognise the last cell of data in column A (on tab two) and fill down on tab 1 in relation to tab 2.

I hope that makes some kind of sense :-)

Below is the code im using to populate A5 using BM (Tab 2)

Please Login or Register  to view this content.

Thanks again for your help.

Hi

Thank you so much for your tip.... i think i was trying to make things a little more complicated than was needed.

I have now managed to format my report more or less as needed.... i may have a question or two in a day or so though :-)