Trying to create a new Excel Macro for the first time.

[Rashmi Shinde]

Hi all,

I am very new to Excel Macros, I created a excel macro in three parts , the first 2 parts consist of font manipulation and data vlookup from another excel sheet, I am finding difficulty in the third part of my macro, its nothing by entering filters to one column and then entering particular data in an empty column so that later when the end user an enter pivot to the data.

So , the main issue that I am facing is the data may vary as per employee hire or Termination an due to this the macro may get stuck, can any one help me with the Macro, its simple entering Filter to one column and do a copy paste of data to another column.

 

[AFPathfinder]

When I get stuck on syntax, I normally use the macro recorder to see how Excel writes it. Here is some syntax to get you moving:

Dim finalRow As Integer

finalRow = Cells(Rows.Count, 1).End(xlUp).Row

Range("A1").AutoFilter Field:=9, Criteria1:=""
Range("C2:C" & finalRow).SpecialCells(xlCellTypeVisible).Copy Destination:=Range("I1").Offset(1)

This bit of code sets the filter of column 9 to all blank cells. Then, it copies all values from column C to column I. Or, at least that is what it's supposed to do (untested).

 

[Rashmi Shinde]

Thank you, I will try this code. thanks again for the help

 

[AFPathfinder]

You're welcome! If you run into any snags, let us know.