Need help assessing problem.

[sshes]

Hello,

I need help assessing a problem, and whether I will be able to achiev
the outcome I need without manually copying the data. I don't hav
experience with VBA, so I don't want to attempt an automated solution
cannot achieve immediately. For now, it would be more time efficient t
manually compile the data, but I'd like to know where to target m
efforts for additional future training.

I want to create a single tab (A) that lists values from a sequentia
set of tabs (B to Z) all in the same worksheet. Each B-Z ta
corresponds to a physical warehouse, so I have a list of these on ta
A.

Each tab contains multiple rows of similar data. At the bottom of eac
tab is summary data, such as Total facility rent, and Total Facilities
and Percentage of facilities in use. Unfortunately, the number of row
on each tab are not the same, but the same total headings do appear o
each tab. Some tabs have 10 rows, others have 100. Therefore, th
headings do not appear in the same location on each tab. I'm looking t
grab specific values next to the total heading(s) and populate th
corresponding row on Tab A.

Tabs B-Z were exported reports from another program, put into excel.

Should I do a Vlookup on each tab, to pull the value next to th
desired heading to a reliable location on each tab, such as cell A1
then use some method to look at A1 on every tab?

I'd like to know if a solution will require VBA or if a formula ca
find the text heading on each tab and plug the number next to th
heading on the summary Tab A.

Thanks in advance for your suggestions

 

[Paul Lautman]

Hello,

I need help assessing a problem, and whether I will be able to achieve
the outcome I need without manually copying the data. I don't have
experience with VBA, so I don't want to attempt an automated solution
I cannot achieve immediately. For now, it would be more time
efficient to manually compile the data, but I'd like to know where to
target my efforts for additional future training.

I want to create a single tab (A) that lists values from a sequential
set of tabs (B to Z) all in the same worksheet. Each B-Z tab
corresponds to a physical warehouse, so I have a list of these on tab
A.

Each tab contains multiple rows of similar data. At the bottom of each
tab is summary data, such as Total facility rent, and Total
Facilities, and Percentage of facilities in use. Unfortunately, the
number of rows on each tab are not the same, but the same total
headings do appear on each tab. Some tabs have 10 rows, others have
100. Therefore, the headings do not appear in the same location on
each tab. I'm looking to grab specific values next to the total
heading(s) and populate the corresponding row on Tab A.

Tabs B-Z were exported reports from another program, put into excel.

Should I do a Vlookup on each tab, to pull the value next to the
desired heading to a reliable location on each tab, such as cell A1,
then use some method to look at A1 on every tab?

I'd like to know if a solution will require VBA or if a formula can
find the text heading on each tab and plug the number next to the
heading on the summary Tab A.

Thanks in advance for your suggestions.

Depending on how the data is laid out, you might be able to use dynamic
ranges to accomplish this

 

[sshes]

Thanks for the reply.