Forum Discussion
jessica-tls1
Dec 08, 2019Copper Contributor
How to insert a row in worksheet A and have it auto populate in worksheet B
Good Morning, I have a workbook with two worksheets A & B. In A I have several rows of information to copy to worksheet B. I know how to use the = function to copy the rows from A to B but the...
Wyn Hopkins
Dec 09, 2019MVP
Hi jessica-tls1
Have you considered creating a Pivot Table / Chart to use as as the 2nd sheet. That will then automatically pick up inserted rows (by clicking refresh) and can be filtered just to display the data you need?