Remember Me?

#1
April 12th 05, 04:47 PM
 ocampo_tony Posts: n/a
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.

#2
April 12th 05, 06:05 PM
 Dave Peterson Posts: n/a

You can check in your formula:

=if(yourformula="","",yourformula)
like:
=if(sheet2!a1="","",sheet2!a1)

And it's really only one problem. If you format a cell as a date and put a 0,
you'll see 1/0/1900 (assuming that 1/0/900 is a typo in your post).

But the underlying value in the cell is still 0.

ocampo_tony wrote:

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.

--

Dave Peterson
#3
April 12th 05, 08:32 PM
 ocampo_tony Posts: n/a

That works great. Thank you very much.

"Dave Peterson" wrote:

You can check in your formula:

=if(yourformula="","",yourformula)
like:
=if(sheet2!a1="","",sheet2!a1)

And it's really only one problem. If you format a cell as a date and put a 0,
you'll see 1/0/1900 (assuming that 1/0/900 is a typo in your post).

But the underlying value in the cell is still 0.

ocampo_tony wrote:

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.

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post JM Excel Discussion (Misc queries) 1 February 1st 05 01:04 AM Dede McEachern Excel Worksheet Functions 0 January 21st 05 09:27 PM Laura Excel Worksheet Functions 1 January 3rd 05 06:45 PM Yiannis Excel Worksheet Functions 0 December 28th 04 01:01 PM Markster Excel Discussion (Misc queries) 10 December 7th 04 11:12 PM

All times are GMT +1. The time now is 06:15 AM.

The comments are property of their posters.