Hello, I have two spreadsheets, sheet 1 and sheet 2. Sheet 2 has the data. Sheet 1 copies the data from Sheet 2 like this:-
='Sheet 2'!A1
If Sheet 2 cell A1 has data, its a straight forward copy, if theres no data, i get a 0. Im wanting the cell to be blank if there's no data to copy accross.
After this step im doing a straight forward copy all and paste all into Access. Im trying to avoid finding all the 0's and deleting them.
Thank you.
Bookmarks