Help copying data from a spreadsheet to another

**OscarAB** · 02-26-2007, 05:13 PM

Hello everyone
I have a small dilemma. I need to copy or transfer information from sheet A into sheet B.
Sheet A is a table with the 31 days of the month and revenue for each day. as the month advances I have less days in the table. Example:
On March 1st cell A1=1
cell A2=2 and so forth until cell A31=31
on March 2nd Cell A1=2
cell A2=3 and so forth until cell A30=31 and cell A31 is blank
So everyday the numbers move up
Now on sheet B the table does not move up. Instead they stay in the same place.
So no matter what day it is cell A1=1 and cell A31=31.
How can I transfer the revenue from sheet A to sheet B when sheet A always looses a day but sheet B remains the same
Hope I was able to make myself clear.
Thank you

**Trebor76** · 02-26-2007, 05:47 PM

Hi there,

How do the numbers on Sheet A move up i.e. do you do it manually or is it automated via a macro?

Kind regards,

Robert

**OscarAB** · 03-03-2007, 07:35 PM

We actually export the information from a Crystal report into a spreadsheet. So everytime we ask the revenue program to produce the report it search for the information starting today until the end of the month. This is why everyday there is a day less.

**Stuart Farr** · 03-04-2007, 06:08 PM

Hi,

My inclination would be to use vlookup() in conjunction with iserror().

For example in cell B1 on Sheet B:

IF(ISERROR(VLOOKUP(A1,SheetA!$A$1:$B$31,2,FALSE))=TRUE,0,VLOOKUP(A1,SheetA!$A$1:$B$31,2,FALSE))

This way, if the number is not present, you won't get #N/A returned. You could use ISNA() function instead of ISERROR() if you prefer.