Refresh Data then Parse VBA

[kboy1289]

Hi guys,
i'm trying to create a macro that will refresh a data query table, then parse the data (two different columns on two different sheets) the refresh part works however it doesn't parse the data after that. i've tried this without the refresh in the macro (just selecting the "refresh all" option out of data tab then run macro w/o refresh command) and that will parse the data in only one of the sheets but it will not parse the other. i need this because i'm working with people who have little to no excel experience and need to just be able to refresh everything with hopefully a keyboard shortcut. i've tried the record a macro and this is the code that spits out...

Please Login or Register  to view this content.

any help is greatly appreciated, thanks!


Moderator Edit:

Welcome to the forum, kboy1289.

Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[kboy1289]

this can be solved simply using the record a macro feature. in my case i kept the column i was attempting to sort highlighted and is ran with a macro shortcut. more of a quick fix than a permanent solution.