Hey guys! So I already know how to make it that any changes that I make to one sheet will affect all my sheets, but is there a way to set it that if I then add a new sheet it will start off with those contents? I'm going to be making sheets daily, and it would save a lot of time if I didn't have to link the new sheet to the original every time.
Thanks!
Sort of depends on what links you have set up, but my best suggestion would be to create a "template" sheet containing your links then you can copy this to create your new daily sheet, then rename the tab.
Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.
The only problem with that is my template is going to be growing every day. There's no way to set a column to appear on all current and future worksheets within the same workbook? Kind of like a permanent link of all worksheets?Originally Posted by shirleyxls
How about saving as a template?
Why not make all data in 1 worksheet.
It makes it a lot easier to analyse (e.g. with a pivot table).
It is then prefered to add the data in a verticaly way (rows) instead of columns.
If you add a small excel file, without confidential information, I could show it to you.
Please also add manualy the expected result in you excel file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks