Hi everybody,
I got a data series in the sheet1: can i create a sheet2 in the way that if i update the sheet1, the sheet2 will be automaticaly updated?
Thanks in advance
PS sorry for the title, i hope that now is correct
Hi everybody,
I got a data series in the sheet1: can i create a sheet2 in the way that if i update the sheet1, the sheet2 will be automaticaly updated?
Thanks in advance
PS sorry for the title, i hope that now is correct
Last edited by The_jackal; 05-28-2008 at 08:05 AM.
The_jackal
Please take a couple of minutes and read the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1)
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
You can use simple formulas in Sheet2.
For example, if you want Sheet2!A1 to equal Sheet1!A1 then
in Sheet2!A1 you enter formula =Sheet1!A1.... anytime you update Sheet1!A1, then Sheet2!A1 will update automatically
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Ok done, but now i`ve got this problem: in the "sheet 2" for each empty cell coming from "sheet 1" appear the value 0....how could I avoid this?
One way is :Tools - Options - View tab -Uncheck " zero values"Originally Posted by The_jackal
If there is a chance that some of the cells in your original sheet have 0's and you want to see them, then your formulas would be revised to something like:Originally Posted by The_jackal
=if(Sheet1!A1="","",Sheet1!A1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks