Excel 2003 - How to Insert Results on the next available row

anthonyr

New Member
Joined
Sep 6, 2006
Messages
3
Hi all,

I have a workbook with multiple tabs...each tab is performing calculations that result in a certain score per tab. All tabs report calcs and results for a specific "subject" say a specific individual. Then all results are integrated in a row in the very first tab, i.e. this tab reports all the scores from all the other tabs.

Now, I want to start entering results in the tabs for a different subject/individual but I want the scores from the tabs to be entered at the next row in the very first tab...basically I am trying to start cataloguing in a single tab the results from different respondents as those results enter in the rest of the tabs.

Hope this makes sense

Many thanks
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Hi, Anthony. Welcome to the Bored.

Is there any reason that you can't just link the cells in the Master worksheet for each individual to the "results" cells in each Individual worksheet?
 

steve case

Well-known Member
Joined
Apr 10, 2002
Messages
815
Thanks for the code to manipulate the input box, I've added it to my Cheat Sheet file.
 

anthonyr

New Member
Joined
Sep 6, 2006
Messages
3
The "same" masterworksheet will be used for updating results...I could, as you suggested, just take those and put them in another workbook one at a time as they come in...I just no that in SAS or some other language you could just code the process I outlined...I thought something similar could be programmed in Excel (the only application that I can use here)...

Many thanks
 

Forum statistics

Threads
1,136,649
Messages
5,676,990
Members
419,667
Latest member
MegEri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top