Access this solution immediately by signing up as a member of excelanswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Combine multiple tabs into 1 in Excel
I receive an Excel spreadsheet with sales data on it. The problem I have is that each item number is on it's own tab. The spreadsheets are created out of SQL. Today's spreadsheet came with 200 tabs. Is there a way that I can have all tabs combine into 1 tab, without having to do a manual copy and paste? I am working in Excel 2007. Each tab is formatted the same.
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- Excel
- Participating Experts
- 3
- Solution Grade
- A
Log In
Stay Connected
Top Experts
-
mlmcc
10,880
0 points yesterday
Profile -
dlc110161
3,500
0 points yesterday
Profile -
jimpen
3,500
0 points yesterday
Profile -
rowanscott
2,200
0 points yesterday
Profile -
billprew
2,000
0 points yesterday
Profile -
imnorie
2,000
0 points yesterday
Profile -
kgreene
1,820
0 points yesterday
Profile -
harfang
1,800
0 points yesterday
Profile -
Netminder
1,000
0 points yesterday
Profile -
GRayL
1,000
0 points yesterday
Profile -
eeshahidt
868
0 points yesterday
Profile -
patrickab
668
0 points yesterday
Profile -
tilsant
664
0 points yesterday
Profile -
redrumkev
400
0 points yesterday
Profile -
dave4dl
400
0 points yesterday
Profile -
byundt
200
0 points yesterday
Profile -
CORBETTMJ
200
0 points yesterday
Profile -
pari123
200
0 points yesterday
Profile -
tagit
200
0 points yesterday
Profile -
broomee9
200
0 points yesterday
Profile -
Dave96
200
0 points yesterday
Profile
Posted on 2010-08-26 at 12:46:07ID: 34575295
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.