ok
On Tue, Oct 26, 2010 at 12:19 PM, amrahs k wrote:
> Dear Experts,
>
> I need quick suggestion to solve the below issue.
>
> Issue: Team use to update a spreadsheet for tracking their hours details
> for extending the shift. After a day the values in the spreadsheet gets
> changed this is beca
The url's can't be opened
On Tue, Oct 26, 2010 at 1:35 PM, anandydr wrote:
> Hi,
>
> Please see Tushar Mehta's website.
>
>
> http://www.tushar-mehta.com/excel/charts/0301-dashboard-conditionalshapecolors.htm
>
> Check this site for creating the kind of map you want. I hope this
> would help.
>
How about when we move the the cursor into row 10 the color of range B10:M10
is yellow
thanks
On Tue, Oct 26, 2010 at 11:27 AM, ashish koul wrote:
> HI
>
> use it ony if you are not using any background colors in file
>
>
> code:
> Private Sub Worksheet_SelectionChange(
> ByVal Target As Range)
try this:
=TEXT(C3; "dd/mm/ hh:mm:ss")
On Wed, Oct 27, 2010 at 4:26 PM, Anju wrote:
> Hi ,
>
> Please help to format the dates in attached excel file to dd/mm/
> hh:mm:ss. when i treid formating the dates somedates format was dd/mm/yy
> hh:mm:ss...but i need as dd/mm/ hh:mm:ss for a
can you give the attachment please
On Wed, Oct 27, 2010 at 7:57 PM, learner wrote:
> Hi! Ashish,
>
> This does not work. I pasted the code after clicking the form in the
> empty sub with required changes of the names. But entering and exiting
> the TextBoxes + ComboBoxes do not execute the sub.
use SUMIF Formula
On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna wrote:
> Hi Everyone.
>
> Can someone explain I have data in sheet 1 The columns Name and Production
> . Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name
> and fetch the production . But I have a problem.
Please Help Me
How to create automatic code in the attachment
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gro
hot to create time update per second in vba
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.lin
i don't really understand what you ask for
On Fri, Nov 19, 2010 at 11:45 PM, None wrote:
> I need a MaxIf type of formula that will work with Excel 97 and Excel
> 2003. Thanks.
>
> I have two worksheets that have similar data in them for Col A-C. Sheet 1
> has numbers in col D. What I need in
