Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from multiple columns and populate it in another sheet in one column,,
Hi guys
I working on a Bookeeping spreadsheet. I need a bit of help. I have three sheets "CustomerList" with CustomerID in A column like C1,C2,C3.... SuppliersList" SupplierID in A like S1,S2,S3...and "ExpensesList" ExpenseID in A like E1,E2,E3.... I want data (IDs) from all three sheets and populate it in another Sheet called TrialBalance.. like Column A C1 C2 C3 S1 S2 S3 E1 E2 E3 Any tips here please.. (doesn't have to be in order and no duplicates) thanks Thanks Rachid |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[SOLVED] Copy data from multiple columns and populate it in another sheet in one column,,
thanks Jacob Sakoria
Found one of your answer in another ng. After modifying the macro below a bit it is working for me. THANKS Sub AutofilterTwoRanges() Dim ws1 As Worksheet, ws2 As Worksheet, ws As Worksheet, lngRow As Long Set ws1 = Sheet3 Set ws2 = Sheet12 Set ws = Sheet18 ws1.Columns(1).AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=ws.Range("A1"), Unique:=True lngRow = ws.Cells(Rows.Count, "A").End(xlUp).Row + 1 ws2.Columns(1).AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=ws.Range("A" & lngRow), Unique:=True ws.Rows(lngRow).Delete ws.Columns(1).Sort Key1:=Range("A2"), Order1:=xlAscending, header:=xlYes End Sub Rachid "QuickLearner" wrote in message ... Hi guys I working on a Bookeeping spreadsheet. I need a bit of help. I have three sheets "CustomerList" with CustomerID in A column like C1,C2,C3.... SuppliersList" SupplierID in A like S1,S2,S3...and "ExpensesList" ExpenseID in A like E1,E2,E3.... I want data (IDs) from all three sheets and populate it in another Sheet called TrialBalance.. like Column A C1 C2 C3 S1 S2 S3 E1 E2 E3 Any tips here please.. (doesn't have to be in order and no duplicates) thanks Thanks Rachid |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Multiple Columns, Paste Under a Single column | Excel Worksheet Functions | |||
copy text in multiple columns into one column | Excel Discussion (Misc queries) | |||
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet | Excel Programming | |||
Lookup all values within multiple columns and copy to new column | Excel Discussion (Misc queries) | |||
Can I print a single column sheet as multiple columns? | Excel Discussion (Misc queries) |