| 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 |
| 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) | |||
Threaded Mode
