Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to populate same cell on multiple worksheets
I have a workbook consisting of multiple worksheets (e.g. worksheet 1 thru
50). I am creating a dash board worksheet (Job Set-Up) that will enable the user to input a cell selection (A1) that will populate a specified cell (B1) on specified worksheets (WS-2, WS-4, etc.) I have limited experience with VBA therefore, I try to utilize the record macro capabilities whenever possible. I have recorded the following macro that copies and pastes (special) the values from A1 on WS-1 to B1 on WS-2 and then returns back to the dashboard. Sub Macro1() Range("A1").Select Selection.Copy Sheets("WS-2").Select Range("B1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("WS-1").Select Application.CutCopyMode = False End Sub I want to edit this macro to paste the same values in cell B1 on certain specified worksheets such as WS-4 and WS-6. Is there a loop code that I can add to my recorded macro? Many thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate central worksheet template from multiple worksheets | Excel Discussion (Misc queries) | |||
Macro to populate multiple tabs from a master file | Excel Discussion (Misc queries) | |||
populate multiple worksheets in one workbook | Excel Discussion (Misc queries) | |||
how do I get a macro to change a cell in multiple worksheets? | Excel Discussion (Misc queries) | |||
How do you populate one spreadsheet from multiple worksheets in a. | Excel Worksheet Functions |