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 at 10:57 PM, ashish koul <koul.ash...@gmail.com> wrote: > try the attachment > > paste the full path of files in column A and run the macro > > Regards > Ashish > > > > > On Tue, Dec 11, 2012 at 12:56 PM, Puttu * <puttu...@gmail.com> wrote: > >> please help on this request...... >> >> >> On Mon, Dec 10, 2012 at 6:46 PM, Puttu * <puttu...@gmail.com> wrote: >> >>> Any update experts? >>> >>> >>> On Mon, Dec 10, 2012 at 2:02 PM, Puttu * <puttu...@gmail.com> 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, 2012 at 12:52 PM, David Grugeon >>>> <da...@grugeon.com.au>wrote: >>>> >>>>> 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? --> *Attached is the new smaple 4 worksheets* >>>>> >>>>> Could you provide a workbook called, say, Result.xls with at least 2 >>>>> or the source reports included. This will give us much more information. >>>>> --> *Final all the 4 or 5 reports data should be saved in new >>>>> worksheet called Master Workbook (Attached is the final result one* >>>>> >>>>> Will the source workbooks always have only 1 sheet called 16.0, or >>>>> will there sometimes be more than one sheet in the workbooks or will the >>>>> sheet names vary?* It will be the same every time* >>>>> >>>>> With regard to requirement 3 *(**3. This procedure should continue >>>>> untile i say no more workbook to use)*. Computers do not normally >>>>> respond to spoken commands. Do you want it to process all the files in >>>>> the >>>>> folder, or do you want a message box to come up after each one with "Do >>>>> you >>>>> want me to process another?" and yes and no buttons. *--> I need >>>>> message box to popped up for every report Whether I need to process >>>>> another >>>>> or not* >>>>> >>>>> Are the files to be consolidated in a single directory? Is it the >>>>> same directory as the summary file (with the code) will be in? If not >>>>> what >>>>> is its full path? --> *Yes all the file in same directory and yes >>>>> result/Master report also should be in same directory* >>>>> Are they the only files in that directory? *Yes* >>>>> >>>>> Full answers to these questions will get us a lot nearer to being able >>>>> to produce some workable code. >>>>> >>>>> >>>>> Regards >>>>> David Grugeon >>>>> >>>>> >>>>> >>>>> On 10 December 2012 15:54, Puttu * <puttu...@gmail.com> 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 * <puttu...@gmail.com> wrote: >>>>>> >>>>>>> SOME ONE HELP ME PLS.... >>>>>>> >>>>>>> >>>>>>> On Sun, Dec 9, 2012 at 4:42 PM, Puttu * <puttu...@gmail.com> 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 and close the source workbook >>>>>>>> 3. Again it should open 2nd workbook and copy and past the data to >>>>>>>> master workbook and close it. >>>>>>>> 4. In the same way it should continioue untile i say no more >>>>>>>> workbook for selction >>>>>>>> 5. all the workbook data should be pasted in the same Master >>>>>>>> workbook sheet1 one by one below giving the one row space. >>>>>>>> >>>>>>>> Let me know if you need any help..... >>>>>>>> >>>>>>>> >>>>>>>> On Sun, Dec 9, 2012 at 12:10 AM, yogananda muthaiah < >>>>>>>> yogananda.mutha...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> Please try this if this can work out for u >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Sat, Dec 8, 2012 at 10:21 PM, Puttu * <puttu...@gmail.com>wrote: >>>>>>>>> >>>>>>>>>> Experts please help me >>>>>>>>>> >>>>>>>>>> Need multiple data to pasted in one single workbook >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Sat, Dec 8, 2012 at 7:38 PM, Puttu * <puttu...@gmail.com>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 range data need to be copied to single work book. >>>>>>>>>>> 2. Every single workbook end of the data it should show the >>>>>>>>>>> comparasion result formula =(B56-B55)/B55, row back ground coloured >>>>>>>>>>> yellow >>>>>>>>>>> and any thing more than >10% should be highlighted in different >>>>>>>>>>> font color >>>>>>>>>>> 3. This procedure should continue untile i say no more workbook >>>>>>>>>>> to use >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Attached is the sample report with one example >>>>>>>>>>> >>>>>>>>>>> Any help is much appreciated. >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Putta >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Join official Facebook page of this forum @ >>>>>>>>>>> https://www.facebook.com/discussexcel >>>>>>>>>>> >>>>>>>>>>> FORUM RULES >>>>>>>>>>> >>>>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >>>>>>>>>>> Need >>>>>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>>>>> 2) Don't post a question in the thread of another member. >>>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any >>>>>>>>>>> security measure. >>>>>>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>>>>>> 5) Jobs posting is not allowed. >>>>>>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>>>>> >>>>>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>>>>> owners and members are not responsible for any loss. >>>>>>>>>>> --- >>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>> Google Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>>>>> To post to this group, send email to >>>>>>>>>>> excel-macros@googlegroups.com. >>>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>>> excel-macros+unsubscr...@googlegroups.com. >>>>>>>>>>> Visit this group at >>>>>>>>>>> http://groups.google.com/group/excel-macros?hl=en. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Putta >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Join official Facebook page of this forum @ >>>>>>>>>> https://www.facebook.com/discussexcel >>>>>>>>>> >>>>>>>>>> FORUM RULES >>>>>>>>>> >>>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >>>>>>>>>> Need >>>>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>>>> 2) Don't post a question in the thread of another member. >>>>>>>>>> 3) Don't post questions regarding breaking or bypassing any >>>>>>>>>> security measure. >>>>>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>>>>> 5) Jobs posting is not allowed. >>>>>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>>>> >>>>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>>>> owners and members are not responsible for any loss. >>>>>>>>>> --- >>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>> Google Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>>>> To post to this group, send email to >>>>>>>>>> excel-macros@googlegroups.com. >>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>> excel-macros+unsubscr...@googlegroups.com. >>>>>>>>>> Visit this group at >>>>>>>>>> http://groups.google.com/group/excel-macros?hl=en. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> Yogananda Muthaiah >>>>>>>>> Ph : 973 123 7267 >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Join official Facebook page of this forum @ >>>>>>>>> https://www.facebook.com/discussexcel >>>>>>>>> >>>>>>>>> FORUM RULES >>>>>>>>> >>>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and >>>>>>>>> Need >>>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>>> 2) Don't post a question in the thread of another member. >>>>>>>>> 3) Don't post questions regarding breaking or bypassing any >>>>>>>>> security measure. >>>>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>>>> 5) Jobs posting is not allowed. >>>>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>>> >>>>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>>>> owners and members are not responsible for any loss. >>>>>>>>> --- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>>> . >>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>> excel-macros+unsubscr...@googlegroups.com. >>>>>>>>> Visit this group at >>>>>>>>> http://groups.google.com/group/excel-macros?hl=en. >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Putta >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Putta >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Putta >>>>>> >>>>>> -- >>>>>> Join official Facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>> Advice will not get quick attention or may not be answered. >>>>>> 2) Don't post a question in the thread of another member. >>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>> measure. >>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>> 5) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>> and members are not responsible for any loss. >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>> To unsubscribe from this group, send email to >>>>>> excel-macros+unsubscr...@googlegroups.com. >>>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en >>>>>> . >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>>> Join official Facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> 2) Don't post a question in the thread of another member. >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> 5) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>> To unsubscribe from this group, send email to >>>>> excel-macros+unsubscr...@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> Putta >>>> >>> >>> >>> >>> -- >>> Putta >>> >> >> >> >> -- >> Putta >> >> -- >> Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> > > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *http://www.excelvbamacros.com/* > *http://www.accessvbamacros.com/* > > P Before printing, think about the environment. > > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Putta -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
