I've been struggling with a particular problem and would summarise it as follows There is additional information in the attached file)
I receive workbooks from individuals/Users each month, each workbook contains 1 work sheet. they are all identical in layout when sent out but may have "Issues" when they come back to me. what I di is store them all in a folder along with a master file which has a copy of all the sheets, and 2 summary pages. I import them by copy/paste to update the summary. sometimes I have additional sheets to add into the summaries, and sometimes older ones need to drop out, which means I regularly have to update the summaries which is very time consuming.
I wondered if there were a way to create a dynamic range which was an offset from a cell on the summary sheet to the same place on all of the other worksheets in the book without specifically naming them as when new ones are added they would then not need specifically linking in.
the first summary is different altogether and looks at 2 specific rows only (again from each of the tabs) and subtracting one from the other to get a balance.
Sorry if this is not a very good explanation
there is a bit of code in there which auto names the sheet tab according to the contents of a specific cell which I use to ease the naming of the tabs in a recognisable form. which you are welcome to if it is of any use to you.
Thank you to anyone that can help.
I receive workbooks from individuals/Users each month, each workbook contains 1 work sheet. they are all identical in layout when sent out but may have "Issues" when they come back to me. what I di is store them all in a folder along with a master file which has a copy of all the sheets, and 2 summary pages. I import them by copy/paste to update the summary. sometimes I have additional sheets to add into the summaries, and sometimes older ones need to drop out, which means I regularly have to update the summaries which is very time consuming.
I wondered if there were a way to create a dynamic range which was an offset from a cell on the summary sheet to the same place on all of the other worksheets in the book without specifically naming them as when new ones are added they would then not need specifically linking in.
the first summary is different altogether and looks at 2 specific rows only (again from each of the tabs) and subtracting one from the other to get a balance.
Sorry if this is not a very good explanation
there is a bit of code in there which auto names the sheet tab according to the contents of a specific cell which I use to ease the naming of the tabs in a recognisable form. which you are welcome to if it is of any use to you.
Thank you to anyone that can help.