Excel Query

[Guest Cardie]

I have a worksheet containing a table where users can enter a number of values.

 

Each time a new line is completed I want it to populate a summary page that shows the values of the last set of figures entered. Ideally I need a macro linked to a button that takes the last completed line each time it's pressed.

 

Any ideas on how this is acheived?

 

In addition to this I want a second button that when clicked allows you to type in a date of your choice and then populates the summary with the values linked to the corresponding date.

 

Any help appreciated (and sorry if that sounds like nonsense).

[kozma]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Sir Tokyo Sexwale]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Toe]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[johngibo YPC]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here