rcbricker
08-12-2004, 10:51 AM
Hi guys have a new one for you. I have to create a spreadsheet that I will then email to appropriate firms in an attempt to have them show me the outstanding invoices. I have a copy of the sheet attached.
First worksheet is the summary page. There will be links of some sort in the A column that will jump you to the appropriate sheet in the workbook. (the first sheet has the link to show what i mean, i used a hyperlink). Column B is nothing important. Columns C - F is a copy of a totaled formula off each corresponding sheet. On the Summary sheet I changed the background color to matach that of the cells in the A.B. Larson sheet that need to be copied over.
What I need:
I need a macro that will let me insert the command to copy cells B5 - E5 on the corresponding worksheet to the C - F rows on the summary. So B5 - E5 on sheet 1(2) will copy into cells C - F that correspond to Arnett, Draper & Hagood row. Sheet 1 (3) will copy into cells in columns C - F for the next law firm and so on and so forth. easy copy and paste macro that i made reads:
Sub copycells3()
' copycells3 Macro
' Macro recorded 8/12/2004 by RBricker
Range("B5:E5").Select
Selection.Copy
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("Summary").Select
Range("C1").Select
Selection.End(xlDown).Select
Range("C6").Select
ActiveSheet.Paste
End Sub
Obviously it will always paste in cell "C6" how do i get it to lower with the next row.
Next would be is it possible to take the names in Column A of the summary sheet and have them name each worksheet in succession? Sheet 1(2) would be named Arnett, Draper & Hagood then sheet would be Baluch, Gianfrancesco, Mathieu & Szerlag so on and so forth?
First worksheet is the summary page. There will be links of some sort in the A column that will jump you to the appropriate sheet in the workbook. (the first sheet has the link to show what i mean, i used a hyperlink). Column B is nothing important. Columns C - F is a copy of a totaled formula off each corresponding sheet. On the Summary sheet I changed the background color to matach that of the cells in the A.B. Larson sheet that need to be copied over.
What I need:
I need a macro that will let me insert the command to copy cells B5 - E5 on the corresponding worksheet to the C - F rows on the summary. So B5 - E5 on sheet 1(2) will copy into cells C - F that correspond to Arnett, Draper & Hagood row. Sheet 1 (3) will copy into cells in columns C - F for the next law firm and so on and so forth. easy copy and paste macro that i made reads:
Sub copycells3()
' copycells3 Macro
' Macro recorded 8/12/2004 by RBricker
Range("B5:E5").Select
Selection.Copy
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
Sheets("Summary").Select
Range("C1").Select
Selection.End(xlDown).Select
Range("C6").Select
ActiveSheet.Paste
End Sub
Obviously it will always paste in cell "C6" how do i get it to lower with the next row.
Next would be is it possible to take the names in Column A of the summary sheet and have them name each worksheet in succession? Sheet 1(2) would be named Arnett, Draper & Hagood then sheet would be Baluch, Gianfrancesco, Mathieu & Szerlag so on and so forth?