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.
