Hello, everyone.
I have got a date ( =Now() ) on one worksheet, how can I make excel look it up the value and insert it on the next worksheet?
Hello, everyone.
I have got a date ( =Now() ) on one worksheet, how can I make excel look it up the value and insert it on the next worksheet?
an accompanying example which shows your input data and expected result would help someone solve your problem faster.
- Mangesh
Probably this way ...Originally Posted by antongucci
Let's say that in the first worksheet, the formula =Now() is in Cell A1. Also, let's label the first worksheet -- Sheet1.
In the other worksheet, let's assume that you want to use Cell B1. Your formula in Cell B1 then will be
=Sheet1!A1
I hope I read your problem correctly and my suggested procedure is what you are looking for.
Regards.
BenjieLop
Houston, TX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks