Sending Data from one spreadsheet to multiple speadsheets
Closed
Pwaluk
-
Mar 7, 2016 at 09:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 7, 2016 at 10:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 7, 2016 at 10:58 AM
Related:
- Sending Data from one spreadsheet to multiple speadsheets
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Google spreadsheet right to left - Guide
- Whatsapp not sending code - Guide
- How to delete multiple files on mac - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 7, 2016 at 10:58 AM
Mar 7, 2016 at 10:58 AM
Hi Pwaluk,
Yes, this is possible.
The code below puts the value found in column B in the sheet mentioned in column A in column B.
Best regards,
Trowa
Yes, this is possible.
The code below puts the value found in column B in the sheet mentioned in column A in column B.
Sub RunMe() Dim MySheet As String For Each cell In Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row) MySheet = cell.Value Sheets(MySheet).Range("B" & Rows.Count).End(xlUp).Offset(1, 0).Value = _ cell.Offset(0, 1).Value Next cell End Sub
Best regards,
Trowa