Hi all
I really need some help. I am very new to VBA but i think this should be able to be done but don't know how.
I want to be able to do the following:
Seach column R - if the date range is in Jan 2014 (currently displayed as 05 Jan, 14 Jan, 30 Jan)
then pull the information of:
column A, B, C, D, E, G, AK, AB, AL, R, AF, AG, AH, AI, AJ, AM from sheet 1 and paste it to worksheet 2 (or we could call it January 2014 - whichever is easiest)
Seach column R - if the date range is in Feb 2014 then pull
column A, B, C, D, E, G, AK, AB, AL, R, AF, AG, AH, AI, AJ, AM from sheet 1 and paste to worksheet 3 (Feb 2014)
March 2014 to worksheet 4 (March 2014)
April 2014 to worksheet 5 (April 2014)
and so forth
Is this possible? Can this information automatically update? So if i amend sheet 1 the amend is updated in the relevant sheet?
Can anyone help?
I really need some help. I am very new to VBA but i think this should be able to be done but don't know how.
I want to be able to do the following:
Seach column R - if the date range is in Jan 2014 (currently displayed as 05 Jan, 14 Jan, 30 Jan)
then pull the information of:
column A, B, C, D, E, G, AK, AB, AL, R, AF, AG, AH, AI, AJ, AM from sheet 1 and paste it to worksheet 2 (or we could call it January 2014 - whichever is easiest)
Seach column R - if the date range is in Feb 2014 then pull
column A, B, C, D, E, G, AK, AB, AL, R, AF, AG, AH, AI, AJ, AM from sheet 1 and paste to worksheet 3 (Feb 2014)
March 2014 to worksheet 4 (March 2014)
April 2014 to worksheet 5 (April 2014)
and so forth
Is this possible? Can this information automatically update? So if i amend sheet 1 the amend is updated in the relevant sheet?
Can anyone help?