Pros need help

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I have been asked to import multiple excel docs into one central excel docs
to so show all the columns in all excel files (IN ONE DOC)

How would i do this and for it to be automated ideally?

PS im not a vb programmer

Thanks,
steve
 
Excel has a limit of 256 columns. If I read you right you want to put
several sheets side by side on 1 sheet. The same effect as printing each
sheet and laying them out on a table, left to right, to view as one big
sheet. In that case would the total columns with data, for all the sheets,
ever be greater than 256? We will need more specific information about what
you have and what you want to do with it. Whatever, it sounds like you will
need code to do this.

Mike F
 
Hi Mike,

Thanks for the reply. There is not more than 256 columns. I will get more
specifics after work today and post them later.

Many thanks,
Steve
 
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

Open WORD doc from EXCEL using VBA 1
store default printer, change printer and then restore default printer? 0
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Ideas? 0
Possible to import Word forms en masse into Excel spreadsheet? 2
Which is the best MBOX Converter Tool different formats conversion? 5
Importing text file into Excel 2003 - C# - QueryTables.Add throwsSystem.ArgumentException 0
Sharing macros 1

Back
Top