How to make blank cells show blank when referenced in another workbook

[bigpapa]

I have created a spreadsheet with 8 different columns where data is entered and have all those cells referenced to specific cells in worksheet 2. I never know how many documents need to be entered so i formatted 2000 cells. The only problem is when i import it into access it puts zeros in thousands of cells sometimes making u have to delete them. I have the zeros turned off in excel so they don't show but i need the cells in worksheet 2 to show blank if they are blank in worksheet 1 so they will import into access that way

 

[jeffreybrown]

that returns a blank like i need but it also puts a #VALUE! in the cells that have data instead of copying what was in the cell to the reference cell

I still can't see what is going on here. If the formula from post #5 returns a blank, I don't understand where the #VALUE! is coming from.

Can you post some type of sample?

 

[bigpapa]

As simple as i can explain it is. What formula do i type in worksheet 2 A1 to make it show whatever is typed in worksheet 1 a1 and if worksheet 1 a1 is blank make worksheet 2 a1 be blank so it doesnt import all the zeros

 

[jeffreybrown]

=IF(LEN(Sheet1!A1)<>0,Sheet1!A1,"")
Gary

or

=IF(Sheet1!A1="","",Sheet1!A1)

 

[bigpapa]

To make it easiest actually if u could show how to make b1 = a1 and if a1 is blank make b1 be blank and not show a zero i dont need to see it reference another workbook. I could incorporate that code to work for what i need

 

[jeffreybrown]

The concept is the same.

Are you trying any of these suggestions?

=IF(A1="","",A1)

=IF(Sheet1!A1="","",Sheet1!A1)