Macro for consolidating excel files Chatting sex typing online
my work sheets are labeled as follows: Ready, Scheduled, In Progress, On Hold, and completed. Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).
i am trying to put together a report based on the supervisor assigned to the jobs that shows the job number, who its issued to, date started, the status and finally notes.
Select ' copy cells selected in the new sheet on last line Selection.
End(xl Up)(2) Next End Sub............................ Above code will work only on single worksheet, if I have multiple worksheets then how I can pull data and if I want to pull data from specific cell like A2, B4, D6 & K35.
The concept behind doing the condensation is rather easy: You simply need to copy the data from the second and subsequent worksheets to the first empty row on the first worksheet. End(xl Up)(2) Next End Sub Excel Tips is your source for cost-effective Microsoft Excel training.
Fortunately, Excel includes a feature that allows you to do this very process—the Consolidate tool. Select ' copy cells selected in the new sheet on last line Selection. This tip (3005) applies to Microsoft Excel 97, 2000, 2002, and 2003.
The best way to find out what the others do is to play around with them, doing a few consolidations.