Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Numerous Columns
I have 8 groups (each group is column for description, and one for quantity)
of colums, 400 lines long that have formulas in them to get the information to come from other sheets and I want to combine them. Each group is a quantity of pieces needed to produce a job, some groups may be blank some may not, but I need to all of them into a possible 3200 line items of descriptions with quantity so I can do a pivot table for my quote. Any ideas would be much appreciated. Jeff |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Numerous Columns
Hi Jeff,
I'm probably missing something here, but copy and paste? -- Thanks, Shane Devenshire "Jeff" wrote: I have 8 groups (each group is column for description, and one for quantity) of colums, 400 lines long that have formulas in them to get the information to come from other sheets and I want to combine them. Each group is a quantity of pieces needed to produce a job, some groups may be blank some may not, but I need to all of them into a possible 3200 line items of descriptions with quantity so I can do a pivot table for my quote. Any ideas would be much appreciated. Jeff |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Numerous Columns
I could do that, but there is the possiblity that we will continually change
information till the customer is satisified with the end result, which means that you will have to cut and paste numerous times. Which is wasting time and you have the possibility of forgetting one time and giving the customer the wrong information. "ShaneDevenshire" wrote: Hi Jeff, I'm probably missing something here, but copy and paste? -- Thanks, Shane Devenshire "Jeff" wrote: I have 8 groups (each group is column for description, and one for quantity) of colums, 400 lines long that have formulas in them to get the information to come from other sheets and I want to combine them. Each group is a quantity of pieces needed to produce a job, some groups may be blank some may not, but I need to all of them into a possible 3200 line items of descriptions with quantity so I can do a pivot table for my quote. Any ideas would be much appreciated. Jeff |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Numerous Columns
I'm not sure if your groups are on different sheets or not, but you
could link those values using a formula like: =IF(Sheet1!A1="","",Sheet1!A1) Then you can copy this down as required, maybe changing Sheet1 to Sheet2 after 400 rows, and so on for other sheets. Once all the cells are linked in this way, then any change to the original data will immediately be reflected through. Hope this helps. Pete On Sep 29, 7:01*pm, Jeff wrote: I could do that, but there is the possiblity that we will continually change information till the customer is satisified with the end result, which means that you will have to cut and paste numerous times. *Which is wasting time and you have the possibility of forgetting one time and giving the customer the wrong information. "ShaneDevenshire" wrote: Hi Jeff, I'm probably missing something here, but copy and paste? -- Thanks, Shane Devenshire "Jeff" wrote: I have 8 groups (each group is column for description, and one for quantity) of colums, 400 lines long that have formulas in them to get the information to come from other sheets and I want to combine them. Each group is a quantity of pieces needed to produce a job, some groups may be blank some may not, but I need to all of them into a possible 3200 line items of descriptions with quantity so I can do a pivot table for my quote. Any ideas would be much appreciated. Jeff- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
Combining columns | Excel Worksheet Functions | |||
Combining Columns | Excel Discussion (Misc queries) | |||
combining columns all the way down | Excel Discussion (Misc queries) | |||
Need to sum up numerous columns in different worksheet into 1 | New Users to Excel |