Populate data from a column in one worksheet to a cell in multiple other sheets
Solved/Closed
Related:
- Populate data from a column in one worksheet to a cell in multiple other sheets
- How to copy an entire row to another worksheet based on cell value in google sheets ✓ - Forum - Excel
- How to auto populate data in excel from another worksheet - Guide
- How to auto populate data from one worksheet to another - Guide
- Create worksheet based on lists & populate data from another... ✓ - Forum - Excel
- Data validation two columns - Guide
2 replies
TrowaD
Dec 10, 2019 at 12:08 PM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Dec 10, 2019 at 12:08 PM
Hi Vee,
Since I don't think the provided links will guide you to your answer, you can try the following code:
Best regards,
Trowa
Since I don't think the provided links will guide you to your answer, you can try the following code:
Sub RunMe() Dim shName As String Sheets("Raw Data").Select For Each cell In Range("B1:B" & Range("B" & Rows.Count).End(xlUp).Row) If cell.Value = vbNullString Then GoTo NextCell shName = cell.Value Sheets("Template").Copy before:=Sheets("Template") ActiveSheet.Name = shName Range("B5").Value = shName NextCell: Next cell End Sub
Best regards,
Trowa
David Webb
Dec 8, 2019 at 02:50 PM
- Posts
- 3177
- Registration date
- Monday November 25, 2019
- Status
- Administrator
- Last seen
- October 7, 2021
Dec 8, 2019 at 02:50 PM
Hello there,
Have a look at this forum answer on auto population data from multiple sheets that could help you out.
Or check out this article on how to populate multiple sheets based on data entered.
Hope this helps,
David
Have a look at this forum answer on auto population data from multiple sheets that could help you out.
Or check out this article on how to populate multiple sheets based on data entered.
Hope this helps,
David
Dec 10, 2019 at 01:25 PM
Dec 11, 2019 at 01:53 AM