Hi all,
I'm trying to create a report in a excel worksheet that will gather information from several sheets (in theory will end up with circa 1500 different ones)
The sheets are automatically created in groups of 3 and the name of each sheet will be something like "Project", "Project CX3" and "Project CX5"
all sheets with similar name are identical except for the information contained (All CX3 i.e.).
I need to retrieve information from a few cells from all (lets say, CX3) sheets and create a report with the several predeterminated options in those cells (validation).
If it makes it easy (I read this 4x already and not sure if I understand it...)
I want to get the information from "Project CX3" cells B7, C7 and E10
Note that although I say "Project CX3" in fact it will be from all sheets ending in CX3 (if this makes any sense...
Thank you for looking and for all the help
I'm trying to create a report in a excel worksheet that will gather information from several sheets (in theory will end up with circa 1500 different ones)
The sheets are automatically created in groups of 3 and the name of each sheet will be something like "Project", "Project CX3" and "Project CX5"
all sheets with similar name are identical except for the information contained (All CX3 i.e.).
I need to retrieve information from a few cells from all (lets say, CX3) sheets and create a report with the several predeterminated options in those cells (validation).
If it makes it easy (I read this 4x already and not sure if I understand it...)
I want to get the information from "Project CX3" cells B7, C7 and E10
Note that although I say "Project CX3" in fact it will be from all sheets ending in CX3 (if this makes any sense...
Thank you for looking and for all the help