Re: $$Excel-Macros$$ Re: compare partial text in a cell and compare the information for a new cell

2010-01-25 Thread Sridhar jack
Hi, Please find the attached Sridhar 9884984988 On 1/25/10, steve d mck1...@gmail.com wrote: I didn't realize that the formatting would change, while i am at it, i would like to search for 1a or 1b or 1c and have it put the corresponding location in the appropriate cell. please see

Re: $$Excel-Macros$$ Formating of Cell

2010-01-25 Thread Jitendra mhashelkar
right click on a cell sellect Format cell select number tab then click on number category see the result On Mon, Jan 25, 2010 at 12:45 PM, Sachin Shukla sachina...@gmail.comwrote: Dear All, Please help me on formating of cell: for example supoose I put the data in cell A1 say 5000 Its

Re: $$Excel-Macros$$ Re: compare partial text in a cell and compare the information for a new cell

2010-01-25 Thread ankur
nice one!! shridhar Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Jan 25, 2010 at 1:26 PM, Sridhar jack sridhar0...@gmail.com wrote: Hi, Please find the attached Sridhar 9884984988 On 1/25/10, steve d

Re: $$Excel-Macros$$ Formating of Cell

2010-01-25 Thread Sridhar jack
Kindly go to tools menu change in to general format On 1/25/10, Sachin Shukla sachina...@gmail.com wrote: Dear All, Please help me on formating of cell: for example supoose I put the data in cell A1 say 5000 Its automatically converted into date formate insted of number formate.

$$Excel-Macros$$ charting more than 32000 rows

2010-01-25 Thread kvc praveen kumar
Hello All, I came to know yesterday that Excel 2003 has limitation to chart more than 32000 rows/data points. However, this could be overcome with the creation of two separate dataseries. I want to know if it is possibleto create an add-in for implementing the same. If it is possible, Can

Re: $$Excel-Macros$$

2010-01-25 Thread Shilpa Rao
Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in this group.. On Mon, Jan 25, 2010 at 6:43 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Shilpa, If you really want to do this with VBA, use the code below. Sub VlookupVBA() A = 1 'Start Row Do Until

Re: $$Excel-Macros$$

2010-01-25 Thread Shilpa Rao
Hello, Please provide me any material to learn VBA codings. Advance thanks to all the experts for your help. . Regards, Shilpa On Mon, Jan 25, 2010 at 4:39 PM, Shilpa Rao shilpa...@gmail.com wrote: Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in this group.. On

$$Excel-Macros$$ Creating sheets out of pivot table

2010-01-25 Thread kundan
Hi, I want to create sheets with details of each pivot field. I've got following code for it which extracts details of field shown in that particular cell. For example, below code extracts details for field item shown in cell C6 and put it in a separate sheet. Range(C6).Select

$$Excel-Macros$$ Hi Help in Excel

2010-01-25 Thread harish chandru
Hi All, May I kindly request you to help me out on the below attached spreadsheet query.. I need it today as i need to submit this tomorrow morg in my class.. please help me.. Thanks, Harish -- Forwarded message -- From: Vinu vinu1sm...@gmail.com Date: Mon, Jan 25, 2010 at 9:48

Re: $$Excel-Macros$$ Single Cell Text Manipulation

2010-01-25 Thread nemadrias
Great formula - and thank you so much for taking the time to do so...My format requires that each operating system version is on a new row instead of a new column, which is what the attached sheet does. Any idea how to accomplish this? My thought was a macro...Thanks again! Steve On Jan 23, 4:30 

$$Excel-Macros$$ Condition macro - please solve

2010-01-25 Thread TAlgo
Hii.. I'm looking for a macro or condition statement which would do following for me: If cell A1 is BUY then run a macro automatically which will add current value in cell B1 to cell A3 so everything theres a BUY in cell A1..macro will keep addiing B1 values in cell A3 and If cell A1 is SELL

Re: $$Excel-Macros$$ Excel Data Automator

2010-01-25 Thread Ramesh-Hyderabad
Hi Paul, I've installed the add-in, but when I select Control Panel, I get an error message Cannot open key I'm using XL2007 Regards - Ramesh On Jan 24, 12:34 pm, Dave Bonallack davebonall...@hotmail.com wrote: Hi Paul, I've installed it on my own laptop at home.  I am the only user, and don't

$$Excel-Macros$$ how to keep cursor in current field after enter.

2010-01-25 Thread Wilbur Kush
I have a scale that inputs data into excel via rskey, a keyboard emulator that comes with the scale. No problems getting the data into excel from the scale, however, a carriage return (enter) is sent after the weight is entered into field A1. This sends the cursor to A2 after entering the

$$Excel-Macros$$ Vba for creating toc based on charts titles

2010-01-25 Thread wollyka
Hi I have a worksheet that contains hundred of chart sheets (each chart in a sheet). Each chart has a title. I want to create a toc based on each chart title using vba but I don't know how. I manage to create a toc using sheet names but I want to use the chart titles instead. Any help is

Re: $$Excel-Macros$$ How to assign rank from the list

2010-01-25 Thread ayush jain
Dear Atul, Use Rank formula for ranking of data. Attached is the solution for you. Let us know if further help is required. Best regards, Ayush Jain Group Owner On Tue, Jan 26, 2010 at 10:00 AM, Atul atul_pate...@yahoo.com wrote: Hi, Following is the list of financial Institution with

$$Excel-Macros$$ Excel Accounting

2010-01-25 Thread Robinson Boreh
Hi guys, I am doing some financials of a small company with less than 50 transaction per year. Well it's very small and I don't think I have to buy a fully functioning accounting software, it will not be worth it. I am therefore turning for your help in this regard. Is there someone who has

Re: $$Excel-Macros$$ Hi Help in Excel

2010-01-25 Thread ayush jain
Dude, This forum is to help genuine real life problems of excel and macros users. Your test appears to be quite simple and it was made to test your capability. You will not be able to learn if we will solve it. First try at your end and if you find any problems in specific question, just let us

Re: $$Excel-Macros$$ how to keep cursor in current field after enter.

2010-01-25 Thread ayush jain
Dear Wilbur, You can use a macro to make this happen. The macro should be written in selection_change event of worksheet, so whenever the cursor move to A2..it will go back to A1 address of worksheet. Attached is the solution in macro enabled workbook for your reference. Please let us know if