I have a sheet called Data that will get populated each day with the current days data from another workbook.
The data is put into column A on the sheet and from ‘N4’ I have a count formula.
My problem is each day the file is opened a new date is inserted. I need VBA code that will insert formulas in Sheet 1 starting in Row 6 under the most recent date.
The formula is to collect the data from the data sheet for its respective Name as in column B in Sheet1.[ i.e. EUR ‘B8’ in sheet 1 needs to look at ‘N6’ in the sheet Data ] and so no matter what column I am working on it will always remain static.
22nd Oct the formula would go into U8, 23 Oct. V8, 26th Oct. W8
I have attached a file which I hope makes this clear.