I have an excel file with two worksheets. One worksheet has two seperate cells that a date needs to be inserted, in one or the other, one would have a date the other would be left blank. How do I capture the date from either one of the cells from the one worksheet to the one cell on the other worksheet?
Last edited by floresra; 07-08-2009 at 09:25 AM. Reason: spelling
Hi Floresra, it would be simplest if you just show us what you're trying to do.
So mockup a sample workbook showing the dilemma and your desired results, point out where the results came from if not obvious in your sample data.
Then click GO ADVANCED and use the paperclip icon to post up your workbook.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
enter date in either of the first worksheet, I'd like the date to appear automatically in the second work sheet.
You explanantion is little confusing, but I intepret it to mean that if a date is in either cell on Sheet2, then you want the cell in Sheet1 to show a date.
If this is correct test which cell is not blank:
or=IF(Sheet1!A2="",Sheet1!B2,"")
However, what if both cells have a date? Which gets precedence? This is moot if only cell will ever have a date.=If(NOT(ISBLANK(Sheet1!A2)),Sheet1!B2,"")
I tried both formulas, didn't work.
How about this, format the cell as DATE and put in this formula:
=MAX(Sheet2!A2:B2)
Re: data from one worksheet to another
It worked,
Thanks!
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
Re: data from one worksheet to another
Done. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks