Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA
Dear Dilipji, Thank you very much, It is working, but one problem It showing error when nothing is entered, I have tried to insert isserror formula, but not able insert it. if possible please revise my file. again thank you very much for your kind help On Sat, Jul 24, 2010 at 9:24 AM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Rahul, No doubt, concatenate and will do the task but for that we need to have a column on both d locations n we also need to check if this is feasible. But anyways both the ways are ok n there are other ways as well :) thx, DILIPandey On 7/24/10, Rahul Gandhi. myname.ra...@gmail.com wrote: I Think in particular this scenerio we have one more function of Concatenate or . that also helps us to do the same, at the other hand this formula is also very suitable for so many conditions.. Thanks again sir. On Jul 23, 6:33 pm, Dilip Pandey dilipan...@gmail.com wrote: Hi Hari, I have achieved the desired result using array functionality in Vlookup function. See the attached file and let me know if this helps. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jul 23, 2010 at 4:38 PM, HARI NAIR hari.shrin...@gmail.com wrote: I want to fill the basic rate column automatically from the rate column(Please refer the attached file, which considers all three columns factors, like, PO NO, Thickness. Width, Quality. Not a single column factor. Please Help, Any how, thanks to prajapatiji for sending me the solution which I earlier sent, in which only single colunm factor is looking (i.e. Quality) Regards, Hari -- -- 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 7000 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 DATA - Vlookup with multiple criteria - by DILIpandey.xls 91KViewDownload -- -- 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 7000 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 -- Sent from my mobile device Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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 7000 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
Re: $$Excel-Macros$$ Macro to clean up file
Hi JD, You forgot to attach file. Thanks Regards Sandeep On Sat, Jul 24, 2010 at 5:52 AM, JD 5635.daw...@gmail.com wrote: I am looking to clean up a file that gets sent to me weekly see example file.xlsx on file page. The file may look like the first tab the 1st week it is sent to me and like the second tab the 2nd week it is sent to me but I need it to look like the 3rd tab all the time for import into database. Can anyone help me with this? -- -- 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 7000 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 7000 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
Fwd: $$Excel-Macros$$ RE: Need macro for attd workbook
-- Forwarded message -- From: vidyut more vidyutm...@gmail.com Date: Thu, Jul 22, 2010 at 6:45 PM Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook To: excel-macros@googlegroups.com Sir i stuck in your macro. 1 ) filter is not working 2) I have usecanother macro for that sheet then where should i put ur macro. my macro as follows 'Private Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range Dim pcNum As Long Dim party As String Dim prod As String Dim ws As Worksheet Dim tgtRowNum As Long Dim lastDataRow As Long Set ws = ActiveSheet lastDataRow = ws.Range(A1).End(xlDown).Row 'end the procedure if the cursor is not in the first empty cell in column AIf Target.Column 1 Then Exit Sub If Target.Row lastDataRow Then Exit Sub 'find the last identifier With Range(A:A) 'The range to search On Error Resume Next Set Cell = .Find(Target.Value, ActiveCell, xlValues, xlWhole, xlByRows, xlPrevious) End With ' If Cell Is Nothing Then 'If a new number series is required, use an input box routine here Exit Sub Else pcNum = Cell.Offset(0, 8).Value prod = Cell.Offset(0, 1).Value party = Cell.Offset(0, 2).Value Target.Offset(0, 8).Value = pcNum + 1 Target.Offset(0, 1).Value = prod Target.Offset(0, 2).Value = party 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 7000 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$$ PR solved
Hi Hari look at this attd file -- -- 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 7000 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 PR solution.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Difference between VB and VBA
Hi all, I read from various forums/websites that it appears VB and VBA is highly similar and if I first learn VB then programming in VBA will have practically no problems at all. Is this correct ? I am a new starter to VB (and VBA), I am reasonably proficent with Excel and Excel formulas but would like to take my Excel expertise to another level. Any suggestion if I should first focus on 1. learning VB language first ? , or 2. just go directly into VBA. One side question and immediate difference I note in VBA and VB is In VB, I can do this Dim string1 As String = Test But I cannot do the same in VBA. In VBA, the above will pose an error and it appears it has to be broken up into two parts for it to work as follows:- Dim string1 As String string1 = Test Any ideas why ? -- -- 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 7000 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$$ Advanced Meta Data - Cut and Paste Issue
Hi all! The company I work for has an online filing system that allows clients to submit information in an excel spread sheet with advanced meta data in the formatting of each cell (including the cell name), which is then processed and converted to XBRL. We are having a problem because the users are able to cut and paste cells. When they cut and paste a cell, it copies the meta data and messes up the processing. I was wondering if there was a way to lock down the cells to stop users from cutting the meta data and ONLY cut (or copy) the cell values. I have seen a macro to disable cut and paste, which should work, but I wanted to know if there are any other options. Thanks for the help! Dinsdale -- -- 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 7000 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