Macro

[rachel lee]

Hi, everyone

I have a spreadsheet that contains data that spans not only across months but also years and I would like to set up a macro that allows me to eliminate data from all the other dates except for that particular month that I'm looking at. Is it possible to set up two macro such that one of it updates the month and another to eliminate all other data to left only the present month?

 

[James006]

Hi,

When using a macro ... you can indeed delete data ...

But based on the way you are describing your objective ... you could simply filter your data ...

 

[rachel lee]

Hi,

When using a macro ... you can indeed delete data ...

But based on the way you are describing your objective ... you could simply filter your data ...

Yes, I agree and majority of the people that I have consulted recommended using a pivot table instead. However as an intern, when my manager specified that she wants to built in a macro such that when we update a new working file in we can just rely on the macro to sort the data out in a faster way, I kind of have to follow through with what she wants. So do you have any idea how to do so?

 

[James006]

Hi again,

As an initial step ... turn on your macro recorder ... and go through your process once ...

You will get a "VBA translation" of all your actions ... and then you will be in a position to improve your code

Hope this will help