Re: $$Excel-Macros$$ User form Query box
hi Ashish, Pl provide the solution, if you can. On Sunday, October 7, 2012 11:48:00 AM UTC+5:30, prabhat.sh...@gmail.com wrote: Hi Ashish, The excel list is consists of account nos in text format in column A i.e. 05223300056, 05223300057, 05223300058 so on rest will be done by query excel forms/input box. Regards, Prabhat Shrivastava On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote: can you share the sample file On Sun, Oct 7, 2012 at 11:03 AM, prabhat.sh...@gmail.com prabhat.sh...@gmail.com wrote: This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. -- *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 (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: User form Query box
On Sunday, October 7, 2012 11:03:46 AM UTC+5:30, prabhat.sh...@gmail.com wrote: This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: User form Query box
On Sunday, October 7, 2012 11:03:46 AM UTC+5:30, prabhat.sh...@gmail.com wrote: This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ User form Query box
Hi Ashish, The excel list is consists of account nos in text format in column A i.e. 05223300056, 05223300057, 05223300058 so on rest will be done by query excel forms/input box. Regards, Prabhat Shrivastava On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote: can you share the sample file On Sun, Oct 7, 2012 at 11:03 AM, prabhat.sh...@gmail.com javascript: prabhat.sh...@gmail.com javascript: wrote: This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- *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 (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ User form Query box
This group help me a lot for ma assignment time to time, I m really happy to be the member of this group. here again, I've some query require help from expert of this group. I need to create a user input form. I've a list of data in a particular excel spreadsheet, what I want is as soon i entered the data in input box of excel that run a query (may be with vlookup or find command) return me with the result that Data Available or Data Not Available, if the data is available than, it should store in separate sheet or else make input box blank again to enter next record. all the data would be in text format unique. Request your help to get a sample sheet with the above condition, Thanks for help in this matter. Thanks Regards, Prabhat Shrivastava -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Re: Find the cell value from other sheet
thanks don for your kind help, rajan, your function giving some error... anyways thanks a lot to you both, this is really very to seeing people helping other with their skills Thanks Ashish for creating such a nice group with good people like, Don, Rajan, Noorain, Dipilthanks buddy for your kind, I'm glad to be the member of such a nice group.. On Sunday, April 29, 2012 10:09:53 PM UTC+5:30, prabhat.sh...@gmail.com wrote: Dear Frnds, I've a data sheet(reports) containing some data text in several row of entire sheet have another sheet(user ids) in column A containing few words these words may be or may not be the part of other sheet(report) text in cell of column A, now i wanna know if the sheet(user ids) text mentioned in column A are available in entire sheet(reports) or not, if yes than column B contain the result as Found. Regards, Prabhat Shrivastava -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Find the cell value from other sheet
Dear Frnds, I've a data sheet(reports) containing some data text in several row of entire sheet have another sheet(user ids) in column A containing few words these words may be or may not be the part of other sheet(report) text in cell of column A, now i wanna know if the sheet(user ids) text mentioned in column A are available in entire sheet(reports) or not, if yes than column B contain the result as Found. Regards, Prabhat Shrivastava -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Find the cell value from other sheet
Thanks for your revert rajan, but i've one query ma sheet(report) contains text line as A112354 xyz abc etc or xyz A112354 abc etc in several row of sheet and other sheet(user id) contains only A1123 now i want to know if A1123 available in sheet(report) or nt... Regards, Prabhat S -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Macro to search text based on an array
Files contains user ids.. Regards, Prabhat S -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Macro to search text based on an array
Actually these files are thr part of some imported system reports of ma bank which can not be transit outside the bank, Hence can't share, we create a sample file at our own by giving subject as below Report name date USER IDS DATETIMEREASON Pls copy paste these details in text file n create i cant this as m away frm ma pc. Thanks for your kind help. Regards, Prabhat S -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Macro to search text based on an array
Dear Experts, I'm preparing a macro to checks some reports, I have a folder that contains some text files with user ids other details with different files names an excel sheet contains the user ids. Now i wanna know if any of user ids mentioned in excel sheet are matching with user ids mentioned in any of text files saved in particular folder. thanks for your kind help in advance... Regards, Prabhat Shrivastava -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Macro to search text based on an array
Hi rajan, Thks fot yr revert, there arnd morethan 10 text files with diffrent headers but all files having the user ids as mentioned on excel sheet. Awaitaing yr response in this.. Regards, Prabhat S -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ lotus notes email
Dear all, pl help me to get the e mail ids that mentioned in a excel to copy at recipient of lotus notes... Say suppose that e mail ids mentioned in a excel particular cell i.e. cell c1, i want that all email ids get copied and paste at receipint of lotus note... Thanks fot your help in advace. Regards, Prabhat S -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how to send mails from lotus notes
Hi noorain, thanks for your support..can the result be provided on 2003 version. NOORAIN ANSARI wrote: Dear Prabhat, Please visit on http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html See attached sheet -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Fri, Feb 17, 2012 at 10:56 PM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: hello experts, request you all to share a macro to send email contains the data report from excel sheet as body of mail to particular receipients. pl share a example workbook for better undrstanding... thanks in advance.. regards.prabhat -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ how to create a user form return with vlookup query
I've a database with following headers Query ref nolocationCustomer name Query resolution Query120112-001 delhi xyz xyz abc Now i want help to create a forn in which if i entered the above query ref than all corrosponded details should return either as display box from where one shud copy the detail to other sheet, pls help me to create the user form as m very new in same... -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ vlookup return with pcture assinged
Hi, can u pls explain the formula being used in this sheet. On Oct 14, 9:45 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear prabhat, Please find attached sheet in Excel 2003 Version. Hope it help to u -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Oct 14, 2011 at 8:23 PM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: The file need to run on ms excel 2003 version. Rgrds.Prabhat On Oct 14, 12:03 pm, ashish koul koul.ash...@gmail.com wrote: see if it helps On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: Good morning experts Need your valueable help to complete ma project, i have three n more pics in name of ram, shyam, n more pasted on diffrent sheet now i want if i write ram in a assinged cell ram's pic appear in selected area of sheet n so on. I dont wanna use macro for thisi need this to complete ma project. Thanks n regards, Prabhat Shrivastava -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. images_index.xlsx 55KViewDownload -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Image_Fatching example1.xls 59KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ vlookup return with pcture assinged
Good morning experts Need your valueable help to complete ma project, i have three n more pics in name of ram, shyam, n more pasted on diffrent sheet now i want if i write ram in a assinged cell ram's pic appear in selected area of sheet n so on. I dont wanna use macro for thisi need this to complete ma project. Thanks n regards, Prabhat Shrivastava -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ vlookup return with pcture assinged
The file need to run on ms excel 2003 version. Rgrds.Prabhat On Oct 14, 12:03 pm, ashish koul koul.ash...@gmail.com wrote: see if it helps On Fri, Oct 14, 2011 at 9:46 AM, prabhat.shrivasta...@gmail.com prabhat.shrivasta...@gmail.com wrote: Good morning experts Need your valueable help to complete ma project, i have three n more pics in name of ram, shyam, n more pasted on diffrent sheet now i want if i write ram in a assinged cell ram's pic appear in selected area of sheet n so on. I dont wanna use macro for thisi need this to complete ma project. Thanks n regards, Prabhat Shrivastava -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. images_index.xlsx 55KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ How to lookup multiple data range
Dear All, I want to know the to a lookup value from multiple data range or data files. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Fwd: Can you break password of attached sheet also let me solution.
how u unprotected this file??? Wot is the mathod to unprotect a file On Apr 6, 6:35 pm, Mudassar Ramzan johnplaye...@gmail.com wrote: Please find unprotected file and VBA password is 12345. Thanks regards, || Mudassar Ramzan | MIS Officer | WorldCALL Telecom Ltd | 061- 814-3999 | 0321 7325277 || - Original Message - From: Abdul Hakim Khan To: excel-macros@googlegroups.com Sent: Monday, April 06, 2009 3:45 PM Subject: $$Excel-Macros$$ Fwd: Can you break password of attached sheet also let me solution. Dear All Plz help me for password removal of attached sheet. Press alt + F11 then click on module while prompted for password. Please help me for breaking password. Thanks Regards, Abdul Hakim Khan engg[1]..xls 3963KViewDownload --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---