Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 12th 05, 04:47 PM
ocampo_tony
 
Posts: n/a
Default 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   Report Post  
Old April 12th 05, 06:05 PM
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Old April 12th 05, 08:32 PM
ocampo_tony
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017