CorrectBalance
New Member
- Joined
- Apr 20, 2014
- Messages
- 1
Hi everyone,
I ma using excel enterprise 2007.
I run in to problem with my current work. I have tried to write a macro for nested if formula and used several different examples of those from internet including some from this forum, however those where not exactly relating to my problem.
I am complete novice in terms of macros and vba.
I would like to input number in column c but that number has to be based on text input in column f and some number will have to check if value in column h is above 0
Example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]nominal[/TD]
[TD]description[/TD]
[TD]out[/TD]
[TD]in[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]paypal transfer[/TD]
[TD][/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]post office[/TD]
[TD]190[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In column named "Nominal" I have to put numbers as such: 4000 - for paypal transfer provided that column "in" >0 ; and 5100 for post office provided that column "out" >0
I have more than 5000 transactions in there (rows) and description will vary a lot. I would like a template of macro which I could fill in with appropriate text from description and numbers I need in Nominal to run through entire worksheet. I also want that macro to run only when I press run macro. I do not want number in nominal to change on its own if I move value from "in" to "out" or vice versa.
Help please.
I ma using excel enterprise 2007.
I run in to problem with my current work. I have tried to write a macro for nested if formula and used several different examples of those from internet including some from this forum, however those where not exactly relating to my problem.
I am complete novice in terms of macros and vba.
I would like to input number in column c but that number has to be based on text input in column f and some number will have to check if value in column h is above 0
Example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]nominal[/TD]
[TD]description[/TD]
[TD]out[/TD]
[TD]in[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]paypal transfer[/TD]
[TD][/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]post office[/TD]
[TD]190[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In column named "Nominal" I have to put numbers as such: 4000 - for paypal transfer provided that column "in" >0 ; and 5100 for post office provided that column "out" >0
I have more than 5000 transactions in there (rows) and description will vary a lot. I would like a template of macro which I could fill in with appropriate text from description and numbers I need in Nominal to run through entire worksheet. I also want that macro to run only when I press run macro. I do not want number in nominal to change on its own if I move value from "in" to "out" or vice versa.
Help please.