Macros

[Closed]
Report
Posts
1
Registration date
Sunday January 13, 2013
Status
Member
Last seen
January 15, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm new to Macro's and now wanted to learn how to run a macro based on the column values.

Eg: If in column D has a values and if D3 has a value >35, then that 3rd row has to be copied and should be pasted in the next sheet and that data has to be sent thru outlook.

So can some one help me in writing this code.

Thanks much in advance.

Regards,
Goutham

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
For outlook, do a search you will find example
for the copy part, you can use marco recorder to get the macro as a starting template to work from
Hi,
Appreciate your interest !

I'm mainly looking for a code where i can copy a particular row based on the column values as said above.
So help on this part.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
have you tried what i suggested about using macro recorder. ?