Import Spreadsheets

V

VbaHell

Well-known Member
Joined
Jan 30, 2011
Messages
1,220
I would like some help please
I am using Excel 2007 and have 8 workbooks that are all formatted the same way
These workbooks are updated by various people daily and I currently delete the data in my workbook except for the first row when has the column header on and then copy and paste each of the 8 workbooks into one sheet so I end up with one spreadsheet with all 8 workbooks pasted into it.

Is there a better way of performing this with VBA because quite frankly it's a panic to copy and paste all 8 sheets into one.

Any help would be great please
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You must log in or register to reply here.

Similar threads

S
  • Question Question
Copy certain column N number of times
Replies
0
Views
248
sm789
S
J
  • Question Question
vba to find specific text in a column and then when found copy all the rows above it
Replies
1
Views
186
mumps
mumps
S
  • Question Question
Is there an alternate way to look into an excel sheet instead of connections and queries?
Replies
6
Views
139
SPS41
S
L
  • Solved
Macro to open multiple workbooks and copy a range of data based on todays date. Then paste the data in master workbook in one sheet under each other.
Replies
8
Views
633
Luke1690
L
A
  • Question Question
How to make a formula advance 8 rows when dragging fill handle
Replies
3
Views
157
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,587
Messages
6,179,735
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top