If quantity is input then info moves into other worksheet

[Washington]

Hi

I am hoping that you can help. I have a file with 3 worksheets. Two worksheets #400 and #600 are for customers that will input in quantity how many printers or frames that want to order. If they input quanity in either #400 or #600 sheet then I would like to have this show up in the sheet called final results.

Can this be done and how? I am an OK Excel but no expert by any means.

Thank you very, very much in advance.

[Trebor76]

Hi there,

I'd say the best way to do this is via code that automatically runs whenever the tab is selected (activated).

Therefore, I have renamed your original Final results sheet and added another sheet (Final Results) which when activated, automatically consolidates the data in Sheets 400 and 600.

To view the code, right click the Final Results tab and choose View Code from the shortcut menu.

Let me know how it goes.

Kind regards,

Robert

[Washington]

Hello Robert

This solution is working great and I thank you very much for taking the time to help me out :-)

Brilliant ...