kungsleden
New Member
- Joined
- Apr 12, 2021
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi,
I did find a thread similar to my question but could not resolve my issue.
This is about biological experiments.
I have a workbook with a number of sheets in it. When performing a certain experiment, I use a piece of equipment that will create one (or several) new worksheet(s) in the open workbook. Each of these new worksheets will contain results in A1:D96. I want to have a formula in an existing worksheet that retrieves those results in cell C2 (f.ex.). Currently, I simply copy/paste the results from the new worksheet(s). This is fine but I would like to automate that step.
If a macro is required, that is ok.
I did find a thread similar to my question but could not resolve my issue.
This is about biological experiments.
I have a workbook with a number of sheets in it. When performing a certain experiment, I use a piece of equipment that will create one (or several) new worksheet(s) in the open workbook. Each of these new worksheets will contain results in A1:D96. I want to have a formula in an existing worksheet that retrieves those results in cell C2 (f.ex.). Currently, I simply copy/paste the results from the new worksheet(s). This is fine but I would like to automate that step.
If a macro is required, that is ok.