Hopy
New Member
- Joined
- Aug 4, 2022
- Messages
- 8
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
- Mobile
- Web
Hi All
I need to add new rows with data from "Sheet 8" to "Sheet 1", "Sheet 2" and "Sheet 3", based on the column A cell value of "Sheet 8".
If the cell value is matched with the tab name, e.g. Sheet 1, then the whole row (from A to G) of content will be copied to the worksheet "Sheet 1" and nowhere else, from next empty row as there is a existing data in all worksheets. Repeats for each value in column A.
The number of rows in "Sheet 8" is known and set by cell W1 value.
A prevision solution wasn't works as mine description was wrong.
In this solution, whole data from Sheet 8 was copied in all tabs that listed in array except matched A row tabs names, on match data was correctly copied only rows that matched.
Please see images - in Sheet2 what who was in Array but doesn't matched A row values, was copied whole data from Sheet8
I need to add new rows with data from "Sheet 8" to "Sheet 1", "Sheet 2" and "Sheet 3", based on the column A cell value of "Sheet 8".
If the cell value is matched with the tab name, e.g. Sheet 1, then the whole row (from A to G) of content will be copied to the worksheet "Sheet 1" and nowhere else, from next empty row as there is a existing data in all worksheets. Repeats for each value in column A.
The number of rows in "Sheet 8" is known and set by cell W1 value.
A prevision solution wasn't works as mine description was wrong.
Add a new Rows based on cell value to match with tab name
Hi All I need to add new rows with data from "Sheet 8" to "Sheet 1", "Sheet 2" and "Sheet 3", based on the column A cell value of "Sheet 8". If the cell value is matched with the tab name, e.g. Sheet 1, then the whole row of content will be copied to the worksheet "Sheet 1" from next empty row...
www.mrexcel.com
In this solution, whole data from Sheet 8 was copied in all tabs that listed in array except matched A row tabs names, on match data was correctly copied only rows that matched.
Please see images - in Sheet2 what who was in Array but doesn't matched A row values, was copied whole data from Sheet8