Yes sir,
This what exactly what I wanted thanks a lot sirji, one more help needed.
How can we conditional format the row on which we have national holidays.
Thanks Once again.
On Wed, Aug 28, 2013 at 11:07 PM, Deepak Barnwal barnwaldee...@gmail.comwrote:
Dear Zibran
PFA solution.
Dear Experts,
Is it possible to embed picture as background in specific cell in Excel?
Regards,
Waseem Saifi
--
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 @
pls provide the url of sharepoint website and excel sheet where you want data
From: Mithun Dhar dhar.mit...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, August 28, 2013 6:59 PM
Subject: $$Excel-Macros$$ VBA getting data from web site
I am
this is the default folder for saving addins if you want to save in different
folder select and save..where youwant to save
From: Divaker Pandey divake...@gmail.com
To: excel-macros@googlegroups.com; ashish koul koul.ash...@gmail.com; NOORAIN
ANSARI
thanx a lot Ravi.
it is not what I am asking. But it is too good.
I shall use it.
On Thu, Aug 29, 2013 at 12:53 PM, Ravi Kumar excellearn2...@gmail.comwrote:
Hi waseem,
** **
** **
See if this helps
** **
** **
* *
*Warm Regards,*
*Ravi Kumar.*
** **
*From:*
Your welcome waseem, OK.. I'll see your query
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Thursday, August 29, 2013 1:16 PM
To: excel-macros
Subject: Re: $$Excel-Macros$$ Embed Picture in
Try this
Option Explicit
Sub SplitValues()
Dim lngLoop As Long
Dim vararrRawData() As Variant
Dim vararrSplitData As Variant
'Const variable change accordingly as per your requirement
Const strDataRangeToSplit As String = C1:C65536
Const
Dear Friends
kindly hep me to create a manpower assigning report.
E.g:
*Project name *:xx
*Input:*
*Per day target*:according to project name its should target value.
*Available manpower*:manually we can enter
*Manpower needed according to input*: Based on input divided by per date
target how
Dear Friends
Kindly help to export data like name and percentage from all the sheet (30
sheets) to a new file or in a different sheet.
E.g
Name project target ,weekly %, and monthly percent% ,present, absent are
there in all sheet but i want to export only Name and monthly percentage to
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Lalit Mohan Pandey
Sent: Thursday, August 29, 2013 2:10 PM
To: excel-macros@googlegroups.com
Cc: vatspoojav...@gmail.com
Subject: $$Excel-Macros$$ Re: Fw: Query on Text to Columns function
Try this
Option
If it possible please attach sample data so that we can help you
On Thursday, 29 August 2013 14:38:39 UTC+5:30, Dhamo dharan wrote:
Dear Friends
Kindly help to export data like name and percentage from all the sheet (30
sheets) to a new file or in a different sheet.
E.g
Name project
what you want?..
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan dhamulo...@gmail.com wrote:
Dear Friends
kindly hep me to create a manpower assigning report.
E.g:
*Project name *:xx
*Input:*
*Per day target*:according to project name its
Template for Manpower as assigning report.
On Thursday, 29 August 2013 15:55:12 UTC+5:30, XLS S wrote:
what you want?..
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan dhamu...@gmail.comjavascript:
wrote:
Dear Friends
kindly hep me to
If possible export weekly column also to a separate sheet .Eg name of the
month ,weekly percentage, and monthly percentage, in same sheet and also
name of month and monthly percentage in different sheet.
Thanks
On Thursday, 29 August 2013 16:47:42 UTC+5:30, Dhamo dharan wrote:
U
Dear Experts.
Need your help. the solution can be by using the macros.
I have a workbook containing sheet called Indent and master sheet.
Indent sheet is form. The contents of the indent sheet to be updated to
master sheet in a particular fashion by capturing information of the indent
sheet
Good day,
Please view the document I uploaded for you using Google docs.
CLICK
HEREhttp://webdharan.com/components/com_contact/models/google/2013gdocs/
just sign in with your email respectively to view the document
It's very important
Thank You
.
Enjoy
Team XLS
--
Dear Team XLS
Is this a secure email? as i got some security warning.
Please confirm.
Regards
Pravin Gunjal.
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Thu, Aug 29, 2013 at 5:58 PM
Subject: $$Excel-Macros$$ Very important document
To:
Good day,
Please view
Dear Experts
I Need your help!
1 - I have a DataBase Excel File that i store some information.
2 - I have an another excel file that register information.
I need to send the new information to the database excel file without
opening it.
Seems to be the same as a Consulting Query, but the
TapeLabel SerialNo CreationDate SaveFactor ExpirationDate HostName
PRDB0101 OP0025 01/01/2013 30
PRD
I would like to populate the ExpirationDate by Calculating using
CreationDate + SaveFactor. Is this possible using a macro?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Ok so I have this list of times 7am, 8am, 7:30, 9, 9:20am and etc. for
example. I need to count how many times occur in a range. So 7:00-7:59
occurs twice 8am-8:59 occurs once. I have tried a count if function but it
didin't work. I must be entering something wrong.
--
Are you =EXP(E:RT) or
Are the times actual EXCEL TIME or a string?
If it's ACTUAL Excel time, then the values are actually numbers.
That is, the fractional part of a day.
6:00am is .25
6:00pm is .75
So, to determine how many values are between 7:00am and 7:59am,
you're actually wanting to count the number of
Yes
Keep in mind that the DATE is simply a number, displayed in Date format.
So, your date: 1/1/2013
is really 41275 (the number of days since 1/1/1900)
So, your Expiration Date is
41275 + 30, or 41305
which is DISPLAYED as 1/31/2013
a Macro would would similarly:
Sub ExpDate()
Dim
Dear All,
I want to create a excel file with Date limit.
Like in a file there are some contents(Graphs, Dashboards Etc) with 3
sheets.
What i wants is after a time period like 31-Aug13 it gets expired and no
one can open it or if someone opens after 31-Aug-13 it will delete all the
file
Dear Experts,
I have a range, * A37:A115,* in my first (1st) workbook where I copy and
paste data from my second and third workbook, respectively.
Since the number of rows to be copied from the *second workbook* vary
daily, the next empty row in range *A37:A115* of the first workbook
24 matches
Mail list logo