Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy and paste
I would like to create another worksheet with some of the data but display it
differently. Sheet 1 headers date # time A, B, C, D, E item # 1 Jan 123 1011 C abc 29 2 Jan 99 1010 D def 88 3 Jan 77 900 A 3 Jan 188 1100 C abc 29 3 Jan 155 600 D Sheet 2 headers date A B C D E 1 Jan 123 2 Jan 99 3 Jan 77 188 155 I have formulas at the end of sheet 1 computing average for total # and averages of A, B, C, D, E. Auto filter will not work for this. Advance filter work with different headers? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy and paste
How about a pivot table with the dates down the left column and A, B, C, D, E
across the top and # in the middle... Based on that you could also group by Date and or any number of other things that make sense... -- HTH... Jim Thomlinson "Sam" wrote: I would like to create another worksheet with some of the data but display it differently. Sheet 1 headers date # time A, B, C, D, E item # 1 Jan 123 1011 C abc 29 2 Jan 99 1010 D def 88 3 Jan 77 900 A 3 Jan 188 1100 C abc 29 3 Jan 155 600 D Sheet 2 headers date A B C D E 1 Jan 123 2 Jan 99 3 Jan 77 188 155 I have formulas at the end of sheet 1 computing average for total # and averages of A, B, C, D, E. Auto filter will not work for this. Advance filter work with different headers? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy and paste
Jim,
That helps a lot. Thanks. I do have a formula that may not work with the pivot table. % of column or row is great but how do I calculate the % of A (B,C,D,E) that falls within a range? Say 1-100? And 101-120? "Jim Thomlinson" wrote: How about a pivot table with the dates down the left column and A, B, C, D, E across the top and # in the middle... Based on that you could also group by Date and or any number of other things that make sense... -- HTH... Jim Thomlinson "Sam" wrote: I would like to create another worksheet with some of the data but display it differently. Sheet 1 headers date # time A, B, C, D, E item # 1 Jan 123 1011 C abc 29 2 Jan 99 1010 D def 88 3 Jan 77 900 A 3 Jan 188 1100 C abc 29 3 Jan 155 600 D Sheet 2 headers date A B C D E 1 Jan 123 2 Jan 99 3 Jan 77 188 155 I have formulas at the end of sheet 1 computing average for total # and averages of A, B, C, D, E. Auto filter will not work for this. Advance filter work with different headers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
Copy / Paste Warning | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |