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

[anthonyr]

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

 

[Barry Katcher]

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]

Thanks for the code to manipulate the input box, I've added it to my Cheat Sheet file.

 

[anthonyr]

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