Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
this was not your requirement earlier!! chek this..When you run macro, 1st you ask fro whole range containing data, in this example you need to select range D2 to H23, after that you will be asked for destination column where you need result, here you need to select whole column like column J. macro will process data & you will get out put in column J. Cheer!! + *I did not do this for you. God is here working through me for you.* On Wed, Oct 1, 2014 at 12:01 AM, SUDHIR VERMA wrote: > yes i was checked this but not work after alteration in column and > secondly if there is need to increase column no action work. > > thanx > > On 30 September 2014 23:37, Vaibhav Joshi wrote: > >> Sudhir >> >> Did you checked this >> -- Forwarded message -- >> From: "Vaibhav Joshi" >> Date: Sep 27, 2014 2:38 PM >> Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE >> TEXT) >> To: "excel-macros@googlegroups.com" >> Cc: >> >> Hi >> >> Check this.. click blue button to run macro! >> >> Cheers!! >> >> + >> *I did not do this for you. God is here working through me for you.* >> >> On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA >> wrote: >> >>> Dear Experts, >>> >>> Kindly resolve my problem. >>> >>> Explanation in attached workbook. >>> >>> Thanking You >>> >>> Regards >>> Sudhir >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, se
Re: $$Excel-Macros$$ Need help to mail userform on outlook body
Send us user form with sample data in it . On Oct 1, 2014 3:17 AM, "Sunil Patil" wrote: > Hi firends, > > i have one project. on sheet1 i have modless userform and some values. I > need a vba code in such a way that i can mail the value and userform to > outlook mail body, > so i can perform some action once its pasted into outlook body,, if i lick > on ok it will display msgbox to me, > > please help me sending userform from excel to outlook body, > > regards, > Sunil > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need help to mail userform on outlook body
Hi firends, i have one project. on sheet1 i have modless userform and some values. I need a vba code in such a way that i can mail the value and userform to outlook mail body, so i can perform some action once its pasted into outlook body,, if i lick on ok it will display msgbox to me, please help me sending userform from excel to outlook body, regards, Sunil -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
yes i was checked this but not work after alteration in column and secondly if there is need to increase column no action work. thanx On 30 September 2014 23:37, Vaibhav Joshi wrote: > Sudhir > > Did you checked this > -- Forwarded message -- > From: "Vaibhav Joshi" > Date: Sep 27, 2014 2:38 PM > Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT) > To: "excel-macros@googlegroups.com" > Cc: > > Hi > > Check this.. click blue button to run macro! > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA > wrote: > >> Dear Experts, >> >> Kindly resolve my problem. >> >> Explanation in attached workbook. >> >> Thanking You >> >> Regards >> Sudhir >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Fwd: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
Sudhir Did you checked this -- Forwarded message -- From: "Vaibhav Joshi" Date: Sep 27, 2014 2:38 PM Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT) To: "excel-macros@googlegroups.com" Cc: Hi Check this.. click blue button to run macro! Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA wrote: > Dear Experts, > > Kindly resolve my problem. > > Explanation in attached workbook. > > Thanking You > > Regards > Sudhir > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. search problem.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
Dear All, Kindly help. On 27 September 2014 14:38, Vaibhav Joshi wrote: > Hi > > Check this.. click blue button to run macro! > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA > wrote: > >> Dear Experts, >> >> Kindly resolve my problem. >> >> Explanation in attached workbook. >> >> Thanking You >> >> Regards >> Sudhir >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Report
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill wrote: > Hi Vaibhav, > > It is working perfect, as per my requirement. Will email if incase I need > any further updates. > > Thank you very much, you made my work easy. > > > > On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi wrote: > >> Cheers >> On Sep 29, 2014 9:58 PM, "joseph camill" wrote: >> >>> Hi Vaibhav, >>> >>> Thank you for the file and working on suggested changes. It is very >>> helpful. Will have a look in detail and will revert. >>> >>> It is really a great one. >>> >>> On Mon, Sep 29, 2014 at 2:32 PM, Vaibhav Joshi wrote: >>> 1. Create folder name based on "STD" - Ok 2. Have just one pdf with all the reports. - Chk attachments 3. Right now it is generating the name using "Offset" i suppose, Can we do a search for "Name" and then generate. - Do you want for few employees? then paste employee name in range U then report for only those employee will be generated. If you want report for all employees then keep Column U as blank. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 28, 2014 at 9:02 PM, joseph camill >>> > wrote: > Hi Vaibhav, > > Thank you for the file. It is very helpful. Is it possible to make > three changes. > > 1. Create folder name based on "STD" > 2. Have just one pdf with all the reports. > 3. Right now it is generating the name using "Offset" i suppose, Can > we do a search for "Name" and then generate. > > > > On Sun, Sep 28, 2014 at 8:58 PM, joseph camill < > joseph.cam...@gmail.com> wrote: > >> Hi Vaibhav, >> >> Thank you for the file. It is very helpful. It creates various PDF as >> per the Name, Is it possible to have just one pdf with all the mark >> sheet. >> >> On Sun, Sep 28, 2014 at 7:06 PM, joseph camill < >> joseph.cam...@gmail.com> wrote: >> >>> Hi Vaibhav, >>> >>> Thank you for the solution. I will check it and get back to you. >>> >>> Thanks and regards, >>> Joseph >>> On Sep 27, 2014 3:43 PM, "Vaibhav Joshi" wrote: >>> Hey Chek attachment, just click on blue button & folder name Test will be created on desktop & report card will be saved name wise in PDF file.. if you get error getting pdf file ensure you have installed extension from this link: http://www.microsoft.com/en-in/download/details.aspx?id=9943 Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 27, 2014 at 4:10 AM, joseph camill < joseph.cam...@gmail.com> wrote: > Hi, > > I am working on a project where I need to print 100 report card at > a time either directly to a printer or as PDF. > > Attached is the example workbook. All my data will be entered in > sheet named "Raw" and my output should look like sheet named "Final". > > Is it possible to print it to PDF / printer without having to > create number of sheets? > > Thank you in advance. > > Regards, > Joseph > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna > be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, > send an email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com > . > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > >>>
Re: $$Excel-Macros$$ Fwd: Merge files with few criteria of pasting
Check this file.. How to use? Put your all files which you want to import under one folder.. Open this file & click on button to run macro... Macro will open files one by one...chk for inventory sheet copy & paste data in inventory sheet of this file & so as with sheet name others...rest all sheets will be ignored.. Do revert if any query! Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 3:07 PM, Vaibhav Joshi wrote: > also what should be Update Date, Date of Consolidation? > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Sep 30, 2014 at 2:30 PM, Vaibhav Joshi wrote: > >> you didnt gave format of Inventory worksheet in Output >> >> + >> *I did not do this for you. God is here working through me for you.* >> >> On Tue, Sep 30, 2014 at 3:32 AM, Vinod Narayanan >> wrote: >> >>> Hi Gurus, >>> >>> >>> >>> Need your help!. I need to consolidate many files received from various >>> branches from time to time basis. Attached is the sample file wherein I >>> have added 2 worksheets. One is the input file received from Branches and >>> another the Output file. >>> >>> >>> >>> *Input file:* >>> >>> >>> >>> As there files are saved thru a secured server, the filenames are auto >>> generated and the branch name is mentioned in Cell B2 only(Due to some >>> reason, B2 and C2 are merged) >>> >>> It will has many worksheets within it. But I’m need to consolidate >>> worksheet ‘Inventory’ and ‘Others’ with to their respective worksheets in >>> the output consolidated file. >>> >>> >>> >>> *Output file (Consolidated file):* >>> >>> >>> >>> As I mentioned above, information from “Inventory” should be saved in >>> Inventory worksheet in Output file and ‘Others’ worksheet in ‘Others’ in >>> Output file. >>> >>> >>> >>> Some complications: >>> >>> · Name of the Branch (Cell B2) need to be saved in each row >>> whether the respective branch detail are pasted in Output file Col D. >>> >>> · Input file – Col A to C need to be pasted in Output file - >>> Col E to G >>> >>> · Input file – Col E to M need to be pasted in Output file - >>> Col H to P >>> >>> >>> >>> >>> >>> Hope I was able to provide the required information for creating a macro. >>> >>> >>> >>> Regards >>> >>> Vinod >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Macro import data from multiple files - 2 sheets.xlsb Description: appl
Re: $$Excel-Macros$$ Fwd: Merge files with few criteria of pasting
also what should be Update Date, Date of Consolidation? + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 2:30 PM, Vaibhav Joshi wrote: > you didnt gave format of Inventory worksheet in Output > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Sep 30, 2014 at 3:32 AM, Vinod Narayanan > wrote: > >> Hi Gurus, >> >> >> >> Need your help!. I need to consolidate many files received from various >> branches from time to time basis. Attached is the sample file wherein I >> have added 2 worksheets. One is the input file received from Branches and >> another the Output file. >> >> >> >> *Input file:* >> >> >> >> As there files are saved thru a secured server, the filenames are auto >> generated and the branch name is mentioned in Cell B2 only(Due to some >> reason, B2 and C2 are merged) >> >> It will has many worksheets within it. But I’m need to consolidate >> worksheet ‘Inventory’ and ‘Others’ with to their respective worksheets in >> the output consolidated file. >> >> >> >> *Output file (Consolidated file):* >> >> >> >> As I mentioned above, information from “Inventory” should be saved in >> Inventory worksheet in Output file and ‘Others’ worksheet in ‘Others’ in >> Output file. >> >> >> >> Some complications: >> >> · Name of the Branch (Cell B2) need to be saved in each row >> whether the respective branch detail are pasted in Output file Col D. >> >> · Input file – Col A to C need to be pasted in Output file - >> Col E to G >> >> · Input file – Col E to M need to be pasted in Output file - >> Col H to P >> >> >> >> >> >> Hope I was able to provide the required information for creating a macro. >> >> >> >> Regards >> >> Vinod >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Fwd: Merge files with few criteria of pasting
you didnt gave format of Inventory worksheet in Output + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 3:32 AM, Vinod Narayanan wrote: > Hi Gurus, > > > > Need your help!. I need to consolidate many files received from various > branches from time to time basis. Attached is the sample file wherein I > have added 2 worksheets. One is the input file received from Branches and > another the Output file. > > > > *Input file:* > > > > As there files are saved thru a secured server, the filenames are auto > generated and the branch name is mentioned in Cell B2 only(Due to some > reason, B2 and C2 are merged) > > It will has many worksheets within it. But I’m need to consolidate > worksheet ‘Inventory’ and ‘Others’ with to their respective worksheets in > the output consolidated file. > > > > *Output file (Consolidated file):* > > > > As I mentioned above, information from “Inventory” should be saved in > Inventory worksheet in Output file and ‘Others’ worksheet in ‘Others’ in > Output file. > > > > Some complications: > > · Name of the Branch (Cell B2) need to be saved in each row > whether the respective branch detail are pasted in Output file Col D. > > · Input file – Col A to C need to be pasted in Output file - Col > E to G > > · Input file – Col E to M need to be pasted in Output file - Col > H to P > > > > > > Hope I was able to provide the required information for creating a macro. > > > > Regards > > Vinod > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
