Re: $$Excel-Macros$$ HELP needed for macro

2010-01-17 Thread ashish koul
hi check the file now On Sun, Jan 17, 2010 at 4:27 PM, aju chacko wrote: > HI ashish, >Thanks for reply.But I have some more requirements.The > third worksheet "consolidated" originally doesn't exists,I have created it > for an example.Actually the w.sheet named *SAP *will b

Re: $$Excel-Macros$$ HELP needed for macro

2010-01-17 Thread aju chacko
HI ashish, Thanks for reply.But I have some more requirements.The third worksheet "consolidated" originally doesn't exists,I have created it for an example.Actually the w.sheet named *SAP *will be created by downloading data from *ERP.*The w.sheet *physical* will be added to this

$$Excel-Macros$$ HELP needed for macro

2010-01-15 Thread aju chacko
HI VBA GURUS, I know excel pretty well,But my knowledge in VBA is big zero.I have two excel work sheets (SAP & PHY),both are arranged as table & *one common field (MATERIAL) *available in both sheets ,what I required* is a macro* that brings *quantity* from w.sheet PHY ag