HI ALL,
I AM LOOKING FOR A WAY TO TRANSFER DATA FROM SHEET2 TO SHEET1 AUTOMATICALLY. I ONLY NEED TO TRANSFER A24:D60 FROM SHEET 2 TO SHEET1 A24:D60. HOW WILL i DO IT WITHOUT LOOSING THE FORMATTING AND DATA?
ATTACHED IS THE SPREADSHEET FOR REFERENCE.
I TRIED USING =+'sheet2'!A24, but it will generate 0's wherever blank in sheet2 and don't copy the formatting. can anyone help?
Bookmarks