CTRL+Z is not possible in Macro?

[Dheepak]

Hi Team,

Just want to clear the doubt on macro, which is created for filtering the data. Below is the example table which i created:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Department[/TD]
[TD="align: center"]City[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]SALES[/TD]
[TD="align: center"]X[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]MARKETING[/TD]
[TD="align: center"]X[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]FINANCE[/TD]
[TD="align: center"]Y[/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD="align: center"]FINANCE[/TD]
[TD="align: center"]Z[/TD]
[/TR]
[TR]
[TD="align: center"]E[/TD]
[TD="align: center"]FINANCE[/TD]
[TD="align: center"]Z[/TD]
[/TR]
[TR]
[TD="align: center"]F[/TD]
[TD="align: center"]MARKETING[/TD]
[TD="align: center"]Z[/TD]
[/TR]
[TR]
[TD="align: center"]G[/TD]
[TD="align: center"]SALES[/TD]
[TD="align: center"]Y[/TD]
[/TR]
[TR]
[TD="align: center"]H[/TD]
[TD="align: center"]SALES[/TD]
[TD="align: center"]Y[/TD]
[/TR]
[TR]
[TD="align: center"]I[/TD]
[TD="align: center"]MARKETING[/TD]
[TD="align: center"]X[/TD]
[/TR]
</tbody>[/TABLE]

Query is with reference to the above table. I have created the macro to display only the names, whoever working in Finance Department in city "Z". Below is the output which i got.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Department[/TD]
[TD="align: center"]City[/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD="align: center"]FINANCE[/TD]
[TD="align: center"]Z[/TD]
[/TR]
[TR]
[TD="align: center"]E[/TD]
[TD="align: center"]FINANCE[/TD]
[TD="align: center"]Z[/TD]
[/TR]
</tbody>[/TABLE]

However, once i get the names who is working in Finance department in city Z, i need to go back to my initial table which is having all the details about the names form A to I.

Since, ctrl+z is not possible once,macro actions are performed, could you plz guide me how to get the initial data once the macro actions performed?

Your Immediate Response is much appreciated

Regards,
Dheepak

 

[VBA Geek]

Looks like you want to remove the autofilter, then do CONTROL + SHIFT + L

 

[Dheepak]

Hi VBA Geek,

Thank you so much for your immediate response. Much appreciated!!!! I got the exact answer what i'm looking for. Still, i need one clarification which is not mentioned while raising the query.

Is it possible to go back step by step instead of going directly to initial data. The results remains same (displaying finance name in city Z) but, I need to see under all the city who is working on finance and then need to view all the department.

Hope you got my query and just want to clarify is that possible or not.

Thanks once again in advance and awaiting for your reply.

Regards,
Dheepak

 

[VBA Geek]

What you can do is have another code that filters only by Finance

 

[Dheepak]

Okay, got it!! Thanks for your help Geek. Have a nice day!!!!

Regards,
Dheepak

 

[mikerickson]

For UnDoing macros you might want to look at Application.Undo
Excel Developer Tip: Undoing a VBA Subroutine

 

[Dheepak]

Thank you!!!! Mikerickson, I will try that as well.

Regards,
Dheepak