Combining data from 100 tabs into one

mrafiq44

New Member
Joined
Oct 14, 2015
Messages
19
is it possible to combine data from 100 tabs into one - these are all receipts from 100 customers, so each has a date invoice number payment numbers, amount on each tab i want to get all the data into one tab so i make analysis?
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Trevor_S

Well-known Member
Joined
Oct 17, 2015
Messages
604
Office Version
2016
Platform
Windows
Are the details you need in the same cells one very tab? If not, is there any other way that a macro process could identify where the information you need is?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,566
Messages
5,469,450
Members
406,652
Latest member
LJA

This Week's Hot Topics

Top