hi,
pls find the attached file,
2nd sheet is master data... 1st sheet is searching data...
if i enter employee id in 1st sheet 2nd sheet data want to come
automatically...
pls do the needful urgent base
regards
Kannan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
You're welcome,
We're happy to hear that your problem solved.
But we have one problem here, 1/0/1900 is not a date, we will never meet
that case in real world
If i ask to you, What month before January ? That should be December,
and that month is 12 not Zero ;-)
Rgds,
[dp]
Pada 12/07/2013 5
HI DP
many thanks for the solution..for my query and its working and serving
my purpose 100%
thanks
Patil M G
On Wed, Jul 10, 2013 at 7:22 PM, De Premor wrote:
> Hi Patil,
>
> PFA
>
> Please Run Procedure named *GenerateFromTemplate
> *
> Rgds,
> [dp]*
>
> *
> Pada 10/07/2013 18:30, Pati
WOW!! Look at all these wonderful people coming to my aid. Thank you all
so much for your help. DP this formula worked well except that it put a
1/0/1900
date in all my blank cells. I used part of Ashish's formulas to keep that
from happening and now your code works perfectly.
Private S
Hi Ali, Its me Again :-D
There is only 1 mistake in your new formulas
For Example (See the cell i've Bold)
=IF($B2>$I2,"Error
Input",IF(TEXT(U$1,"ymm")=TEXT($B2,"ymm"),IF(TEXT(U$1,"ymm")=TEXT($I2,"ymm"),$I2-1,U$1)-$B2+1,IF(TEXT(U$1,"ymm")=TEXT($I2,"ymm"),DAY($I2)-1,IF(AND(TEXT(U$1,"ymm")>TEXT(*
Try this, this will search a whole used range in sheet, that will be
very slow if you have a big data
*Private Sub CommandButton1_Click()**
**Dim Rng As Range**
**For Each Rng In ActiveSheet.UsedRange**
**If IsDate(Rng.Value) Then Rng.Value = Format(Rng.Value, "dd
mmm ")**
How do i pull values from a validation list ?
i am trying to do a simple nutritional planer. i have a list contaning
nutiotional contains of different foods pr. 100g
so lets say that i use data validation to create a dropdown and i click
"apple" i want to pull the remaining information which is
Thanks Ashish but the dates don't always fall in column D and are not
always just two columns.
How can I change this portion to search the entire sheet? I tried several
options to no avail.
For Each cl In Range("d2:d" & Range("d1048576").End(xlUp).Row)
On Thursday, July 11, 2013 11:47
Hi all,
I recently posted a topic to solve an issue regarding the span of total
number of nights spent in specific columns. The forum members were really
helpful, particularly De Premor!
Link is here:
https://groups.google.com/forum/#!searchin/excel-macros/Formula$20to$20span$20number$20of$2
visit the link
http://www.professionalexcel.com/2011/06/replace-iferror-with-ifiserror/
On Thu, Jul 11, 2013 at 4:31 PM, Prafull Jadhav wrote:
>
> both are same.
>
> in 2003 there was iferror and in 2007 it replaced by iserror.
>
>
> On Thu, Jul 11, 2013 at 4:09 PM, Raj Kumar wrote:
>
>> Hi Gr
check these templates
http://office.microsoft.com/en-in/excel-help/use-the-excel-timecard-template-for-quick-and-easy-time-tracking-HA001113313.aspx
http://www.citehr.com/344268-effective-attendance-tracker-2011-login-log-out.html
http://office.microsoft.com/en-in/templates/employee-time-sheet-TC10
use this formula in c2 =DATE(YEAR(B2),MONTH(B2),1)
and fill it down then try to sort the columns of pivot table
On Thu, Jul 11, 2013 at 6:36 PM, Waseem Saifi wrote:
> Dear Rakesh,
>
> please see attachment.
> in case of place months in ascending order. you have to do it manually.
> right cli
try this
Sub sample()
Dim cl As Range
For Each cl In Range("d2:d" & Range("d1048576").End(xlUp).Row)
cl.NumberFormat = "@"
cl.Value = Application.WorksheetFunction.Text(cl.Value, "dd mmm
")
Next
End Sub
see if it helps
On Thu, Jul 11, 2013 at 9:43 PM, srsev6 wrote
Thanks for your help Enrique. I have attached the file. In column "D"
"Forecast_Date" is the column I want to apply the code to. I have added a
command button I would like to click on to have the code run. If you
double click in a cell under column "D" you will see there is a date
stamp. N
Please share your file mentioning all your requirements..I'll try..
On 7/8/13, srsev6 wrote:
> Thank you Enrique. How do I set this up in a code to be able to use in a
> command button?
>
> I am familiar with codes in visual basic but not an expert by any means in
> writing them.
>
>
>
>
> On We
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it manually.
right click on any month and move it to left, right, to beginning or to end.
Regards,
Waseem Saifi
On 7/11/13, Rakesh Kumar Sharma wrote:
> Dear Experts,
>
> I have a query related to Pi
Dear Experts,
I have a query related to Pivot Table. Pls refer to attachment.
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.
Dear Seniors,
Does any one have any type of CAB or Transport Roster Data. if yes, then
please share. I need it on urgent basis. Please Help..!!
Thanks,
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of thi
hi friends,
anybody have excel time tracking format?? i want to track my employee
details in excel.. if i enter my employee id number means his it will come
automatically pls send asap...
regards
Kannan V
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2
both are same.
in 2003 there was iferror and in 2007 it replaced by iserror.
On Thu, Jul 11, 2013 at 4:09 PM, Raj Kumar wrote:
> Hi Group,
>
> Kindly let us know the difference between Iserror & iferror in excel
>
> Regards
> Raj Bharti
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hi Group,
Kindly let us know the difference between Iserror & iferror in excel
Regards
Raj Bharti
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
This problem occurs when the workbook contains more than approximately
4,000 different combinations of cell formats in Excel 2003 or 64,000 in
Excel 2007 and higher. A combination is defined as a unique set of
formatting elements that are applied to a cell. A combination includes all
font formattin
Dear All,
I am trying to change the format of a cell in an excel sheet. It gives me a
pop-up box as 'Too many cell formats', which is not allowing me to change the
format.
Could you please help me solving that issue ?
Many thanks,
Kaushal
Rgds, Kaushal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Dear Friends,
It is possible to lookup the values for the left side and second value,
third value
Is their any other ways or functions to get the results.?
1. Shall we can get the left side result by using vlookup function?
2. Shall we can get the second value result by using vlookup function
*Dear Premor,*
* *
*Please accept my sincere thanks for doing so much of work for me..*
*
*
*Regards*
*Pravin Gunjal.*
-- Forwarded message --
From: Pravin Gunjal
Date: Thu, Jul 11, 2013 at 11:29 AM
Subject: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@g
25 matches
Mail list logo
