i know smwhat about using macrosbest way to learn thm is to start
experimenting with anything..im on 9216796066.this is the thing
by which we can reduce our working time to a great extent...in all macro
is the ultimate tool to get in the world of prograqmming for non
programmers
-- Forwarded message --
From: Jake
Date: Fri, Mar 20, 2009 at 8:50 PM
Subject: Re: Subtract values that are in different rows
To: Ashish Jain <26may.1...@gmail.com>
Ashish,
Here's a sample:
A B
1/1/09 12:05 PM Null
NullNull
Null
Hi
Please can someone unsubscribe me from the froup. I have followed the link
and send an email multiple times to unsubscribe but nothing worked.
Thank you
Namita
On Fri, Mar 20, 2009 at 9:11 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Akshata,
>
> This group can help you in your quer
Hi Dale,
May we know the error statement you're getting, so that we can better
understand the problem. Since when I tried
Application.ActivePrinter = Application.ActivePrinter
It works absolutely fine on my system. This is idiotic on my part and
shouldn't be suggested but are you sure that any p
Hi Akshata,
This group can help you in your queries/problems but can't make a
project for you. This problem/small project has a solution but it
needs lots of time(say 4-8 hrs) and effort to make it. Moreover,
inputs aren't clear for e.g. the information you wanna fetch from
Sheet2. You please pro
Hi,
my pleasure Kanwal,
Try this
MyForm.Height = Application.WorksheetFunction.HLOOKUP
(FormSource,Dimensions,3,FALSE)
MyForm.Width = Application.WorksheetFunction.HLOOKUP
(FormSource,Dimensions,2,FALSE)
.
.
.
.
.
For more tips, tricks, downloads and problem solutions: visit -->
http://www.exc
Hi Ashish,
Thanks for being there
While I try to reexplain.
FormSource is a defined name of Cell A1, which contains a list a
values DataS1 DataS2, DataS3 and Datas4
Dimensions is a defined name of range containing values for height and
width of the Form.
I just want to know how to as
Hi Sandeep,
Depends on size of the company and complexity of operations the company in
to, you can manage your Fixed Assets details in Excel sheets which will
serve the purpose of
(a). Companies law - Statutory Audit
(b). Income Tax - Tax Audit
(c). Annual physical verification.
When you
On Mar 20, 8:08 am, Damascus wrote:
> Hi everyone.
>
> I am creating a macro that incorporates a userform. It is functional
> and in use, but there is a small thing that is still a problem. For
> some background, there are 2 sets of 2 textboxes for entering data,
> along with an 'enter' command
Dear All,
I am looking for asset management excel sheet for IT harwar
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
Hi Gohar,
See attched updated file.
On Tue, Mar 17, 2009 at 8:19 PM, Harmeet Singh wrote:
> See attached file.
>
>
> On Tue, Mar 17, 2009 at 12:34 PM, Gohar wrote:
>
>>
>> Dear All
>> How to find out repleated value in a column.
>>
>> Thanks
>> Gohar
>>
>> >>
>>
>
>
> --
> Thanks & Regards,
>
>
Save this addin anywhere on your hard disk, then open a new excel file or
the file in which you want to use this function.
Then use ctrl+O then locate this addin and click ok.
Then open all functions, then select Num2text fuction. Give the cell
referrence where your actua number is. This will con
I want the chart to display only a portion of the data table with the
chart like this:
(only groups show in data table)
Instead of this:
(groups and control lines show)
It doesn't seem like changing the columns to white text is flowing
through to the data table that goes with the
Hi everyone.
I am creating a macro that incorporates a userform. It is functional
and in use, but there is a small thing that is still a problem. For
some background, there are 2 sets of 2 textboxes for entering data,
along with an 'enter' command button and an 'end' command button. By
default, t
I have a chart that I would like to be able to display the upper control
limit, rolling average and lower control limits as shown in the
attachment but I don't want to have this information displayed on the
data table.
I don't want to put static numbers in the chart because we want to move
to
Please help on following in xl sheet
exp.
1000 = One Thousand
I am attaching herewith a add-Ins Num2text, but i don't know how to use.
Thanks & Regards,
Sudhir
--~--~-~--~~~---~--~~
---
Dear friends,
I am looking to purchase a software for Fixed Assets Management, for a
manufacturing company
can i have any suggestions from you guys who would have any experience in
using any such software pls
Regards,
Sandeep
--~--~-~--~~~---~--~~
--
Hi Doug,
As Ashish said, it would be very diffcult to understand these type of data
related to Time & Date and that too with a reading of a written para.. So
please send out that file as well ...
Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
i,
I am trying to write a code to do the following
Retrieve last modified .xls file each folder is in a directory.
example: "Project" folder has many project folders like P1,P2,P3etc
Each Project folder has Budget folder in it. ie P1 has
Budget folder
Budget folder
19 matches
Mail list logo
