Previous Topic Next Topic

Macros

Closed
Goutham G
Posts
1
Registration date
Sunday January 13, 2013
Status
Member
Last seen
January 15, 2013
 - Jan 15, 2013 at 08:29 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Jan 16, 2013 at 06:11 AM
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

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Jan 15, 2013 at 12:22 PM
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
0
Gouti
Jan 15, 2013 at 04:57 PM
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 770
Jan 16, 2013 at 06:11 AM
have you tried what i suggested about using macro recorder. ?
0