Dear Dave,
Thanks for paying attention,
Yes I am allowed to use Macro I want the date in Col B only when the
adjecent cell Col A received some text for the first time
Regards
Ramkesh
On Wed, Sep 29, 2010 at 7:50 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
A further question: Do you
Build a key in column g. The formula for the key should be:
=a2b2c2f2
Populate that down for all of the rows.
Basically what I built says -- look at the column of keys, if you
don't find a match then take the max of all transactions used thus far
and increment by one. If you do find a match,
Hi
Thanks Paul
On Wed, Sep 29, 2010 at 5:53 PM, Paul Schreiner schreiner_p...@att.netwrote:
this is a change event macro.
whenever a cell is changed, this macro is called and Range of the cell (or
cells)
is passed to the macro as the variable name Target.
In this case, the macro is
Hi,
Can anyone please assist me on this.
Thanks,
Sharma
On Wed, Sep 29, 2010 at 10:08 AM, amrahs k amrahs...@gmail.com wrote:
Hi Team,
I have attached the spreadsheet in which VBA project was protected with
password. Due to this I am unable to edit the code as well.
Kindly advice me to
Dilip is very helpful person with blazingly meritorious and zenithal
brilliancy in excel
Keep it up Dilip. My all wishes with you.
Kalyan
2010/9/29 SUMIT VYAS svyas0...@gmail.com
Dear All R/s Friends
Dilip Pandey is great personality . That is truth. He is genius and great
knowledge of
I have a workbook template which when team members use it and
then
when they go to save it defaults to “my documents” and I would like to
set
up a macro to save it to a particular drive / file location. This is
needed to stop team members saving to the wrong location etc.
Below is one that
*Hi ,
I am rakesh from Jammu and i want to know more about macro, and i also want
to know how to use macro and whats the functions of macro,
and my another question is can we add 2 values in vlookup .
please get the attached sheet for exp.
Rakesh Sharma
*
On Thu, Sept 30, 2010 at 1:00 PM,
Hi Experts,
Can you please explain formula of cell B17, B18, B19 and B20 of the attached
sheet.
Thanks
Hiren
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any
If you're allowing the users to define the name of the file they're saving
(instead of having the program do it)
then, in someplace like the Workbook_BeforeSave event,
use:
Chdir C:\temp
(or whatever you want the default folder to be)
Paul
- Original Message
From: Johnnyboy5
I would use a sheet change event:
'
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Targ As Range
For Each Targ In Target
If Targ.Column = 1 Then
Application.EnableEvents =
Please post a NEW topic instead of hijacking another discussion thread.
P
From: Rakesh Sharma rksharma...@gmail.com
To: excel-macros@googlegroups.com
Cc: intermediatec...@gmail.com
Sent: Thu, September 30, 2010 4:19:19 AM
Subject: Re: $$Excel-Macros$$ macro to save it to a particular drive /
Hi, All Experts,
Its Urgent
-- I need u r help i have two column in excelsheet Data1 Data 2 we have to
match both data if its Match show Match or not Match shows Mismatch in
next coloum,,,Pls provide me formulas
I have attached my excelsheet
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail:
PFA
sheet with formula
Vaibhav J
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Pankaj Kumar rajputpanka...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Sep 2010 18:28:53
To: excel-macrosexcel-macros@googlegroups.com
Reply-To:
Dear Pankaj,
Look attached resolved formula
Best Regards,
Venkat
On Thu, Sep 30, 2010 at 6:28 PM, Pankaj Kumar rajputpanka...@gmail.comwrote:
Hi, All Experts,
Its Urgent
-- I need u r help i have two column in excelsheet Data1 Data 2 we have
to match both data if its Match show Match or
Hi, exper it urgent i need u r help i attached my excel sheet
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*
* rajputpankaj1...@rediffmail.com*
--
Hi Sir,
I am sending attached excel sheet in which user form display the dynamic
range. When we select range in user form with the help of list box data goes
to another sheet. Sir My question is the highlighted.: Why we do listcount
-1 and other question is that highlight cell .Sir I need your
Hi everybody -
I am hoping someone can help me out with a problem I am having. I am
very new to writing and recording macros, I have been trying to look
at other macros that I use for different functions and tips.
I have a macro that I am trying to get to do a few different things.
The macro
I think I may have answered the first question off-line:
the listbox is an array.
array indexes start at 0
so, if your list is: line1, line2,line3 it looks like:
list(0) = line1
list(1) = line2
list(2) = line3
the total number of elements in the array (or listbox) is 3,
but the index is 0 to 2.
First of all, your code is very selection intensive.
That is, really what you're doing is automating keystrokes.
as long as you don't have a LOT of data to process, it should
work. It's just not efficient.
You COULD rewrite it using VBA variables and not select as much.
But we'll work with what
Hi Pankaj,
In your attached example put the following formula in cell C2 and copy it
down:
=IF(NOT(ISERROR(VLOOKUP(B2,$A$2:$A$8,1,0))),Match,Mismatch)
The above formula matches the entries in the Column B with the column A.
Pl let me know if this works for you.
Regards,
Andy
On Thu, Sep 30,
Hi Paul,
Thanks for spending time on this. I saw another post of yours about using
dictionaries which got my attention at the time, but then I got distracted by
something shiny, and the moment was lost. I'll have a look at your reply
(below) in detail on the weekend.
But, being a curious
21 matches
Mail list logo
