Dear Premor,
I could able to learn something about VBA-Macros after joining this group
only.. and before that even I didn't think that it that excel could do such
a nice work for users. As I do not know in deep about VBA, I would request
you to please do me a favor in this regard.
Thank you,
*Dear Premor,*
* *
*Please accept my sincere thanks for doing so much of work for me..*
*
*
*Regards*
*Pravin Gunjal.*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, Jul 11, 2013 at 11:29 AM
Subject: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
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
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
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
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
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 rajlu...@gmail.com 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))
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
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
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 @
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 rakeshks@gmail.com wrote:
Dear Experts,
I have a
Please share your file mentioning all your requirements..I'll try..
On 7/8/13, srsev6 srs...@gmail.com 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.
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. No
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
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 waseemsa...@gmail.com wrote:
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it
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
visit the link
http://www.professionalexcel.com/2011/06/replace-iferror-with-ifiserror/
On Thu, Jul 11, 2013 at 4:31 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
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
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:
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:18
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
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 )**
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
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
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 d...@premor.net wrote:
Hi Patil,
PFA
Please Run Procedure named *GenerateFromTemplate
*
Rgds,
[dp]*
*
Pada 10/07/2013 18:30,
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
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
26 matches
Mail list logo