I work with a number of spreadsheets in XLS that have stock or sales data. In order for me to operate in these spreadsheets I use copy and paste and of course this only works as long as I am very careful in keeping these sheets in synch. So each time I add an item in one sheet, I have to make sure I immediately add it in the other sheet as otherwise my next copy/paste will have all the information shifted. Some of the reports I get do not have output for Zero Values meaning the sheet will also be shorter than the master sheet. I need to be run this through a macro someone set up for me and this takes care of this issue. Sorry if my description is not very clear.
I am sure there are clever ways to deal with managing information between sheets of different rows that addresses these issues. Can someone please point me to some helpfile or video tutorial or provide just the name of the function / procedure I could use, that would be very helpful.
