Can anyone help me with the below.
Basically im trying to write a macro that brings up (ideally) a drop box with the 12 months of the year (in similar format to "Mar-11"), and the user selects the month they are updating (e.g. Mar-11).
Then the macro searches for that month/text in 12 set cells (will always be B2: M2), please note the cell will contain this text, as well as other text (e.g. cell will contain similar to "Mar-11 figures")
Then once the macro finds which cell contains that text (e.g. for Mar-11, would be D2), it deletes the other 11 columns (i.e. it would delete columns E:M, and columns B:C).
Would really appreciate some help on this if anyone had any ideas?
Basically im trying to write a macro that brings up (ideally) a drop box with the 12 months of the year (in similar format to "Mar-11"), and the user selects the month they are updating (e.g. Mar-11).
Then the macro searches for that month/text in 12 set cells (will always be B2: M2), please note the cell will contain this text, as well as other text (e.g. cell will contain similar to "Mar-11 figures")
Then once the macro finds which cell contains that text (e.g. for Mar-11, would be D2), it deletes the other 11 columns (i.e. it would delete columns E:M, and columns B:C).
Would really appreciate some help on this if anyone had any ideas?
