Forum Discussion
Solved
How to avoid linking back to original sheet when cutting and pasting rows
I am cutting rows representing days in single years from a master sheet of 30 years and pasting them into their own sheet for their year, all in 1 workbook, so I will end up with 30 sheets. But when ...
Philster Try copy and paste, thus NOT cut and paste. Make sure that G2 in your destination sheets contains the same value as on your Master sheet.
Otherwise copy and paste values if the historic values are supposed to be fixed. You'll loose the formulae and keep the values.
Having said all that, I wonder why you are even splitting data into 30 sheets. Excel is very well equipped to summarise large data sets covering many years. That will be more difficult if you have it in 30 different sheets.
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)