Thread: Function needed to extract data from one sheet and import sequentially on to another

Hi there;

I am currently looking to create an excel tool to use with a step counter to track progress of steps

What I wanted to do was have an 'input' section in which I can input the data over 7 days, and once complete, essentially 'export' this data in to an archive from which I can do all kinds of charting and reporting etc...

At the moment, I am stuck on how to solution the 'data input' section

Pressumably I am after a submit command button of some kind that, upon invocation, will take the data from 'sheet 1' and import it on to 'sheet 2' in to the next available row?

Are any gurus able to offer an advice on what kind of function could acheive this?

I attach the high-level example to give context (see tabs "Input Sheet" and "Totals")

I don't think this thread crosses any others... all others seem to be orientated to combobox data management or forumla driven solutions.

Thinking about it, the kind of activity that I want the submit button to do logically is this:

- Take data from B4:H4
- Check Sheet 'Totals'!
- Is 'Totals'!C3:H3' empty?
- If so - import data from 'Input Sheet'!B4:H4 in to C3:H3
- Else, is C4:H4 empty? etc...

Although I think this could have a poor performance overhead if it has to keep checking each row line by line??

Another option could be to have the week number added to the workbook, and this appends by 1 every 7 days?

Then if that worked, the submit button could simply extract the data from B4:H4 on the Input Sheet tab, and import to the row corresponding with the Week Number on the Totals sheet?

Can I bump this - I'm sure there's a boffin out there who will know roughly something I can at least try?