copy sheet macro

Good Afternoon, I've been working on a file that has been automated in the past with simple formulas or just by linking cells to other sheets. In this case, I'm having trouble programming a macro, by using a button, to copy a specific table in between ranges. The ideia is to click the button...

Good Afternoon, I've been working on a file that has been automated in the past with simple formulas or just by linking cells to other sheets. In this case, I'm having trouble programming a macro, by using a button, to copy a specific table in between ranges. The ideia is to click the button...

Sub GetSheets() ' Write in the specific path where the file is saved in the path Path = "D:jjjjj\Report 2019-20\" Filename = Dir(Path & "*.xls") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets Sheet.Copy...

Good afternoon all, I have a workbook that has sheets for each month and tracks job requests, and the progress of said jobs. Every month, I copy the previous sheet, and update the sheet name to reflect the new month (format i.e "2.1 - 2.29", "3.1 - 3.31"). I've attached the XL2BB data for the...

Hey guys, I'm working on a sheet where I can use a macro to generate new sheets and rename them to names in a list. I have managed to do this. Yet I want to edit the code to instead of creating a blank sheet. The macro has to copy the sheet named "Blanco" and rename that with the predefined...

Hi all, I am new to the forum. I have been using it for excel help for years and never had a need to ask my own question until now. I have searched high and low for the answer to this. I am sure it is simple, but I cant find it anywhere. I have an excel macro that is duplicating a template...