Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-11 Thread Puttu *
Thanks a lot Ashish, this is what exactly what i am looking. I small addition required, Once the Formula is placed and formula resulted converted to % format, the value should highlight in red font if the value is more than > 10% only for that result row. Is this possible? On Tue, Dec 11, 2012

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-10 Thread Puttu *
please help on this request.. On Mon, Dec 10, 2012 at 6:46 PM, Puttu * wrote: > Any update experts? > > > On Mon, Dec 10, 2012 at 2:02 PM, Puttu * wrote: > >> Thanks for your response David, >> >> Sorry If I wasn't clear. Below is the answer for your questions. Attached >> is the reports an

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-10 Thread Puttu *
Yogananda thanks for your prompt response. My requiements is below 1. I have more than 5-10 work book in the folder 2. Macro should open one workbook and copy the data and past it new workbook called as master and close the source workbook 3. Again it should open 2nd workbook and copy and past th

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-10 Thread Puttu *
Any update experts? On Mon, Dec 10, 2012 at 2:02 PM, Puttu * wrote: > Thanks for your response David, > > Sorry If I wasn't clear. Below is the answer for your questions. Attached > is the reports and master excel how i am expecting. > Let me know if you need any other details > On Mon, Dec 10,

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-09 Thread David Grugeon
Insufficient information provided. You have posted 4 apparently identical workbooks although Report1.xls is slightly larger than the others so there must be some difference. What is it? Could you provide a workbook called, say, Result.xls with at least 2 or the source reports included. This wil

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-09 Thread Puttu *
any help Moderator could you please help on this On Mon, Dec 10, 2012 at 11:24 AM, Puttu * wrote: > can any one please... > > Need a macro to 5 workbook data to paste in single workbook, on one by one > in the same sheet > > > On Mon, Dec 10, 2012 at 12:05 AM, Puttu * wrote: >

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-09 Thread Puttu *
can any one please... Need a macro to 5 workbook data to paste in single workbook, on one by one in the same sheet On Mon, Dec 10, 2012 at 12:05 AM, Puttu * wrote: > SOME ONE HELP ME PLS > > > On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote: > >> Yogananda thanks for your prompt response

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-09 Thread Puttu *
SOME ONE HELP ME PLS On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote: > Yogananda thanks for your prompt response. > > My requiements is below > > 1. I have more than 5-10 work book in the folder > 2. Macro should open one workbook and copy the data and past it new > workbook called as master

Re: $$Excel-Macros$$ Need a macro multiple workbook in one new workbook

2012-12-08 Thread Puttu *
Experts please help me Need multiple data to pasted in one single workbook On Sat, Dec 8, 2012 at 7:38 PM, Puttu * wrote: > Hi Experts > > I need a macro where i can use multiple workbooks to in single new workbook > > 1. I have multiple workbook in perticular folder, all that workbook used > r