copy conditionally and paste conditionally

[luvbite38]

Hi guys,

I am hoping that someone might be able to help me out here.

I am trying to copy and paste a range on multiple criteria.


Conditional copy warrant
Find Sheets(Database).Range(A1).value in Sheets(Assumptions).Range(G3:G31) and if the value is found copy the range(Nxx:AHxx) where x is row number of the found value. lets say I was finding A and it was found in G5 then copy the range N5:AH5

Conditional Paste Warrant

now in Sheets (Database), if the Sheets(Database).Range(A1).value = Sheets(Assumptions).Range(G3:G31) and column D value is true then paste the copied range 21 cells above as value and transpose.

the macro have to run the loop to find the values in sheets (Database).Range(A1:A10000)

Hope it makes sense?


Kind Regards and million thanks in advance

Regards,

 

[luvbite38]

I've made the same query on OZGrid and the link is as follow

http://www.ozgrid.com/forum/showthread.php?t=164888&p=606524#post606524