Re: $$Excel-Macros$$ Filling in cells from cell above
Hi Steve, Please find attached excel for solution. Select the cells ( from first 3 columns) where you want to fill data and go to MyTools in menubar and press Fill Data. Regards, Swapnil. On Mon, Apr 26, 2010 at 9:59 AM, Steve sca...@aol.com wrote: I have spreadsheets of imported data from another program, so I have no control over the initial formatting of the data. The program puts out data but does not fill in every cell if it is the same data as the cell above it. I am sorting the data several different ways, and having blank cells is throwing me way off. I would like a macro that will go down a colum and, once it finds data, copy that data to every cell below it until it comes to another cell with existing data, then copy that new data to each cell below it etc. I would need to do this with the first 3 columns of the spreadsheet, but not further than the first three columns. I can manually put something at the bottom to let the macro know to move to the next column (or stop) pretty easily. For example, column A contains data only in rows 1, 10, 25, and 42. I would like it to copy the data from A,1 and insert it all the way down column A to row 9, then copy the data from A,10 and insert it all the way down to row 24, copy A,25 and insert it all the way down to row 41, etc. I can provide samples if necessary. Thanks, Steve sca...@aol.com -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.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. 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Fill Cell.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Do No copy excel file or data from that file
Hi, I saved a excel file on share drive. I want that everybody can access that file but unable to copy that file or data from that file without my permission. Is it possible? If yes, then tell me how? Regards, Vijay -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ please help me for Excel Conditional formula with example
Huh? Date: Mon, 26 Apr 2010 21:18:44 -0700 Subject: $$Excel-Macros$$ please help me for Excel Conditional formula with example From: vikask...@gmail.com To: excel-macros@googlegroups.com Dear All, Please help me for excel condition formula's, pls send formula with example ...pls it's a urgent. One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, We can't Spell S_ccess without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ New, Used, Demo, Dealer or Private? Find it at CarPoint.com.au http://clk.atdmt.com/NMN/go/206222968/direct/01/ -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ worksheet change event problem
Hi OSA, To prevent the user opening a workbook with macros disabled: Create a new sheet, and write on it in large text, You can't use this workbook with macros disabled. Use a workbook close macro to make all other sheets xlveryhidden. Use a workbook open macro to unhide all sheets except the new one, which should be hidden. Regards - Dave. Date: Tue, 27 Apr 2010 13:10:16 +0800 Subject: Re: $$Excel-Macros$$ worksheet change event problem From: osav...@gmail.com To: excel-macros@googlegroups.com Thank you Dave, The code you suggested worked fine. Although i discovered that the user can still open the file with macro disabled and change the cell content, save and reopen it. now I wish when the workbook is open, it checks the value of sheet1(D3) if equal to BRIDGESTONE COMPANY INC. if yes then continue, other wise close the workbook. On Tue, Apr 27, 2010 at 10:30 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, Try this code instead: Private Sub Worksheet_Change(ByVal Target As Excel.Range) On Error Resume Next If Sheets(Sheet1).Range(D3) BRIDGESTONE COMPANY INC. Then MsgBox FILE WILL BE CLOSED!!, vbOKOnly + vbExclamation MsgBox Please contact EDP ThisWorkbook.Close savechanges:=False End If End Sub Change the sheet name to suit. Regards - Dave. Date: Mon, 26 Apr 2010 16:30:04 +0800 Subject: $$Excel-Macros$$ worksheet change event problem From: osav...@gmail.com To: excel-macros@googlegroups.com Dear group, i try to catch the user's action via worksheet change event. My worksheet has a value at cell D6 that i would like to remain constant and if that value is change by user the workbook is closed. My problem now is, even if this values are unchanged but if any other range of cell is deleted, the macro is triggered which i really don't understand why? The macro is triggered when i delete a content of a cell range. but if a single cell is deleted nothing happens. any suggestion why is this so? here is my code. Private Sub Worksheet_Change(ByVal Target As Excel.Range) On Error Resume Next If Target = [$D$3] Then If Target.Value BRIDGESTONE COMPANY INC. Then MsgBox FILE WILL BE CLOSED!!, vbOKOnly + vbExclamation MsgBox Please contact EDP ThisWorkbook.Close savechanges:=False End If End If End Sub -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Australia's #1 job site If It Exists, You'll Find it on SEEK -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.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. 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ If It Exists, You'll Find it on SEEK. Australia's #1 job site
Re: $$Excel-Macros$$ Need a formula help
Thanks a lot for your solution. I got it.. Regards, Vinu. On Apr 24, 9:28 pm, Harsh Gharpure hsgharp...@gmail.com wrote: For the data range you have specified, following is the solution: A B C (formula) 25 0 -100 2 - = countif(a1:a7,0) - countif(a1:a7,100) 150 101 -200 1 -- = countif(a1:a7,100) - countif(a1:a7,200) 250 201 - 300 and so on 350 301 - 400 475 401-500 600 501-600. 50 601-700 You can modify the to suit your data regards, Harsh Gharpure On Sat, Apr 24, 2010 at 11:31 AM, Chandra Gupta cgmaury...@gmail.comwrote: Hello Here is your solution. Chandra Gupta On Sat, Apr 24, 2010 at 3:03 AM, vinu vinu1sm...@gmail.com wrote: Hello Frnds, I have a data like this: columnA -Data column B- range column c- Data in Range(Need formula for this), Please help me a formula to get the answer in column C. A B C 25 0 -100 2 ( Need a formula to count the col A data which appears in B Col Bracket) 150 101 -200 250 201 - 300 350 301 - 400 475 401-500 600 like this.. 50 Thanks is advance!! -- ------ 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.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. 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.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. 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe- Hide quoted text - - Show quoted text - -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Median Using Pivot
Hello All, How to calculate Median in Pivot. Regards Gopi Krishnan -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ How to compare two Excel sheets
Dear friends , i m waiting for reply, thanks On Apr 26, 8:59 pm, sudhir sudhir.p...@gmail.com wrote: Dear friends, I have two excel sheets, both are having same format, and contain huge amount of data. now i want to compare them, old one with the new one. and i want to find out which data is deleted, which one is added, and which one is changed. plz help me. -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Form controls disappear when copying sheet
Hi, I created a sheet in Excel 2007 and added a few buttons to it via the form controls toolbar. When I duplicate the sheet (right click-move or copy) I get a copy of the sheet but without the form controls. Any ideas? Thanks. -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Fw: $$Excel-Macros$$ Help required in creating xml from EXCEL
Hi All, My excel containd the following rows and columns: I want to convert this data into an xml file based on the path mentioned in the 2nd column Data Path Name ocim:root/ocim:name[xsi type:myname]/ocim:firstname Name2 ocim:root/ocim:name[xsi type:myname]/ocim:Lastname i doubt : is a problem in converting the data. The final xml shouldlook like the below : ocim:root ocim:name xsi:type:myname ocim:firstnameName/ocim:firstname ocim:lastnameName/ocim:lastname /ocim:name /ocim:root Can anybody help me regarding this? Thanks, Sravani -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel
Thanks Harpreetji, for your valuable solution I have an another problem, I have two excel sheets, both are having same format, and contain huge amount of data. now i want to compare them, old one with the new one. and i want to find out which data is deleted, which one is added, and which one is changed. plz help me. Thanks. On Sun, Apr 25, 2010 at 9:58 AM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Hi Sudhir, I think you are looking for How to group rows and columns?. Please find attached some information sourced from the net, i think this will give you complete details about it. Cheers! Harry -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ please help me for Excel macro for Hide and unhide the subheading in excel
Hi Sudhir, Would it be possible for you to attach both the sheets, i will try to work on it. If possible, please specify which sheet would serve as the master against which the other sheet will be compared. Cheers! Harry On Tue, Apr 27, 2010 at 9:25 PM, sudhir kumar sudhir.p...@gmail.com wrote: Thanks Harpreetji, for your valuable solution I have an another problem, I have two excel sheets, both are having same format, and contain huge amount of data. now i want to compare them, old one with the new one. and i want to find out which data is deleted, which one is added, and which one is changed. plz help me. Thanks. On Sun, Apr 25, 2010 at 9:58 AM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: Hi Sudhir, I think you are looking for How to group rows and columns?. Please find attached some information sourced from the net, i think this will give you complete details about it. Cheers! Harry -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help me in contitional formating
Hello, I want a conditional formating for the string found to be done in column F and colour the entire row. Example in cell F17 i found to be done then the entire row should colour next if it is in say cell F25 then it should colour entire row of that cell Regards, Vinod -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ FormulaArray with Named Ranges
Hi, I have a macro that refuses to run when it reaches the following command: StartCellR.Offset(1, 0).FormulaArray = =(Sum(AllBLs*(PF=Range(A6).Value))) AllBLs is a named range PF is a named range I am trying to get excel to sum the values in ALLBLs that correspond to a certain value in PF; that value is defined in Range(A6). Can anyone see what is wrong with my formula? Thanks a lot -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ How to compare two Excel sheets
HI Sudhir, You can create a new sheet and compare the two in it starting from the first cell . Use the formula = A1 in SHeet1=A1 in sheet2 . The similar cells will give TRUE as result and different will display FALSE. Sincere Regards, Anurag -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of sudhir Sent: Tuesday, April 27, 2010 8:21 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ How to compare two Excel sheets Dear friends , i m waiting for reply, thanks On Apr 26, 8:59 pm, sudhir sudhir.p...@gmail.com wrote: Dear friends, I have two excel sheets, both are having same format, and contain huge amount of data. now i want to compare them, old one with the new one. and i want to find out which data is deleted, which one is added, and which one is changed. plz help me. -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.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. 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ How to compare two Excel sheets
Sample workbook please. All formatting as origianl, and data you want compared. Dave Date: Tue, 27 Apr 2010 07:51:10 -0700 Subject: Re: $$Excel-Macros$$ How to compare two Excel sheets From: sudhir.p...@gmail.com To: excel-macros@googlegroups.com Dear friends , i m waiting for reply, thanks On Apr 26, 8:59 pm, sudhir sudhir.p...@gmail.com wrote: Dear friends, I have two excel sheets, both are having same format, and contain huge amount of data. now i want to compare them, old one with the new one. and i want to find out which data is deleted, which one is added, and which one is changed. plz help me. -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ If It Exists, You'll Find it on SEEK. Australia's #1 job site http://clk.atdmt.com/NMN/go/157639755/direct/01/ -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ FormulaArray with Named Ranges
Hi John, What is 'StartCellR'? Also, if you paste this formula {=(Sum(AllBLs*(PF=Range(A6).Value)))} straight into a cell, you will find that xl won't accept it. You can't enter VBA notation into a cell. Try: =SUM(AllBLs*(PF=A6)) Regards - Dave. Date: Tue, 27 Apr 2010 13:20:06 -0700 Subject: $$Excel-Macros$$ FormulaArray with Named Ranges From: johnw...@gmail.com To: excel-macros@googlegroups.com Hi, I have a macro that refuses to run when it reaches the following command: StartCellR.Offset(1, 0).FormulaArray = =(Sum(AllBLs*(PF=Range(A6).Value))) AllBLs is a named range PF is a named range I am trying to get excel to sum the values in ALLBLs that correspond to a certain value in PF; that value is defined in Range(A6). Can anyone see what is wrong with my formula? Thanks a lot -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ View photos of singles in your area! Looking for a hot date? http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- -- 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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe