Compiling Multiple Sheet Contents into one Sheet

  • Thread starter Thread starter rbrychckn
  • Start date Start date
R

rbrychckn

I have a series of files (one per user), all of which contain data in
multiple tabs. I'd like to consolidate all of the data across these
files in their respective "Discons" tab.

Each tab is designed the same:
B C D E F
Name ID1 ID2 Description Date

Is there a way to have a macro/update button to pull all of the
contents from the "Discons" tab from all of these files into one tab of
the same structure (B through F) in the Master File? Thanks for your
help.
 
Am I not asking the question right? I could really use some help o
this one. I'd appreciate any hel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Compile Data from Different Sheets 2
Find / FindNext Trouble 2
Save record Into master sheet! 1
Consolidate many WBs into one ... 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Summing using column Heading 5
Automated Solution to Repair PST Files 2
consolidate historical stock returns from multiple workbooks into oneworkbook 1

Back
Top