Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you "mirror" cells in two workbooks
For sharing data with individuals, I have created two workbooks. Workbook A
is for my use, and workbook B is for sending to others. I currently have columns A through L on sheet 1 workbook B pulling data from workbook A by way of =. The problem that I have, is two fold. Dates that are blank show up as 1/0/900 rather than blank, (changing the format of the cells had no effect) and other cells which are blank are coming back 0. The reason that I am doing this is I dont want to share the information on any other columns. Is there a better way. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Linking Workbooks | Excel Worksheet Functions | |||
Tools/Compare and Merge Workbooks - Excel 2003 Pro | Excel Worksheet Functions | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |