Storing work sheets from other Workbook into One Excel work book

DINAUKAUR

New Member
Joined
Sep 30, 2018
Messages
5
Dear Mr. Jury,

Please help me for storing all worksheets from Workbooks into One Excell Book.

Thanks and Regards,
DINAUKAUR
 

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
Do you want to collate all worksheets or consolidate data from all books into one sheet?
 

ask2tsp

Active Member
Joined
Feb 18, 2015
Messages
484
All books on your computer or books found in a certain directory?
And if you want to collate all sheets into one, I assume all sheets are formatted the same way?
 

DINAUKAUR

New Member
Joined
Sep 30, 2018
Messages
5
Yes,All books on my computer.
And I want to collate all sheets into one, you can assume all sheets are formatted the same way?
.
In some work sheets columns sequence are not in same way.
 

ask2tsp

Active Member
Joined
Feb 18, 2015
Messages
484
Please tell us why you want all sheets in all workbooks into one sheet. What do you want to do with that sheet?
 

DINAUKAUR

New Member
Joined
Sep 30, 2018
Messages
5
Please tell us why you want all sheets in all workbooks into one sheet. What do you want to do with that sheet?
My Objective is "Inventory consolidation". Our branches stocks are came through mail.
After getting mails form sources,I have to consolidate the stocks as two types:
1. For preparing MIS (Management Information system) Higher management consolidation.
2. Each sheet link to be assigned to MIS sheet.
 

Forum statistics

Threads
1,085,047
Messages
5,381,381
Members
401,735
Latest member
ranjithr

Some videos you may like

This Week's Hot Topics

Top