Dear All,
Debit note format in excel is required. If any one has kindly forward.
Thanks & Regards,
C.G.Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://
Hi Pankaj,
If the total hours are less than the required hours that means the employee
is not working 8 hours which is required as per the company policy. Hence
it is reflecting the error. If the employee meets the desired criteria of 8
hours, then it is fine.
Regards,
Solomon.
On Tue, Aug 31,
Rajesh,
check the files "copy of create cells.xls"
regards,
Kishan Reddy, K
On Aug 30, 7:03 pm, Rajesh D wrote:
> Hi
>
> can some one help me on the attached worksheet query
> --
> Thanks
> Rajesh
>
> create cells.xls
> 18KViewDownload
--
-
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*
* rajputpankaj1...@rediffmail.com*
--
--
Some important links for excel users:
1. Follow us o
Hi, All,
i have a problem in excelsheet attached below
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*
* rajputpankaj1...@rediffmail.com*
--
-
Hi,
After you collapse the tree down to '2' you have to press (Alt+; ) so you
will select the visible cells only then copy these cells to new location and
remove the world total by find and replace that's all.
Regards,
Imad.
---Original Message---
From: Amazon
Date: 8/29/201
Hi Group,
I need your expertise in one of my advance Excel Dashboard. in
sample Excel sheet there are Two Excel Chart, I required when my mouse
courser got focus on chart 1 so it's show in zoom. and when my mouse courser
lost focus from chart 1 so its show in normal form. same happen
Hi Group,
I need your expertise in one of my advance Excel Dashboard. in
sample Excel sheet there are Two Excel Chart, I required when my mouse
courser got focus on chart 1 so it's show in zoom. and when my mouse
courser lost focus from chart 1 so its show in normal form. same happen
I like XL because it's like a logic puzzel, except that the puzzle is solved,
you actually end up with something useful.
Reards - Dave
> Date: Mon, 30 Aug 2010 04:35:33 -0700
> Subject: $$Excel-Macros$$ Re: I love excel because...
> From: dertop...@web.de
> To: excel-macros@googlegroups.co
Thanks!
Regards - Dave.
Date: Mon, 30 Aug 2010 11:52:47 +0700
Subject: Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into
another two cells
From: villager.g...@gmail.com
To: excel-macros@googlegroups.com
Without VBA, we can create a NAME of formula
(menu Insert >> Name >>
You can set the Font Size of your Combobox (activeX control) object
For example:
ComboBox1.Font.Size = 12
On Tue, Aug 31, 2010 at 8:27 AM, Meimei wrote:
> I am writing a simple vba program. I used a few comboboxes in the
> program. But I found that as I click on the combobox, the font size in
just use space between 9:00 & AM
Regards,
Kishan Reddy, K
On Aug 30, 8:03 pm, Pankaj Kumar wrote:
> Dear all,
>
> When i use the forumulla it shows value pls find attached sheep
> --
> *Warm Regards
> Pankaj kumar
> M:9899816107begin_of_the_skype_highlighting 9899816107 end_o
Unfortunately a FUNCTION can not DO a method
Function can only returns a Value
CMIIW
To format a range you need a SUB Procedure not Function Procedure
best regards,
siti
On Tue, Aug 31, 2010 at 2:32 AM, Silviu wrote:
> Hello
> I'm trying to find out how to build some user defined functions for
Hi,
You can work in a GROUP of SHEETS
f.x.
Multi-Select: Sheet1 and Sheet2
then you need to work in Sheet1 only
On Mon, Aug 30, 2010 at 3:31 PM, Steen wrote:
>
> HI
> I would like to mirror a worksheet to another worksheet only certern
> cells and if you in the main sheet inserts a new rows this
I love excel becuz it helps me excel in my day-to-day data
manipulation and analytics solution.
Mog
Sent from my HTC Snap on the Now Network from Sprint®.
-Original Message-
From: Ayush
Sent: Sunday, August 29, 2010 10:05 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ I lo
Hi Maries,
This formula might look complicated, but it's actually simple if we "break"
it into pieces.
But before doing it, we first need to understand the idea: we want to, based
on the value of cell B7, return the corresponding range of possible values
that are on another sheet.
So, for example:
Hello
I'm trying to find out how to build some user defined functions for
text formatting. Something like:
customstyle("bold","arial","18",cell)
I want to use these type of functions in order to apply them in a
concatenate function. Something like:
concatenate("this would the best",customtype("
I am writing a simple vba program. I used a few comboboxes in the
program. But I found that as I click on the combobox, the font size in
the drop-down list gets smaller each time, and after a few clicks, the
font is too small to even see. Does anyone know why it happens?
Thank you!
--
--
hello,
Pankaj attached is the solution for your query, the formula u depicted or
used in that cell
is accurate where as all you need to do is to give a space as shown below
9:00 AM Give space like this for both intime and out time then as per
attached sheet u will have error free result.
Inca
Hi! Bruno,
Can you explain me the logic which you used second data validation
=INDIRECT("'PRD Range'!" & LEFT(ADDRESS(1,MATCH('Dropdown
List'!$B$7,Brand,0),2),1+(MATCH('Dropdown
List'!$B$7,Brand,0)>26))&"2:"&LEFT(ADDRESS(1,MATCH('Dropdown
List'!$B$7,Brand,0),2),1+(MATCH('Dropdown
List'!$B$7,Brand
Hi Vibhav
Insert one colum "H" & put formula
HOUR(G5)*60+MINUTE(G5)
Regards
Sudhir
On Mon, Aug 30, 2010 at 11:39 AM, vaibhav joshi wrote:
> Hi Sudhir
>
> Thank got your mail,but i want Total OT in Mnts,that is not getting
>
> Regards
>
> Vaibhav
>
> 2010/8/30 सुधीर इंगळे
>
> Vaibhav
>> check
Hi Ashish,
firstly i would like to thank for your prompt reply and assistance.
it is very delightful to have such adorable group with such a good guides
and query resolvers
Thanks for all your help once again.
Friends we should thank one and all who created this Groups which is really
a good l
Dear all,
When i use the forumulla it shows value pls find attached sheep
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*
* rajputpankaj1...@rediffmail.com*
--
---
Hi
can some one help me on the attached worksheet query
--
Thanks
Rajesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi
can some one help me on the attached worksheet query
--
Thanks
Rajesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
On 28 Aug., Ayush wrote:
> Its a very handy tool for any data analysis and reporting. - Ayush
> Jain
> ---
>
> Guyzzz, Let me know why you like excel so muchThe best response
> will be publi
On Mon, Aug 30, 2010 at 2:03 PM, adel elshafe wrote:
> its a usful link
>
> http://helpdeskgeek.com/office-tips/create-multiple-linked-dropdown-lists-in-excel/
>
>
>
> On Mon, Aug 30, 2010 at 12:04 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> I need a help to create multiple linked dropdown lists
Hi Sudhir
Thank got your mail,but i want Total OT in Mnts,that is not getting
Regards
Vaibhav
2010/8/30 सुधीर इंगळे
> Vaibhav
> check the attach file,
> i think this will solve ur problem
>
>
> Sudhir
>
>
> On Mon, Aug 30, 2010 at 6:44 AM, vaibhav joshi wrote:
>
>> Hi all
>> please find enclo
its a usful link
http://helpdeskgeek.com/office-tips/create-multiple-linked-dropdown-lists-in-excel/
On Mon, Aug 30, 2010 at 12:04 PM, Kal xcel wrote:
> Dear Experts,
>
> I need a help to create multiple linked dropdown lists. Please go through
> the attached file, details is there.
>
> Thanks
Hi,
Am not familiar with access and it would be great if I get macro or vba
script to do the below task. Or please explain me in detail.
Thanks in Advance,
Sharma
On Mon, Aug 30, 2010 at 2:32 PM, adel elshafe wrote:
> *Dear Sharma
> I have small idea but its may be help you
> use in access refr
Hi,
Thanks for opening up an area of XL that I'd never even heard about. I did some
research, and have found the following page to be most informative on the
subject of GET.CELL
http://www.mrexcel.com/forum/showthread.php?t=20611
Regards - Dave.
Date: Mon, 30 Aug 2010 11:52:47 +0700
Vaibhav
check the attach file,
i think this will solve ur problem
Sudhir
On Mon, Aug 30, 2010 at 6:44 AM, vaibhav joshi wrote:
> Hi all
> please find enclosed sheet of overtime calculation.
> Please note that duty timing is 6.30 to 4.30
>
> If someone help me ,i will be grateful
>
> Regards
>
*Dear Sharma
I have small idea but its may be help you
use in access refrence Microsoft scripting runtime
it makes you copy files , create folders
any things related files if you fail send i have already form access*
On Mon, Aug 30, 2010 at 10:06 AM, amrahs k wrote:
> Dear Experts,
>
> I have a
HI
I would like to mirror a worksheet to another worksheet only certern
cells and if you in the main sheet inserts a new rows this will
atomaticly also bee inserted in the other cell
f.x
by using an insert button that insert a row above the selected cell,
both in the main sheet and also in the m
Dear Expert,
I want to learn Array Function in Excel . Please help me.
--
Thanks & regards,
Noorain Ansari
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twi
Dear Experts,
I have a problem to work on a folder where in I need to do manually to do
the below task.
I have a folder named as "Calibration" in "C:" drive. It contains 500 excel
files. What I want to do is to create new folder1 and move 50 files to it.
Then another 50 files to new folder2 till
36 matches
Mail list logo
