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
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,
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
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
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
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
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.
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
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
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
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:
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
12 matches
Mail list logo