Hi,
Is there anyway I can copy cells from one work book to another based on a value that does not exist in the copy from WB?
I have a large spreadsheet with date n one column and want to copy the data to new spreadsheets but pulled into indivdual WB based on the date.
I tried VLOOKUP and typing the date as the search but it didnt work
Is there anyway I can copy cells from one work book to another based on a value that does not exist in the copy from WB?
I have a large spreadsheet with date n one column and want to copy the data to new spreadsheets but pulled into indivdual WB based on the date.
I tried VLOOKUP and typing the date as the search but it didnt work