If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 How do you "mirror" cells in two workbooks
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## How do you "mirror" cells in two workbooks

#1
April 12th 05, 04:47 PM
 ocampo_tony external usenet poster 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 external usenet poster 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 external usenet poster 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
>

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 01:04 AM Linking Workbooks Dede McEachern Excel Worksheet Functions 0 January 21st 05 09:27 PM Tools/Compare and Merge Workbooks - Excel 2003 Pro Laura Excel Worksheet Functions 1 January 3rd 05 06:45 PM Automatic updating worksheet data between different workbooks Yiannis Excel Worksheet Functions 0 December 28th 04 01:01 PM Workbooks...I'll try this again... Markster Excel Discussion (Misc queries) 10 December 7th 04 11:12 PM

All times are GMT +1. The time now is 05:55 PM.