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

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

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?

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?

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

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