PDA

View Full Version : Delete columns based on current month



ramesh kola
06-08-2018, 11:06 AM
Hi

I have other requirement could you please help me out.

I have a excel data with Jan-17,Feb 17, March-17...............Jul-18

Like that I have orders & Receipts headers in that I want keep only last 4 months columns from current month(Means to say June-2018 is current month then in excel I required only March-18,Apr-18,May-18,June-18) remaining need to be delete by macro for Orders & receipts.

Attached Excel Please help me out..!!