Forum Discussion
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...
jessica-tls1I agree with Wyn Hopkins that pivot maybe a more feasible option to explore vs VBA.
Just to check though, how often are the file updated? Once a month? Once a week or? If the frequency is high it'd make sense to invest some time initially to automate via VBA; else I'd recommend to go for the pivot table option.