Thanks a lot Harmeet...
Can u also get me one more functionality here that as soon as one agent
acquires the job time and date he acquired also appears and untill he
finishes the job by selecting as close which will be a drop down in next
column to acquired time column. Once agent uses close from
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:)
--~--~-~--~~~---~--~~
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
- based on
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:
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
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 harmeet.hew...@gmail.comwrote:
Hi Harish,
First of all, Thanks a lot for appreciation.
If now I do the changes that you
Hi
how to extract data from a system (Quick Books for non profits ) and
automatically update a formatted report (Donor Expense Report)
rashid
--~--~-~--~~~---~--~~
-
Some
This is perfect.
Thank you so much.
On Apr 12, 6:07 pm, Tom Jeffries tjeff...@gmail.com 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
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,
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 lavprasa...@gmail.comwrote:
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
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 lavprasa...@gmail.comwrote:
Dear Friends,
I am downloading the employee data from our portal. In, there is
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 harmeet.hew...@gmail.comwrote:
attached file has the solution
assuming that ID will be of 5 digits only
On Mon, Apr 13, 2009 at 5:24 PM,
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,
Hi Lavprasad
Found a simple solution. Hope it helps.
Regards
Radhe
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori lavprasa...@gmail.comwrote:
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
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 harmeet.hew...@gmail.comwrote:
attached file has the solution
Thanks, Dave, that's what I was looking for!
On 3 Apr., 06:54, Dave Bonallack davebonall...@hotmail.com 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:
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
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
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.com
19 matches
Mail list logo