Combine Closed Sheets

  • Thread starter Thread starter DB100
  • Start date Start date
D

DB100

Hi all

I am hoping someone can lend a hand

I have 13 spreadsheets that are all identical in format and structur
and contain information in the same places ( IE: Cell A1 contains
number ( can be different ) on all the spreadsheets. )

The spreadsheets are all saved in the same place, but have uniqu
names. But the names all contain the month they were created.

The question I have is this. Is it possible to Colate all th
information from the spreadsheets onto 1 "MASTER" list.

EG: All filenames in a certain location containing "JUNE" will have th
information stored in Cell A1 pulled forward to a NEW LIST in a ne
workbook.

Thanks for 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

How to delete ALL cells containing the same data 1
Copying a Picture From Cell Comment 0
Vba Help with Information Extraction 0
Cells with varying number of lines 1
Count unique 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Macro to insert object into spreadsheet ?? 1
Filter/Display only certain rows of information based on a user na 1

Back
Top