I'll try not to be long winded here but I've been working on this for hours and am stumped:
I have a bunch of data (128x128 grid) on Sheet1.
On Sheet 2 I need the data from sheet1 to be multiplied by a multiplier (unique multiplier per each row*)
*Sheet2 Column EA contains the multipliers
I have tons of blank cells on Sheet1 and need to have the blanks carry over to Sheet2.
Another caveat is that several of the multipliers in Column EA are 0.000.
When that is the case I need the data in that row to show 0.000 only if data is filled in a cell--again all other cells would remain blank.
I have experimented with Paste special (by copying all data from sheet1 to sheet2) and have tried to write a formula that makes this work but I haven't figured it out yet.
ANY advice or ideas? :/
Bookmarks