Help with Macros in Excel

Closed
ack1 Posts 3 Registration date Tuesday February 2, 2010 Status Member Last seen February 4, 2010 - Feb 3, 2010 at 05:18 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 5, 2010 at 04:39 AM
Hi,

This is my first my first post and I am hoping that somene can help me. I am very new to macros etc. I have the need to create two macros in a spreadsheet.

1. I would like to create a Macro that will look at the names that appear in Col C (there are 10 names that may appear multiple times). If the name does not appear, then I would like for the name to be entered in to Col C and in Col B to enter "No Match"

2. I would like a macro to look at the last Row of data and then copy the data that appears in a specific cell to another cell within the spreadsheet.

Lastly, can anyone reccomend a good book that would help me with Macros etc.

Thank you very much for your help/advice.

I really appreciate it.

3 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 3, 2010 at 06:13 PM
1. You can do without macro also
in cell B1 you can have this formula
=IF(COUNTIF(C:C,C1)=1,"No Match","")

so if there is unique value in cell c1, it will say no match, else it will remain blank

2. could you elaborate what you are saying


3. I think one of the best way to do macro is to use the macro recording. It will make a template for you and then you can modify it to your likening and make it more general or what ever the case may be
0
ack1 Posts 3 Registration date Tuesday February 2, 2010 Status Member Last seen February 4, 2010
Feb 3, 2010 at 07:07 PM
Thank you. I will try this. I aprreciate your help very! much
0
ack1 Posts 3 Registration date Tuesday February 2, 2010 Status Member Last seen February 4, 2010
Feb 4, 2010 at 09:50 PM
I have a spreadsheet and I want a macro to find the last row and then copy it to Row 3. Can anyone help me with a macro that will do this?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 5, 2010 at 04:39 AM
to find last row, i find the best way is to use this formula

lets say col A will be the longest col of alll. then you can just look at max row of col A to know what is the last row. to do that you would do

in macro, you can do like this
cells(65536,1).end(xlup).row
0