Getting rows from one sheet to populate to another Closed

Question

Hi,

I am working in Excel 2016. I have several separate rows of data on one sheet (lets call it my mother sheet) that I want to automatically populate to another sheet. So when I enter data into certain rows on the mother sheet I want it to automatically show up in another sheet. Is this possible? If so what formula would I use?

ac3mark · Answer

There is no formula that will "alter" data or sheets.  You must create a Module, and attach appropriate code to it.   
 
Take a look here, and see if any of this helps:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba

Have FUN!

Getting rows from one sheet to populate to another

1 response

Subscribe To Our Newsletter!