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 4478 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 response

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

Similar discussions

Macro-Copy data from one workbook to another
Krishna -
Dvibe -

12 responses
One Button To Execute Two Macros
azmiismail -
azmiismail -

4 responses
Excel - A macro to create new workbook and copy data
Shridharb2002 -
TrowaD -

29 responses