PDA

View Full Version : HELP - Copy Variable Sheet Range from multiple sheets to Summary Sheet



Wuod_Dala
01-03-2014, 08:51 PM
i have a sheet that i need to copy certain ranges to a summary sheet, but the ranges start in different cells in each sheet and are different row numbers.

I recorded what i was looking to do and is also included in the attached workbook (password: finance).

I am looking to combine the macro below with one to merge all these sheets in one summary workbook.

Thank you all.


Sub Macro1()
'
' Macro1 Macro
'
'
Cells.Find(What:="401(K) MATCHING", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Selection.End(xlToLeft).Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
End Sub

GTO
01-03-2014, 11:04 PM
Hi there,

Your attachment seems to be fouled up for me at least. Could you try attaching the workbook again?

Mark

Wuod_Dala
01-04-2014, 03:41 PM
11045

attachment updated