Help with Macros in Excel [Closed]

Report
Posts
3
Registration date
Tuesday February 2, 2010
Status
Member
Last seen
February 4, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Posts
3
Registration date
Tuesday February 2, 2010
Status
Member
Last seen
February 4, 2010

Thank you. I will try this. I aprreciate your help very! much
Posts
3
Registration date
Tuesday February 2, 2010
Status
Member
Last seen
February 4, 2010

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?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!