Sorry that this is very basic, but can you please tell me how to (in a huge spreadsheet with many sheets) automatically copy one row of data (the 4th row) from one sheet to the same location (say the 4th row) in every additional sheet in a workbook. I've been doing it currently by inserting a row in each sheet and copying that same (4th) row of data from that first sheet to every one of those additional sheets. Also, the same question for the last row of data in one sheet copying that row to below the last row of data in all the other sheets.
Thank you !!!
Thank you !!!