No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Help Badly needed here! I am trying to find a macro that will do the following: Copy the value of a cell M6 for all worksheets in a workbook, and paste them to a new workbook but the cell value for each worksheet of the original workbook should be pasted … 
|
|
|
S.O.S, help needed badly…the following macro: For Each Worksheet In ActiveWorkbook.Worksheets i = i + 1 If i < ActiveWorkbook.Worksheets.Count Then Worksheets(i).Range("M6").Copy Worksheets(ActiveWorkbook.Worksheets.Count).Cells(i, 1).PasteSpecial Paste=xlValues End If Next End Sub will pastes values the last worksheet in the workbook vertically. I am in severe need of a macro which will … |
|
|
S.O.S, help needed badly…the following macro: For Each Worksheet In ActiveWorkbook.Worksheets i = i + 1 If i < ActiveWorkbook.Worksheets.Count Then Worksheets(i).Range("M6").Copy Worksheets(ActiveWorkbook.Worksheets.Count).Cells(i, 1).PasteSpecial Paste=xlValues End If Next End Sub will pastes values the last worksheet in the workbook vertically. I am in severe need of a macro which will … |