Which formula do I use to allow the total of one cell to reduce on increasing another!?

[smit_smith]

How can I get the total in two cell's to reduce when I add an amount in another cell?

For example cell H7 is at 100 and cells M7 and N7 are at 20. When I make cell H7 105 how can I automatically get cells M7 and N7 to reduce to 15? The cells are in hours and minutes.

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Aardigspook]

Edit: post deleted as moderator got there first.

[zbor]

Edit: post deleted as moderator got there first.

Don't tell me this title was acceptable for you

[Aardigspook]

No - I quoted the rules as well - but was obviously slower typing it than you were!

[sanram]

Please upload a sample.

[Tony Valko]

That would require an event macro.

[smit_smith]

In the attachment, what I aim to achieve is; when I increase the number within column E6 - E8, the number in columns (H6-H8 & I6-I8) reduces by the amount entered in E6-E8.

Regards

Steve

[smit_smith]

Sanram,

Please see below for uploaded example. Any help would be much appreciated!

Regards,


Steven

[sanram]

Try those event codes on sheet :

Please Login or Register  to view this content.

Those event codes on This Workbook :

Please Login or Register  to view this content.

Now create a new module and declare a global variable like this :

Please Login or Register  to view this content.

That's it. You are done. See the attachment.

[smit_smith]

Sanram,

Sounds good however how do I put that into my excel spreadsheet? For example do I highlight the cells and type in that formula.

Not very good at formatting what so ever! Idiots guide would be good!

Many thanks

Steve

[sanram]

You will not be able to do this with any formula. To put the above macro in your sheet do the following :

1. Right click on the sheet name at bottom and select View Code. Now paste this code there.
   

   Please Login or Register  to view this content.

2. Next double click on ThisWorkbook at the left side on VBAProject panel. Now paste this code there :
   

   Please Login or Register  to view this content.

3. Next right click on ThisWorkbook and select Insert --> Module. Then paste this here :
   

   Please Login or Register  to view this content.

4. Lastly close that visual basic screen and save the file.

That's it. You are done.