| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Store Data
I was wondering if this was possible to get data from worksheet and
put it on another worksheet on a single row. The range of the data worksheet is A1:N74, with various questions and answers. Maggie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Store Data
Keeping in mind there are only 256 columns (<xl2007) it might be difficult to fit that on a single row.
Maybe you could provide more details? -- Tim Williams Palo Alto, CA "Maggie" wrote in message ups.com... I was wondering if this was possible to get data from worksheet and put it on another worksheet on a single row. The range of the data worksheet is A1:N74, with various questions and answers. Maggie |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Store Data
On Mar 9, 5:31 pm, "Tim Williams" <timjwilliams at gmail dot com
wrote: Keeping in mind there are only 256 columns (<xl2007) it might be difficult to fit that on a single row. Maybe you could provide more details? -- Tim Williams Palo Alto, CA "Maggie" wrote in oglegroups.com... I was wondering if this was possible to getdatafrom worksheet and put it on another worksheet on a single row. The range of thedata worksheet is A1:N74, with various questions and answers. Maggie- Hide quoted text - - Show quoted text - I have a table with various input cells that a reviewer has to input. The reviewer must look at 50 different loans. I want to record the input on a single row for each loan so that I will not have huge excel file. My range for the table is A1:N74. Is that possible? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Store Data
Each loan has how many different inputs?
As long as it's less than 256 then it can be done. -- Tim Williams Palo Alto, CA "Maggie" wrote in message ups.com... On Mar 9, 5:31 pm, "Tim Williams" <timjwilliams at gmail dot com wrote: Keeping in mind there are only 256 columns (<xl2007) it might be difficult to fit that on a single row. Maybe you could provide more details? -- Tim Williams Palo Alto, CA "Maggie" wrote in oglegroups.com... I was wondering if this was possible to getdatafrom worksheet and put it on another worksheet on a single row. The range of thedata worksheet is A1:N74, with various questions and answers. Maggie- Hide quoted text - - Show quoted text - I have a table with various input cells that a reviewer has to input. The reviewer must look at 50 different loans. I want to record the input on a single row for each loan so that I will not have huge excel file. My range for the table is A1:N74. Is that possible? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Store Data
On Mar 12, 4:29 pm, "Tim Williams" <timjwilliams at gmail dot com
wrote: Each loan has how many different inputs? As long as it's less than 256 then it can be done. -- Tim Williams Palo Alto, CA "Maggie" wrote in oglegroups.com... On Mar 9, 5:31 pm, "Tim Williams" <timjwilliams at gmail dot com wrote: Keeping in mind there are only 256 columns (<xl2007) it might be difficult to fit that on a single row. Maybe you could provide more details? -- Tim Williams Palo Alto, CA "Maggie" wrote in oglegroups.com... I was wondering if this was possible to getdatafrom worksheet and put it on another worksheet on a single row. The range of thedata worksheet is A1:N74, with various questions and answers. Maggie- Hide quoted text - - Show quoted text - I have a table with various input cells that a reviewer has to input. The reviewer must look at 50 different loans. I want to record the input on a single row for each loan so that I will not have huge excel file. My range for the table is A1:N74. Is that possible?- Hide quoted text - - Show quoted text - It has only 66 different inputs for each loan. How would I go about doing this now? I am a beginner at this type of stuff. Maggie |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Store Data
Maggie,
You would create a "summary" sheet with all the required headers, then map each field from your "input" form onto that sheet. To do this you'd have to specify which input field goes in which column in the summary sheet: you could do this in code or create a mapping table with cell addresses and column numbers on a third sheet. A little complex to explain from first principles, particularly if you're new to coding... -- Tim Williams Palo Alto, CA "Maggie" wrote in message ps.com... On Mar 12, 4:29 pm, "Tim Williams" <timjwilliams at gmail dot com wrote: Each loan has how many different inputs? As long as it's less than 256 then it can be done. -- Tim Williams Palo Alto, CA "Maggie" wrote in oglegroups.com... On Mar 9, 5:31 pm, "Tim Williams" <timjwilliams at gmail dot com wrote: Keeping in mind there are only 256 columns (<xl2007) it might be difficult to fit that on a single row. Maybe you could provide more details? -- Tim Williams Palo Alto, CA "Maggie" wrote in oglegroups.com... I was wondering if this was possible to getdatafrom worksheet and put it on another worksheet on a single row. The range of thedata worksheet is A1:N74, with various questions and answers. Maggie- Hide quoted text - - Show quoted text - I have a table with various input cells that a reviewer has to input. The reviewer must look at 50 different loans. I want to record the input on a single row for each loan so that I will not have huge excel file. My range for the table is A1:N74. Is that possible?- Hide quoted text - - Show quoted text - It has only 66 different inputs for each loan. How would I go about doing this now? I am a beginner at this type of stuff. Maggie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to use the P.O. template and collect/store data. | Excel Discussion (Misc queries) | |||
| store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
| Addins store data | Excel Programming | |||
| How Do You Take Data Off A Sheet and Store It In An Array | Excel Programming | |||
| Using forms to store data | Excel Programming | |||
Linear Mode
