| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Form Format to Spreadsheet Format
Hi,
I have separate excel spreadsheets that are in a form format. I need to combine these separate spreadsheets into one spreadsheet. What is the best way to accomplish this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Form Format to Spreadsheet Format
What do you mean by form format?
-- Brevity is the soul of wit. "Karen" wrote: Hi, I have separate excel spreadsheets that are in a form format. I need to combine these separate spreadsheets into one spreadsheet. What is the best way to accomplish this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Form Format to Spreadsheet Format
Sorry about that. Each individual spreadsheet is in this format
Example: State: CA Prep Date: 9/13/2005 Name: Fred Num: 544 Eff Date: 10/1/2005 Emp: 28 I need to place them all into one spreadsheet in this format. State Prep Date Name Num EffDate Emp CA 9/13/2005 Fred 544 10/1/2005 28 "Dave F" wrote: What do you mean by form format? -- Brevity is the soul of wit. "Karen" wrote: Hi, I have separate excel spreadsheets that are in a form format. I need to combine these separate spreadsheets into one spreadsheet. What is the best way to accomplish this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Form Format to Spreadsheet Format
Copy everything then paste special--transpose.
Depending on how your data is formatted you may have to do some manual adjustments. If the amount of data you're talking about here is too much to do manual adjustments you will need a macro which can organize the data for you correctly. Dave -- Brevity is the soul of wit. "Karen" wrote: Sorry about that. Each individual spreadsheet is in this format Example: State: CA Prep Date: 9/13/2005 Name: Fred Num: 544 Eff Date: 10/1/2005 Emp: 28 I need to place them all into one spreadsheet in this format. State Prep Date Name Num EffDate Emp CA 9/13/2005 Fred 544 10/1/2005 28 "Dave F" wrote: What do you mean by form format? -- Brevity is the soul of wit. "Karen" wrote: Hi, I have separate excel spreadsheets that are in a form format. I need to combine these separate spreadsheets into one spreadsheet. What is the best way to accomplish this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Form Format to Spreadsheet Format
I have several of these that I need to combine into one spreadsheet.
"Dave F" wrote: Copy everything then paste special--transpose. Depending on how your data is formatted you may have to do some manual adjustments. If the amount of data you're talking about here is too much to do manual adjustments you will need a macro which can organize the data for you correctly. Dave -- Brevity is the soul of wit. "Karen" wrote: Sorry about that. Each individual spreadsheet is in this format Example: State: CA Prep Date: 9/13/2005 Name: Fred Num: 544 Eff Date: 10/1/2005 Emp: 28 I need to place them all into one spreadsheet in this format. State Prep Date Name Num EffDate Emp CA 9/13/2005 Fred 544 10/1/2005 28 "Dave F" wrote: What do you mean by form format? -- Brevity is the soul of wit. "Karen" wrote: Hi, I have separate excel spreadsheets that are in a form format. I need to combine these separate spreadsheets into one spreadsheet. What is the best way to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create form in Access, use as frontend for Excel | Excel Discussion (Misc queries) | |||
| Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
| Excel Spreadsheet Not Saved Dialog Error | Excel Discussion (Misc queries) | |||
| How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo | Excel Discussion (Misc queries) | |||
| how to I make an excel spreadsheet into a label format? | Excel Worksheet Functions | |||
Linear Mode
