Getting rows from one sheet to populate to another

Closed

Ninabella84 Posts 1 Registration date Wednesday November 8, 2017 Status Member Last seen November 8, 2017 - Nov 8, 2017 at 03:44 PM
Blocked Profile - 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?

Getting rows from one sheet to populate to another
Google sheet right to left - Guide
Little alchemy cheat sheet - Guide
How to transfer data from one sheet to another in excel using formula - Guide
How to screenshot excel sheet - Guide
Cmd network commands cheat sheet - Guide

1 response

Answer 1 / 1

Blocked Profile
Nov 8, 2017 at 04:00 PM

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!

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet

copy a row from one worksheet to another, based on criteria

Copying data from one Excel sheet to another.

Similar discussions

Subscribe To Our Newsletter!