Getting rows from one sheet to populate to another

Ninabella84 1 Posts Wednesday November 8, 2017Registration date November 8, 2017 Last seen - Nov 8, 2017 at 03:44 PM - Latest reply: ac3mark 10260 Posts Monday June 3, 2013Registration dateModeratorStatus August 15, 2018 Last seen
- Nov 8, 2017 at 04:00 PM
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?
See more 

Your reply

1 reply

ac3mark 10260 Posts Monday June 3, 2013Registration dateModeratorStatus August 15, 2018 Last seen - Nov 8, 2017 at 04:00 PM
0
Thank you
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:
http://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba

Have FUN!
Respond to ac3mark