Hey Sai,
You just have to use the formula, it's very easy ...you have to link the
files together...I don think we need any macro for this thing...
Suppose if you want the value of cell 'A1' of sheet 1 in the cell "B1" of
sheet2 then just got to "B1" of sheet 2 and type = and then go to sheet 1
an
This is my first post, and I hope it works! I need to hide non-used
rows that either have zero values or blanks. I have two total columns
for two years, and if they are both zero, then that row can be hidden.
I am using the following macro, but is is hiding too much.
Sub hiderow()
Dim rng As R
Hi Prabhakar,
This *.rar file is asking for password, could you please let us know the
same so that we can use the application.
Thanks a ton for sharing it..
Cheers!!
ANISH
On Wed, Oct 7, 2009 at 4:40 PM, prabhakar jain wrote:
>
>
> On Wed, Oct 7, 2009 at 10:11 AM, N.Shivkumar wrote:
>
>> Is
Great solution Sandeep.I'll make good use of that going forward.
I did a work-around using VBA before I noticed this reply... I made 3
clear columns at the front of the spreadsheet and pasted the data I
needed there. With everything sorted the same way, I then ran this bit
of code:
Sub Tmp_BumpD
Hi Friends.
i need help for a project. my question is
for example if i have 2 excel sheets if i change a value in first excel
sheet automatically it should replicate in the second excel file also, for
this do we need to use any macros or we can perform this by using any
advance formule.
it would
Hmm
It works but you always have to catch an error for some reason, yet it
still opens the program...
Thanks
Mirosta
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1
Thanx sandeep
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sandeep Kumar Maurya
Sent: Wednesday, October 07, 2009 10:25 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Excel macro-Help
Hi,
I update the macro as per your use and
Hello All,
I have some of Excel Files with VBA Passwords. If you press "Alt" +
"F11" then it goes to VB Window. Then if you click on the VBAProject
in that then it immediately gives a message as its password protected
but I didn't double click in that. Its just a message. So u cant even
double cl
I have an application consisting of a report menu and the
corresponding templates the menu points to.
The menu is a UserForm (UF1) and resides on a separate workbook
(Wkbk1). When the user opens Wkbk1 it automatically opens the
UserForm (UF1). The
user then selects a report template from one of
Hi,
I have a custom chart that I am manipulating. It is badly laid out so
setsourcedata is not possible (within my expertise).
I have code hiding blank columns in the source data, but there is one
column providing y values for the entire chart, so it can't be hidden.
This seems to be leaving emp
Use (for cell A1) :
=A1mailto:excel-mac...@googlegroups.com]
On Behalf Of Ahmed Emam
Sent: mercredi 7 octobre 2009 12:51
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need for Conditional Formatting
I need a formula for a conditional formatting to make a cell that contain a
da
Hi,
I need to run the solver for a column of 1800 target cells.
The first target cell in the columns is H32 to be equal to zero,
changing $B$2 and $C$2. Spreadsheet is called BetaNeutral.
Right after the solution is found for each single row I also need $B$2
and $C$2 to be copied in $G34 and $H34.
Hi,
I need to run the solver for a column of 1800 target cells.
The target cell is H32 to be zero changing B2 and C2. Spreadsheet is
called BetaNeutral.
Can you guys provide me with a macro script to do the job?
Thanks,
Giorgio
--~--~-~--~~~---~--~~
--
I need a formula for a conditional formatting to make a cell that contain a
date comes from another sheet, if that date is less than (today+30 days)
then it will change color .
--
A.A.A.
--~--~-~--~~~---~--~~
---
I need a formula for a conditional formatting to make a cell that contain a
date comes from another sheet, if that date is less than (today+30 days)
then it will change color but this date is hijri not Gregorian.
--
A.A.A.
--~--~-~--~~~---~--~~
---
ok, since I haven't heard from you yet,
I went ahead and created some "dummy" data.
10,000 phone numbers,
50 "features" (called "Feature_01", "Feature_02", ...)
and created just under 200,000 records (196,810 actually)
I "assumed" that the phone number and 'feature'
were separated by a "tab"charact
I think I know how I'd approach it.
I deal with something similar.
I use an array to store the values.
But by the time you add a couple thousand entries to the array,
it becomes very time consuming FINDING the array element that has the
correct entry to modify!
so, I use a Dictionary Object to sto
Look at the Shell function:
PathName = "C:\temp"
stat = Shell("C:\WINNT\explorer.exe " & PathName, vbNormalFocus)
hope this helps,
Paul
From: Mirosta
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, October 6, 2009 4:52:04 PM
Subject: $$Excel-Macros$$ Opening P
Guide you through WHAT, exactly?
I have no idea what your "billing system" is,
nor what your "ordering system" is,
or how using arrays would help.
I can tell you what an array is,
and how to populate it from Excel, ASCII (text) files,
MS-Access, Oracle, and possibly more.
But telling you how to do
The vlookup example is given is a good choice, you can also use arrays
or collections if you are going to use code.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Exc
We have a billing system that has all the information that needs to be
copied to an ordering system, and that would require use of arrays.
Can somebody guide be through this?
Will appreciate your help.
Thanks
--~--~-~--~~~---~--~~
-
Dear all,
I need your help in formula, i need correct formula to get daily total
salary and ot amount..
please help me.. i have send the attachment too..
Thank®ards,
Ram,
--~--~-~--~~~---~--~~
-
Hi,
I update the macro as per your use and assign a shortcut too. There are some
guidelines follow them to use desired result.
Regards
Sandeep
On Tue, Oct 6, 2009 at 11:35 PM, Umesh Matkar wrote:
>
>
> Dear Friends,
> I have one query regarding macro.
> i want to record a macro for goal seek.
Is it possible for you to send me the file I will crack the same and return
back to you
Bye
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
--~--~-~--~~~---~--~~
Best Product on the Market for this is Monarch Pro. Go to Datawatch.com for
details. I use it regularly
Ron
On Tue, Oct 6, 2009 at 5:04 PM, HumanJHawkins wrote:
>
> I have a list of 15000 rows of response data about questions that
> showed up on a series of tests. There is often more than one r
Hi,
There are many free online spreadsheet solution, you should give try to one
of them (Personally I never use them because I never need and online excel
file).
Follow this link and you will get many online spreadsheet solution and
choose as per your need.
http://mashable.com/2008/02/06/forget-e
Hi,
First you have to retrieve unique phone numbers I have given the steps in
attached file then use the formula as shown in the file.
Regards
Sandeep
On Wed, Oct 7, 2009 at 6:41 AM, bruce wrote:
>
> I am creating a program that does daily QA of our products. I work for
> a phone company and w
Hi,
Don't your Excel 2003 has Data->XML->Import. Check Again.
Regards
Sandeep
On Tue, Oct 6, 2009 at 5:57 PM, Manoj Kukrej wrote:
> Hi,
>
> I want to know how I can add xml in it
>
> I have checked in tools > commands>xml is also missing
>
> Regards
>
>
>
> Manoj
>
> -
Hi,
I used vlookup( ) for this. See the attached solution.
Regards
Sandeep
On Wed, Oct 7, 2009 at 2:34 AM, HumanJHawkins wrote:
>
> I have a list of 15000 rows of response data about questions that
> showed up on a series of tests. There is often more than one row for
> each test question, beca
Hello.
Have a look at the attached file.
Note that the formula in cells F3 and below are array formulae (validate
with Ctrl+Shift+Enter)
HTH
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of bruce
> Sent: mercredi 7
Hello.
Have a look at the attached file.
HTH
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of HumanJHawkins
> Sent: mardi 6 octobre 2009 23:05
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Best Way to Mi
31 matches
Mail list logo
