Hi All
here my doubt is
The Validation is not having constraint,
i.e. afte entering one product and specification, if i am again changing the
product.the specifition remain same?
Eg.
Product 2 Specification 6
how can we resolve this ?
Regards.
Prashant.
On Wed, Apr 8, 2009 at 11:33 PM, Harm
Dear Members,
A new tip of excel has been published on the blog . The title of
the tip is "The Camera Tool in Excel".
Please visit the below link for this tip.
http://exceldailytip.blogspot.com/2009/04/tip-49-camera-tool-in-excel.html
To see the archive of these Excel Tips, Go to:
http://exceld
Hi Harpreet,
I have recently joined this group & its my pleasure to learn such wonderful
things from you guys.
I really thank you all.I am starting to learn Macro's kindly suggest me the
right path & tutorails which can really guide me additional to your personal
help.
Regards,
Harish Pand
HI !!
Well click on F5 - special - go to special - Formula - Click ok - And than
chose your colour.
Hope this may suffice
On Mon, Apr 13, 2009 at 11:45 PM, Ned wrote:
>
> could anyone tell me how to color code an excel cell if a cell has a
> formula. I have a long worksheet with lot of
Hi All,
Can anyone help me in creating a macro. example for filter for
employees like Kishore and wht ever value appears in column B copy and paste
it in a fresh excel like in sheet 1 and in sheet 2 of the same workbook paste
another employee's data in sheet 2 etc like this.
Reg
Hi All,
This may help. Chang the code as you want.
Sub ChangeformulaColor()
If Application.IsText(ActiveCell) = True Then
MsgBox ("Text")
Else
If ActiveCell = "" Then
MsgBox ("Blank")
Else
End If
If ActiveCell.HasFormula = True Then
ActiveCell.Select
With Selection.Font
Dave, You can also select cont+G, click on special tab and again click on
formula's tab, all cells whic contain formula's will get highlighted, you
can now select the fill color option and colour the cells with your
favourite colour.
Regards,
Shay
On Tue, Apr 14, 2009 at 10:24 AM, Dave Bonallack
Hi,
A quick way to reveal which cells have formulas:
Ctrl+`
That's Ctrl plus the key above the Tab key.
Regards - Dave.
> Date: Mon, 13 Apr 2009 11:15:32 -0700
> Subject: $$Excel-Macros$$ color code excel cell if a cell has a formula
> From: ned...@yahoo.com
> To: excel-macros@googlegroups.c
Hi Harmeet,
I used the other macro to fix my date and time issue since I was trying to
link this date and time with availble field in raw data but this was
refreshing so time was also refreshed but anyway I have fixed that but
eventually I have found that the data acquired is always misses the fir
could anyone tell me how to color code an excel cell if a cell has a
formula. I have a long worksheet with lot of data and it it hard to
tell which data is a formula and which is just value entered by users.
Thanks
--~--~-~--~~~---~--~~
Hi I have a client data base system which works through internet.
There are some fields in this data base where I have to update same
information in same fields for different deals. I have heard of Macros that
record Key Stroked. Can some one give me a link to a freeware which will
help me.
Regar
I have a status report spreadsheet saved onto my desktop that links to
15 other excel spreedsheets on a Sharepoint location.
I tried to record the macro and that would open those 15 excel
spreadsheets from Sharepoint. However when I attempt to run the macro
I get a Run-time error '76' "Path not
Thanks, Dave, that's what I was looking for!
On 3 Apr., 06:54, Dave Bonallack wrote:
> Hi Hamster,
>
> If you go to the Workbook window of the VBA, where your Workbook Open macros
> live, set the left drop-down to Workbook, then in the right drop-down,
> select: BeforeSave.
>
> You will se a
As shown in the below article...
http://funwithexcel.blogspot.com/2009/04/sorting-of-dates-with-different-formats.html
use the 'data' tab to split the name and Id. Hope this helps.
On Mon, Apr 13, 2009 at 7:12 AM, Harmeet Singh wrote:
> attached file has the solution
> assuming that ID will be of
Hi Lavprasad
Found a simple solution. Hope it helps.
Regards
Radhe
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same column. I want to split Emp. Name & Emp
There you go.
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Lavprasad Kori
Sent: Monday, April 13, 2009 5:25 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help regarding split Emp. Name & Emp. ID
Dear Friends,
Lavprasad Kori- If you add trim function for the name it would remove any
additional unwanted space
On Mon, Apr 13, 2009 at 7:42 PM, Harmeet Singh wrote:
> attached file has the solution
> assuming that ID will be of 5 digits only
>
> On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
>
Dear Lavprasad,
Please see the attached file with the solution of your problem.
Hope that helps.
Thanks & Regards,
Jitendra Kumar
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp.
attached file has the solution
assuming that ID will be of 5 digits only
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same column. I want to split Emp. Name &
Dear Friends,
I am downloading the employee data from our portal. In, there is employee
name & Emp. ID both are in the same column. I want to split Emp. Name & Emp.
ID in to two different column. I am also attaching the reference file.
Please help me.
Thanks in advance.
--
Thanks & Regards,
Hi
how to extract data from a system (Quick Books for non profits ) and
automatically update a formatted report (Donor Expense Report)
rashid
--~--~-~--~~~---~--~~
-
Some important
This is perfect.
Thank you so much.
On Apr 12, 6:07 pm, Tom Jeffries wrote:
> If you want the y-axis (vertical) to change dynamically check the "Auto"
> box on the y-axis scale tab. The x-axis (horizontal) will change
> automatically based on stock values.
> The attached spreadsheet creates a s
One more thing,
You can also use shortcuts to enter time/date.
*Ctrl+;* to enter date
and *Ctrl+shift+;* to enter time.
On Mon, Apr 13, 2009 at 7:00 PM, Harmeet Singh wrote:
> Hi Harish,
> First of all, Thanks a lot for appreciation.
> If now I do the changes that you have mentioned in your ma
Hi Harish,
First of all, Thanks a lot for appreciation.
If now I do the changes that you have mentioned in your mail, will be a
spoon feeding.
I have not protected the code that I have sent you. It would be a good
learning for you if you try and do it by yourself. You just need to write
two lines s
Well... to answer your EXACT question,
there isn't a simple function to do that. (that I know of!)
However:
If you're wanting a FORMULA, then you can use:
=IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower","Mixed"))
If you're wanting a function:
I inserted this function into a Module:
> Dear All,
>
> Can you please help me write a macro to simplify finding the packing list.
> The required files are attached for your reference. The tedious job that we
> do is as under:
>
>
>- Fin`ding the container number PONU7259344 from the daily vehicle
>entry file an excel file
>-
Hi,
Is there any function to find whether the word entered in a cell is fully in
upper case or lower case or in mixed case?
Can any one please help me as soon as possible...
--
Thanks and Regard
ramkumar.m
HAVE A NICE DAY FRNDS:)
--~--~-~--~~~---~--~~
--
27 matches
Mail list logo
