Forum Discussion
Processing a list of data through a separate excel setup
Thanks for this. It's really appreciated.
I am trying to run it and I running into error. Also definetely at my ability as a user rather than your code.
I have updated cell A1 to have the location where the calculation spreadsheet is saved on my computer. I have saved both sheets in this folder.
When I run the macro it gets stuck at:
Set MPAmain = Application.Range(Mid(Asheet.Range("a1").Formula, 2)).Worksheet
Do I need to link the sheets? I am currently running the macro out of sheet 1.
My mistake in my earlier capture I missed off )2 but that what the location I wanted than formula - thanks.
Thanks again.
curry2445 I'm sorry I didn't explain it well.
I changed the macro and sheet a little so I think it makes more sense for you.
Now the macro sheet only has 2 cells; one for the address of the data sheet and one for the address of that formula worksheet. The macro assumes the data sheet is the only or at least the first sheet in the workbook. If not you can tweak the macro (or the workbook).
If this works I hope you will like and mark as best answer 🙂
Hi mtarler,
This is working. Thanks a lot you've saved me a lot of time.
I just have one final question, if you don't mind. I attempted it myself, but its completely wrong.
I want to add a column to my summary sheet with bar sizes in it and ask the macro to look up the bar size in the Cases tab B13:B18 then return the corresponding Mres V13:V18 in the original summary sheet O2...
See attached:Capture - my weak attempt.
Capture1 - the additional column
Capture2 - the information I'm talking about.
