$$Excel-Macros$$ Help breaking out data on single worksheet to multiple worksheets

We have raw data sheets that deal with data for multiple client accounts. There may be multiple different rows associated with a single account number, and several thousand account numbers in total. The account number is in column A. Our goal is to take a single worksheet and break it out into m

Re: $$Excel-Macros$$ EXCEL SHORTCUT -- PLEASE HELP :-)

Thanks so much! I tried every other combination, except tab! Huge time saver! On May 7, 2:54 am, Sandeep Kumar Maurya wrote: > When we write function in any excel cell, EXCEL 2007 shows us a list of > functions available from the word or character we written in the cell. > > Michael wants to kno

$$Excel-Macros$$ Need macro help - Need to sort, cut and paste

Good morning everybody - I am still quite a novice when it comes to VB and writing codes, so any help I can get would be greatly appreciated. I am currently working on a code that takes data from a xls file that I download and convert it to a text file. I found an older posting with an example t

Re: $$Excel-Macros$$-Macro to Prepare Letters

> > Hello Team, > > I am using macro for mail merge and wanna know how to make changes in font > type and how to bold a particular line/word while doing mail merge > > Thanks and Regards > Atul Kesaria > > On Wed, May 12, 2010 at 11:18 PM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wro

Re: $$Excel-Macros$$ Need help in automating this report

Hi Girish, Thanks a ton for working on this report. You are great. You have made my day. Thanks & Regards, Yogesh On May 20, 10:21 am, girish naik wrote: > Hi Mate your work is done. > > Please check if this meets your requirement.. > > Click on the button which is on Document map sheet to Gen

$$Excel-Macros$$ Help Reqired Multiple conditions Lookup

Dear Group, Any send me with example Multiple conditions Lookup -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

Re: $$Excel-Macros$$ rank column

=IF(AND(G2=G3,H2=H3,K2>0),0,1) for First Row =IF(AND(G3=G4,H3=H4,K3>0),K3+1,1) For first row onward ocity  ostate  carrier price Rank a  b X 12001 a  b Y 290 2 a  b Y 11003 a  b Y 15004 c  d

Re: $$Excel-Macros$$ rank column

Kindly try this formula... =IF(AND(G3=G4,H4=H3,J3>J4,L2>0),1,0)+1 On May 20, 4:14 am, subs wrote: > ocity  ostate  carrier  price > a          b         X        1200 > a          b         Y       1290 > c          d         X        1300 > c          d         Z         1500 > e          f  

Re: $$Excel-Macros$$ rank column

Dear Friend, Please Find Attached File with solution as u need. Thanks, Chandrabhan Singh On Thu, May 20, 2010 at 4:44 AM, subs wrote: > ocity ostate carrier price > a b X1200 > a b Y 1290 > c d X1300 > c d

Re: $$Excel-Macros$$ Macro :- Selecting a variable range in a excel sheet

Hi Ashish, This below code might help you. lstrow = Range("A65000").End(xlUp).Row Range("A1:" & "B" & lstrow).Select On Wed, May 19, 2010 at 10:40 AM, SANJAY SONI wrote: > Dear All, > > Please help me to provide a macro code for selecting a variable range. > > Suppose for example the data ent

Re: $$Excel-Macros$$ rank column

Hi Subs, I am not able to find dcity in the data, as you have mentioned in your explanation. -- 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 Wed, May 19, 2010 at 5:01 PM, subs wrote: >