Hello
I am trying to create a macro to work through a list of functions that I currently have to manually perform and it is way above my level of knowledge so any help anyone can give me would be greatly appreciated.
I have an excel file called Workbook1. Within this file there are 2 worksheets, one is called Working 1 and the other is called Working 2. Both sheets contain formula to search for information and all the formulas have been changed to start with 'a=' so that they can be copied into another workbook. I also have a list of excel files in a folder called Instructions and they all have only one worksheet in each. I would like to be able to run a macro that will:
1) Open up all the excel files within the Instructions folder
2) Rename the worksheet in every workbook (all are unique names, but there is only one sheet in each workbook) to Instruction
3) Create two new worksheets in each file
4) Rename every sheet 1 to Working 1
5) Copy all of the information from the Working 1 worksheet on the Workbook 1 file and paste it into every Working 1 page on the open workbooks
6) Find and replace every a= with = on all working 1 sheets
7) Copy all of the information from the Working 2 worksheet on the Workbook 2 file and paste it onto every Sheet2 on the open workbooks
8) Find and replace every a= with = on all working 2 sheets
9) Open a brand new worksheet
10) Copy row 1 from the Working 2 sheet within Workbook1 and paste it into row 1 on the new worksheet
11) Copy every row 2 in the open worksheets and paste them into the next empty row on the new spreadsheet
I’m not sure if this would even be possible, and I just can’t get my head around it.
Many thanks
Amy
Bookmarks