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 January 16, 2023 - Mar 7, 2016 at 10:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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
- Functions of spreadsheet - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Allow multiple downloads chrome - Guide
- Digital data transmission - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
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