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)
Thanks again for your help.
Bookmarks