#### aswag74

##### New Member
Not even sure if that is the correct verbage. Realtively new to XL. I searched for some answers/threads, but I think I was using the wrong words.

Simple simple dumb question, I am sure.

I receive a spread sheet from a vendor that is broken down into 5 cities/sheets inside a work book.

Lets say column A, in all sheets, is INVOICE NUMBER.

How do I create a sheet at the end of the workbook that takes the info from all cloumn A's in all five sheets and makes one long column A with all the Invoice numbers?

Ignorantly,

Liberal Arts Major

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Hi, aswag74
Welcome to the Board !!!!!

perhaps a search for "consolidate" will provide you more useful links

one of many routes to go
Code:
``````Option Explicit

Sub consolidate()
'Erik Van Geit
'060914

Dim cnt As Integer
Dim I As Integer
Dim LR1 As Long
Dim LR2 As Long
cnt = Sheets.Count

For I = 1 To cnt
With Sheets(I)
LR1 = .Cells(Rows.Count, "A").End(xlUp).Row
LR2 = Sheets(cnt + 1).Cells(Rows.Count, "A").End(xlUp).Row
.Range("A1:A" & LR1).Copy Sheets(cnt + 1).Range("A" & LR2 + 1)
End With
Next I

End Sub``````
kind regards,
Erik
possibly without internet-connection within 2 hours till 22th sept

Replies
1
Views
917
Replies
7
Views
836
Replies
18
Views
2K
Replies
3
Views
2K
Replies
5
Views
309

1,219,961
Messages
6,151,171
Members
451,012
Latest member
needvbahelp1

### 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.

### Which adblocker are you using?

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

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