$$Excel-Macros$$ Re: Help with formatting and subtotal

2009-08-14 Thread vivek agrawal
Hi Attached is the solution to problem.. you just need to hide to column C. Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Aug 15, 2009 at 1:34 AM, Cesar Delanoval wrote: > > I have a simple table of b

$$Excel-Macros$$ Re: insert = in every cell as prefix with nos & Blank

2009-08-14 Thread Bakul Patel
HI Abdul, Is it possible to insert '=' as prefix with nos only.   If yes, give me code.   Thanks, Bakul  --- On Fri, 8/14/09, Abdul Shakeel wrote: From: Abdul Shakeel Subject: $$Excel-Macros$$ Re: insert = in every cell as prefix with nos & Blank To: excel-macros@googlegroups.com Date: Friday,

$$Excel-Macros$$ Help with formatting and subtotal

2009-08-14 Thread Cesar Delanoval
I have a simple table of banking transactions. Columns are as follows Column A = Date in MM/DD/YY format Column B = Empty Column C = Unit ID Column D = Empty Column E = Amount (numeric, 2 decimals) Column F = Empty Column G = Check No Column H = Subtotal On this sheet, the transactions are liste

$$Excel-Macros$$ Hiding rows that contain objects (active-X controls)

2009-08-14 Thread KMG
Hi, I am writing an application in Excel that will be used by lay people and need to simplify the appearance of my application as much as possible. I was wondering if it is possible to hide rows or columns that contain Active-X controls. When I try to hide any rows that touch my Active-X comman

$$Excel-Macros$$ Re: I need help !!! Thank for all

2009-08-14 Thread *****
Thank you thank you very much On Aug 14, 4:27 pm, Dilip Pandey wrote: > Hi Alsulaiman, > > You should include a Pivot Table to get the desired results. Same is done in > the attached workbook. Thanks. > > -- > DILIP KUMAR PANDEY >   MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@g

$$Excel-Macros$$ Re: replace when large data in cell

2009-08-14 Thread Aindril De
Hi, Please fiond attached the file in Office XP-2003 format Regards, Andy On Thu, Jun 25, 2009 at 9:46 AM, Sandeep wrote: > Thanks Aindril, > > There is still no files, I'm using Office XP. I had solve the problem by > using substitute() function. > > (I don't have your file) > Is you did it

$$Excel-Macros$$ RE: removing starting letters

2009-08-14 Thread Serghei Ovanesov
Hello, To remove starting letters from the cell the following nested function can be used: =RIGHT("00"&RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1),6) Where A1 = "ABC Company 435" Assuming only 6 digit number is expected. Regards.

$$Excel-Macros$$ Re: replace when large data in cell

2009-08-14 Thread fongie
Hi Sandeep Did you manage to resolve your problem? There was the suggestion to take the data into a notepad file. I tried that but could not get it to work myself. Did something similar to take the data into MS Word instead then back to Excel which placed each line of the cell into individual

$$Excel-Macros$$ Create new worksheet and rename

2009-08-14 Thread roydburn
Hi. First of all I apologise if this has been covered already. I have spent hours looking at various solutions which are similar to what I want, but not exactly right, and I am an Excel novice so I am not able to modify other code. I have a workbook with two worksheets. For argument's sake they

$$Excel-Macros$$ I need help !!! Thank for all

2009-08-14 Thread A alsulaiman
I need help in the attach Conversion of data in the Sheet1 Like in Sheet 2 What is the Function that can be used Thank for all --~--~-~--~~~---~--~~ -- Some important links for e

$$Excel-Macros$$ Re: Remove starting letters

2009-08-14 Thread Ravi Megharaj
Hi, On the similar logic, can you please get me the formula for: ABC Company 345 The final result must be 000345 The company name is not required, but the number along with the name must be the output with 6 characters. Thank you, Ravi Megharaj On Tue, Aug 11, 2009 at 7:56 PM, Chechu wrote:

$$Excel-Macros$$ Re: insert = in every cell as prefix with nos & Blank

2009-08-14 Thread Abdul Shakeel
This code just a refined shape of Dave code for multi cell selection, just put the code in any vba module select your desired range where you want to put "=" sign and press Alt+F8 & run insert equal macro. Sub InsertEquals() Dim cel As Range With Selection For Each cel In Selection