linking cells...

[mike02]

Hey,

Im working on a workbook that haves 5 worksheets all linked into one work sheet. Its like a questionaire essentially. now When i link each cell corresponding in to one of the 5 worksheets on its proper field in the table. The reason is so i can run a macro to upload it into my database, Access 2010. now i have that part work. What im curious and ive tried googling and searching through old forumns is the cells that are left blank with have a 0 value since it is linked. Is there a way to have the cell link but have NO VALUE in that cell so when i import it into access its just empty? Eg..

MAIN Spreadsheet...(DDQ)
Company:______(c3)
Email:_______(c4)
Address:________(c5)
State:__________(c6)
City:__________(c7)
County:__________(c8)
Webpage:__________(c9)
and so on...

Linked Work Sheet...When the DDQ work Sheet is empty
Company......................Email.....................Address...................State............and so on
='DDQ'!C3...................='DDQ'!C4................='DDQ'!C5..................='DDQ'!C6..........
0................................0...............................0............................0......................

All Im wondering is there way to remove the zero, i know how to hide the zero but that zero still carries over on the import. and i dont want it too..

Thanks!

[mshale]

have you tried an if isblank formula or similar?

=IF(ISBLANK('DDQ'!C3),"",'DDQ'!C3)

You could also insert a phrase like "Participant Left Blank" in the quotes in the formula above.

[mike02]

That works, Is there a quicker way though lol? It will take me an hour for how many columns there are between the 5 sheets. Thank you!

[mshale]

Well, you could arrange the input info on a single row temorarily, and then you could just fill the formula over. After youve done that, you could then drag the form in DDQ back to the way it was; Excel will track those refences and change the other tab accordingly. But that is just a possibility