Need help assessing problem.
 

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.


--
sshes
------------------------------------------------------------------------
sshes's Profile: http://www.excelforum.com/member.php...o&userid=36555
View this thread: http://www.excelforum.com/showthread...hreadid=563069

Need help assessing problem.
 

sshes wrote:
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

Need help assessing problem.
 

Thanks for the reply.


--
sshes
------------------------------------------------------------------------
sshes's Profile: http://www.excelforum.com/member.php...o&userid=36555
View this thread: http://www.excelforum.com/showthread...hreadid=563069