Re: $$Excel-Macros$$ text and date in one cell
hi Prashanth Please find attached file as per your requirement. Dhartikumar On Thu, Nov 12, 2009 at 6:36 PM, Prashanth Banneni praba...@gmail.comwrote: Hi All, Can you help me how to get the desired output from the attached sheet. Many thanks in advance Best Prashanth -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe query(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need Urgent Help ~ Vlookup
Hello Experts, Once agian I am here with a new problem (Thanks for helping me earlier, on my code). This time I am stuck with Vlookup, actually I have a list of lot # for which I have to find TIC # from another table but the problem is it has got multiple occurances. Our simple vlookup picks the first one (as it alwasy does :-) ) . But I want all the values *(TIC #)* in column B (as Concatenated) for the *lot numbers* available in Column A from the table. I tried with INDEX and various formulas available on net..but not successful Hope to have a solution from you experts soon... (have attached the file wid bit explaination there too) Thanks!! ANISH -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Anish_Prob.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Excel Reminder
Hi Guys I needs your help, actually I have an excel file that basically contains date and the things to do on that date. e.g. 10/nov/09 - attend marriage 11/nov/09 - visit client 10/nov/09 - test and so on, now I want that whatever the to dos are there in the excel file to be done today (it may be more than one record), will comes as a popup or something like that when I open the file. Is it possible that the pop up will act as an reminder and shows my to dos after a specific interval, Something like a reminder. Regards Punit -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Need Urgent Help ~ Vlookup
Hi You can use the file attached below: Punit -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Anish_Prob(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Macro to Protect cell of a worksheet
Dear Friend, I need a Macro to Protect Cell of a work Sheet . Kindly help . it is Urgent . Thanks and regards Debashis. -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Fwd: $$Excel-Macros$$ Problem with Hyperlink
-- Forwarded message -- From: DEBASHIS BANERJEE debashis@gmail.com Date: Nov 12, 2009 1:34 PM Subject: $$Excel-Macros$$ Problem with Hyperlink To: excel-macros@googlegroups.com Dear Friends , I have workbook having multiple sheet. Each Page is connected with Hyperlink . Problem is that as soon as the file is closed , Hyperlinks disappear. It is continuing for several time that I have edited the hyperlink and it is disappearing . Kindly help how to solve this problem. -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup
Hi Punit, Thanks for you helping attempt, but tht's not wht I want. You used just vlookup in 2 cells...I m afraid to say tht but even I know tht much of basics (No offence). Could you please let me know wht if the occurance is 3 times. :P Cheers!! ANISH On Fri, Nov 13, 2009 at 3:06 PM, punit poddar p2pod...@gmail.com wrote: Hi You can use the file attached below: Punit -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet
Debashish, Could you please elaborate the requirement. If possible with an example workbook. Regards, Andy On Fri, Nov 13, 2009 at 5:03 PM, DEBASHIS BANERJEE debashis@gmail.comwrote: Dear Friend, I need a Macro to Protect Cell of a work Sheet . Kindly help . it is Urgent . Thanks and regards Debashis. -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup
Hi Anish, See the attached file. Don't change position of 'Auto Reset', 'Counter' and 'Auto Switch' else it may not work properly. Also it can be done easily with VBA, so if you need then ask the solution in VBA and you will get a quick response from the group. Regards Sandeep On Fri, Nov 13, 2009 at 1:01 PM, Anish Shrivastava anish@gmail.comwrote: Hello Experts, Once agian I am here with a new problem (Thanks for helping me earlier, on my code). This time I am stuck with Vlookup, actually I have a list of lot # for which I have to find TIC # from another table but the problem is it has got multiple occurances. Our simple vlookup picks the first one (as it alwasy does :-) ) . But I want all the values *(TIC #)* in column B (as Concatenated) for the *lot numbers* available in Column A from the table. I tried with INDEX and various formulas available on net..but not successful Hope to have a solution from you experts soon... (have attached the file wid bit explaination there too) Thanks!! ANISH -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Anish_Prob.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet
Yes, please, why do you need a macro to protect a cell? Do you understand how to lock a cell end turn on Protection? the manual process is: Select all cells in a worksheet. Select Format-Cells On Protection tab, remove check from Locked checkbox In Excel2007, the Protection is on the Review menu. Protect the document, if you don't want users to even be able to SELECT the locked cell, remove the check from the Select Locked Cells item. specifiy a password if you wish. Now... if you REALLY want a macro to do this, simply record a macro and do it manually. the password part is tricky though. it does not record. You have to add something like: , Password:=unlockplease what you end up with is: '-- Option Explicit Sub Lock_and_Protect() Cells.Select Selection.Locked = False Selection.FormulaHidden = False Range(B2).Select Selection.Locked = True Selection.FormulaHidden = False ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True ActiveSheet.EnableSelection = xlUnlockedCells End Sub Sub Protect_with_Password() ActiveSheet.Unprotect ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:=unlockplease End Sub Paul From: Aindril De aind...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, November 13, 2009 6:56:56 AM Subject: Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet Debashish, Could you please elaborate the requirement. If possible with an example workbook. Regards, Andy On Fri, Nov 13, 2009 at 5:03 PM, DEBASHIS BANERJEE debashis@gmail.com wrote: Dear Friend, I need a Macro to Protect Cell of a work Sheet . Kindly help . it is Urgent . Thanks and regards Debashis. -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ excel reminder
yes, that's fairly simple. But, since you didn't give us much to go on, I'll have to be pretty generic and make lots of assumptions. first of all, you'll need a macro (since you wrote to this group, you probably already knew that) I'll assume that the calender of events is on a sheet called Sheet1 and that the date is in column A AND IS AN ACTUAL DATE (not a text string) and the event is in column B and I'll further assume that your list starts in row 2 and can contain as many dates as there are rows! Also, ONLY rows that have dates in them are considered. There should be no blank dates within the list. Now, assuming all of that, the macro looks like: Option Explicit ' Sub Auto_Open() Remind_Me End Sub '- Sub Remind_Me() Dim nRows, I, msg, tDay, cnt nRows = Application.WorksheetFunction.CountA(Sheets(Sheet1).Range(A:A)) cnt = 0 msg = Format(Now, mm-dd-) Chr(13) Things to do today: Chr(13) For I = 2 To nRows If (DateDiff(d, Sheets(Sheet1).Cells(I, A).Value, Now) = 0) Then cnt = cnt + 1 msg = msg Chr(13) Sheets(Sheet1).Cells(I, B).Value End If Next I If cnt = 0 Then MsgBox Format(Now, mm-dd-) Chr(13) Chr(13) NOTHING planned for today! Else MsgBox msg End If End Sub The Auto_Open sub runs when the workbook is opened. if you need help putting this into a macro module, let us know. Paul From: punit poddar p2pod...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Fri, November 13, 2009 4:38:23 AM Subject: $$Excel-Macros$$ excel reminder Hi Guys I needs your help, actually I have an excel file that basically contains date and the things to do on that date. e.g. 10/nov/09 - attend marriage 11/nov/09 - visit client 10/nov/09 - test and so on, now I want that whatever the to dos are there in the excel file to be done today (it may be more than one record), will comes as a popup or something like that when I open the file. Is it possible that the pop up will act as an reminder and shows my to dos after a specific interval, Something like a reminder. Regards Punit -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Store Cell formatting
sorry.. I'm not much help there. I've never used .XLL files, and I'm HEAVILY into VBA... Perhaps someone else can give you the help you need. BTW: What version of Excel are you using? Paul From: Hemant Hegde hemantbales...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, November 12, 2009 1:40:43 PM Subject: Re: $$Excel-Macros$$ Re: Store Cell formatting Hi Paul Thank you for the suggestion. Whenever I have to format a sheet which requires complex formatting, I will always keep a hidden sheet which is already formatted. I will copy the default formatting (and also formulae) from the hidden sheet and paste it on the target sheet using ActiveSheet.paste and it is very quick. But in spite of that, the macro has to do a number of iterations (something like 2000*300) and it is very slow! Hidden sheet templates are already inter-linked to each other and contain a complex array of formulae (I have used them to decide which rows are to be deleted and which to be retained) We can easily guess why excel takes so much time when we are deleting/inserting rows. It has to update all the formulae in the workbook as the CELL ADDRESS CHANGES when we delete/insert a row (it does that even when calculation is set to XlManual and AS and WHEN we delete a row) I don't think simulation of a spreadsheet using code to accomplish this is feasible solution as im sure its going to be too complex. The only way to do this could be to use *.XLL files as these are already compiled and as fast as excel's built in functions. Where on the net can I get examples (open code of course) of working *.XLL files? If you know it yourself and want to help me, It will be very very nice and I will be grateful to you for the help.. thanking you Hemant Hegde 2009/11/12 Paul Schreiner schreiner_p...@att.net I'm not sure of any other ways, but one piece of advice: Determine what the default formatting is for the sheet. Save the default once. then, check the cells against the default. Only save those that DIFFER from the default (or perhaps only the features that are different) that way, when you restore the document, you first set the defaults for the sheet, then only process the differences. Paul From: Hemant Hegde hemantbales...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, November 11, 2009 10:55:41 AM Subject: $$Excel-Macros$$ Re: Store Cell formatting Hi Thank you Paul and RolfJ The file I want to save in binary format already contains 4 ararys of variable size (these are to store: the file version info, settings and user preferences, main data, and other data) The excel formatting I and values I am trying to save is just a part of the above said file. I dont want to create two files (one myformat.svi and another, excel.xls) but to include it in the same file. Furthermore I want the file to be as small as possible because the data to be save can be accounting transactions data which can run into any length... If I am able to convert different combinations (there wont be many) of cell formatting into a number (preferably between 0 - 255 so that i can store that as a Byte) It would make my file smaller than excel's own format. What I mean by different combinations is: a Byte with value 0 may mean [ Font color=Black, Backgroung color=white, Bold=False, Font =Arial] and a Byte with value 1 may mean [ Font color=Red, Backgroung color=white, Bold=True Font =Arial] and and so on untill its 255 and I think more combinations wont be required. Another important reason to do that is to avoid recalculation when the user makes only a small change which affects only few values (or formatting) in the final report.. I dont know if applying the cell formatting to each cell one after another takes same [or more :( ! ] amount of time as a total recalculation!! It will be nice if you advice me if I can do it in some other way. I heard *.DLL and *.XLL files are faster? will these help? Thank You Hemant Hegde On 10/11/2009, RolfJ r...@pacificsound.us wrote: Please explain why you don't save the worksheet resulting from your calculations in the intrinsic Excel format (i.e. as an Excel workbook). On Nov 8, 12:20 pm, Hemant Hegde hemantbales...@gmail.com wrote: Hi After a lot of coding and lengthy calculations (takes up to 2 minutes) I get a sheet (actually a report) with lot of numbers and different cell formatting. Now I need to store the cell values together with cell formatting in a binary file to avoid repeated lengthy calculations. The only option I able to think is to store all the formatting values one after another in the binary file eg. For cell's background colour, I will have to store the value of cells(1,1).interior.colorindex as a number and write it to the binary file. While opening the binary file, it has to read it and apply it back to the cell. Any better Idea? Im sorry
Re: $$Excel-Macros$$ unable to set the visible property of the worksheet class
The workbook is protected with a password. Norman May On Thu, Nov 12, 2009 at 11:09 AM, mahesh parab mahes...@gmail.com wrote: Dear All In attach sheet when i try to unhide sheet i am getting caption error. steps are mention on below mention link http://www.ehow.com/how_2132122_worksheet-another-user-cant-unhide.html In visual basic screen when i click on the sheet try to make visible in properties window. i am getting caption error.Anyone knw how to unhide worksheet through visual basic -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Problem with Hyperlink
Hi I don't know the exact reason for this problem. But I can suggest you to use HYPERLINK() Formula. Using this, you can make the hyperlinks dynamic, more stable (as u say it isn't right now) and intelligent! It can be little difficult but its is not a rocket science. You can google it or attach an example workbook here so that I can tell you how to start with it if you are interested. With Regards Hemant Hegde 2009/11/13 DEBASHIS BANERJEE debashis@gmail.com -- Forwarded message -- From: DEBASHIS BANERJEE debashis@gmail.com Date: Nov 12, 2009 1:34 PM Subject: $$Excel-Macros$$ Problem with Hyperlink To: excel-macros@googlegroups.com Dear Friends , I have workbook having multiple sheet. Each Page is connected with Hyperlink . Problem is that as soon as the file is closed , Hyperlinks disappear. It is continuing for several time that I have edited the hyperlink and it is disappearing . Kindly help how to solve this problem. -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ unable to set the visible property of the worksheet class
Hi Its because you have protected the workbook. Unprotect it Press Alt+t p w and then provide the password and then try :) Hemant Hegde 2009/11/12 mahesh parab mahes...@gmail.com Dear All In attach sheet when i try to unhide sheet i am getting caption error. steps are mention on below mention link http://www.ehow.com/how_2132122_worksheet-another-user-cant-unhide.html In visual basic screen when i click on the sheet try to make visible in properties window. i am getting caption error.Anyone knw how to unhide worksheet through visual basic -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file
On 11/12/09, Jitender jitenderdev...@gmail.com wrote: DEAR SIR/GURUS PLEASE SOLVE THE PUZZLE IN FILE . TRANSPOSE IS NOT A GOOD SOLUTION THANKS -- Jitender -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Jitender -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe PROBLEM.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup
Thanks Aindril for your help. N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later tht it wasnt a right way...was kinda frustrated in office.. :( On 11/13/09, Aindril De aind...@gmail.com wrote: Dear Anish, You would need a UDF for this: Use the following code : Option Explicit Public Function vlookupall$(strSearch As String, rngRange As Range, lngLookupCol As Long) 'Vlookupall searches in first column of rngRange for strSearch and returns corresponding 'values of column lngLookupCol if strSearch was found. All corr. values are collected and 'returned in one string (result of function). Dim i As Long If lngLookupCol rngRange.Columns.Count Then vlookupall = CVErr(xlErrValue) Exit Function End If vlookupall = For i = 1 To rngRange.Rows.Count If rngRange(i, 1).Text = strSearch Then vlookupall = vlookupall rngRange(i, lngLookupCol).Text , End If Next i End Function Insert a Module and Paste the above code in that. Then in the cell B2 type the new formula. The attached file has the solution. Thanks to : http://www.sulprobil.com/html/vlookupall.html *And for GOD's sake please donot write like what you had.. to someone who is trying to help you* This is a forum where everyone is welcome and we try to help each other. If by any chance someone is not able to help/understand your problem. Then someone else will help you. So please be patient. Tomorrow when you try to help someone you will not like that person writing like this to you... Right!!! Regards, Andy On Fri, Nov 13, 2009 at 5:45 PM, Anish Shrivastava anish@gmail.comwrote: Hi Punit, Thanks for you helping attempt, but tht's not wht I want. You used just vlookup in 2 cells...I m afraid to say tht but even I know tht much of basics (No offence). Could you please let me know wht if the occurance is 3 times. :P Cheers!! ANISH On Fri, Nov 13, 2009 at 3:06 PM, punit poddar p2pod...@gmail.comwrote: Hi You can use the file attached below: Punit -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel
$$Excel-Macros$$ Re: Clean - clear pivot cache Excel 2003
Hello again! This VBA code create 4 pivot table based on the same data cache; This is exactly what you have asked ! Want: a) vba routine to ensure that all pivots are based on the same pivot cache b) select one mother pivot cashe to be used by all pivots table Regards -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Excel Group (Outline) - Use VBA to hide or Show
Hi, I import a worksheet into a workbook on a regular basis. The worksheet has some predefined Row and Column Groupings. Using code I want to manage which rows are displayed and which are not. Some the rows I want to hide and those I do want to display are at different levels so a blanket rule like .Outline.ShowLevels Rowlevels:=2 just won't work. Other methods of hide/display such as ExcecuteExcel4Macro Show.Detail(1,5,FALSE,4) might be the way to go but my problem is the Worksheet I import is constantly changeing so the code has to be dynamic to recognise the level to display depending on the contents of the Row. Is there some way I can use Outline.ShowLevels.Rowlevels:=x so that I display up to level 2 for all rows between 1 and 20 and then display level 3 for all rows from row 21 to 60 for example. Any sugestions welcome Thanks Paul -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ hi
Hi Use this in X5 =SUMIF($T$5:$T$717,=X3,$M$5:$M$717) And this in Y5 =SUMIF($T$5:$T$717,=Y3,$M$5:$M$717) - SUMIF($T$5:$T$717,=X3,$M$5:$M$717) Then copy the Y5 formula and paste it in Z5 to AF5 Regards Sandeep - Original Message - From: Shraddha Shah To: excel-macros@googlegroups.com Sent: Friday, November 13, 2009 2:15 PM Subject: $$Excel-Macros$$ hi Hi, We are using the attached file to prepare certain reports for the bank. We need to actually bucket the all the deposits as per the maturities given. One of colleague is using this formula (highlighted in yellow). Can u suggest any other method. If not please help me with the same formula as im unable to use the same. Thanks Regards Shraddha Shah State Bank of Mauritius Tel - 2 2846 560 Ext (115) P Please don't print this e-mail unless you really need to. -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file
It's pretty easy to get the first part except: Where does the session data come from? Can you send me a file with more data to work with? Otherwise, I have to spend more time creating test data than doing the coding! Paul From: Jitender jitenderdev...@gmail.com To: jainayus...@gmail.com; excel-macros@googlegroups.com Sent: Fri, November 13, 2009 9:19:18 AM Subject: $$Excel-Macros$$ PLEASE SOLVE THE PROBLEM IN FILE ATTACHED i have not got the proper solution. please show in excel file On 11/12/09, Jitender jitenderdev...@gmail.com wrote: DEAR SIR/GURUS PLEASE SOLVE THE PUZZLE IN FILE . TRANSPOSE IS NOT A GOOD SOLUTION THANKS -- Jitender -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Jitender -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need Urgent Help ~ Vlookup
Its OK Anish, I can understand the frustration... I am also sorry for my hard words.. CHEERS!! Andy On Fri, Nov 13, 2009 at 9:09 PM, Anish Shrivastava anish@gmail.comwrote: Thanks Aindril for your help. N GROUP ...M REALLY SORRY For what I wrote...trust me I realized it later tht it wasnt a right way...was kinda frustrated in office.. :( On 11/13/09, Aindril De aind...@gmail.com wrote: Dear Anish, You would need a UDF for this: Use the following code : Option Explicit Public Function vlookupall$(strSearch As String, rngRange As Range, lngLookupCol As Long) 'Vlookupall searches in first column of rngRange for strSearch and returns corresponding 'values of column lngLookupCol if strSearch was found. All corr. values are collected and 'returned in one string (result of function). Dim i As Long If lngLookupCol rngRange.Columns.Count Then vlookupall = CVErr(xlErrValue) Exit Function End If vlookupall = For i = 1 To rngRange.Rows.Count If rngRange(i, 1).Text = strSearch Then vlookupall = vlookupall rngRange(i, lngLookupCol).Text , End If Next i End Function Insert a Module and Paste the above code in that. Then in the cell B2 type the new formula. The attached file has the solution. Thanks to : http://www.sulprobil.com/html/vlookupall.html *And for GOD's sake please donot write like what you had.. to someone who is trying to help you* This is a forum where everyone is welcome and we try to help each other. If by any chance someone is not able to help/understand your problem. Then someone else will help you. So please be patient. Tomorrow when you try to help someone you will not like that person writing like this to you... Right!!! Regards, Andy On Fri, Nov 13, 2009 at 5:45 PM, Anish Shrivastava anish@gmail.comwrote: Hi Punit, Thanks for you helping attempt, but tht's not wht I want. You used just vlookup in 2 cells...I m afraid to say tht but even I know tht much of basics (No offence). Could you please let me know wht if the occurance is 3 times. :P Cheers!! ANISH On Fri, Nov 13, 2009 at 3:06 PM, punit poddar p2pod...@gmail.comwrote: Hi You can use the file attached below: Punit -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to
