Report

Getting rows from one sheet to populate to another

Ask a question Ninabella84 1Posts Wednesday November 8, 2017Registration date November 8, 2017 Last seen - Last answered on Nov 8, 2017 at 04:00 PM by ac3mark
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?
Helpful
+0
plus moins
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!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!