VBA Script Help Required

[ijheyburn]

Afternoon

I hope someone might be able to help me with some VBA I am having trouble with.

I would like to:

• Select all cells between AI2:AT3388 where the value exceed more than £1,000.00
• I also need the contents of the corresponding rows from columns A:D, where the value of the cells in AI2:AT3388 exceed £1000.00 (i.e. step 1 above) to be selected along with the cells in step 1 and all of this 'newly selected data' to be copied into a new sheet

With the outcome being 16 x new columns in a new sheet whose values between columns 5 to 16 only having values of £1000.00 or more.

I hope this makes sense! Any help that could be rendered would be greatly appreciated.

Regards

Ian

 

[ijheyburn]

Just giving this a bump in the hope someone may be able to help?