Joshua,
Thank you so much for your response. Unfortunately this isn't working. The
formula in col I is referencing col H which is where I originally wanted the
formula. There will be no data in col H unless I can't get a formula to work
in
there, then it will be manually entered. Can you h
Hi Hiren,
Well here's the thing. What you have here is a classic one variable
data table.
Essentially what it is doing is, well lets just say you've done your
calculation on something.
(which in this case is a payroll calculation in A1 to B11.
Now what a one-variable data table does is it lets yo
Hi,
I am quit new to excel. I like to know if it is possible to import
data from one excel document into another. The most ideal solution
would be that after starting up an excel file you can somehow specify
another excel file and import the data from that file into the file
you opened. The data o
HI Team,
I am looking for a macro for copy selective folders by name from
various subfolders.
Instance:
Folder A has 3 subfolders named (aaa, bbb, ccc)
Each subfolder has super subfolders as (Input & Output)
Requirement:
I have to copy all Output folders from Each Parent folder by replacing
t
MODELNUMBER123 Part 1A 123 Part 1B 0 Part 2A 234
Part 2B 0 Part 3A 456 Part 3B 432 I'm
implementing a part scanning system For some models we only use Part 1A
and some models Part 1A and Part 1B. Same thing for Parts 2 and 3. In such
c
Hi Pankaj,
In your case the attached formula can also help.
Regards,
Deepak Rai
On Thu, Sep 30, 2010 at 8:58 PM, Venkat wrote:
> Dear Pankaj,
>
> Look attached resolved formula
>
> Best Regards,
>
> Venkat
> On Thu, Sep 30, 2010 at 6:28 PM, Pankaj Kumar
> wrote:
>
>>
>> Hi, All Experts,
>>
Hi Ramesh,
I guess if you only want time stamp then you can also use the below formula
in column B.
=IF(A1>0,TEXT(TODAY(),"mm/dd/yy"),"")
Regards,
Deepak
On Thu, Sep 30, 2010 at 9:02 PM, Paul Schreiner wrote:
> Where did you place it?
> It belongs in the Sheet module for the specific sheet.
>
Hi experts,
how to eleminate zeros while selective range for average
function.Please find the attachement here fro your reference.
Regards,
Rao
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hi Paul -
Thank you for your reply.
I have added in your suggestion, but unfortunately I am still having a
bit of an issue.
The find now activates the correct cell, and the offset moves the
active cell one to the left, but it is only selecting that particular
row to copy and paste into the other t
PFA
Vaibhav J
www.excel.blog.com
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Pankaj Kumar
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Sep 2010 21:15:12
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hi
Hi, exper it urgent i
Hi,
I need some HELP with increment flagging.
By flag I mean a One appears when an even happens, and a Zero appears
when it doesn't
And by incremental flags I mean that the even occurs at a fixed
frequency but only after the event has occured.
Let me explain, what I have in my excel sheet.
Assumi
Hi Pankaj,
Please find attached excel for solution.
Regards,
Swapnil.
On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar wrote:
> 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
>rajp
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 lad,
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 3
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 wh
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.
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 hel
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 work
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*
--
Dear Pankaj,
Look attached resolved formula
Best Regards,
Venkat
On Thu, Sep 30, 2010 at 6:28 PM, Pankaj Kumar wrote:
>
> 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
PFA
sheet with formula
Vaibhav J
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Pankaj Kumar
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Sep 2010 18:28:53
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Querry
Hi, All E
Where did you place it?
It belongs in the Sheet module for the specific sheet.
Not a "standard" module, or the This workbook module.
>
>From: Ramkesh Maurya
>To: excel-macros@googlegroups.com
>Sent: Thu, September 30, 2010 10:51:38 AM
>Subject: Re: $$Excel-Macros$$
>
>
>Hi Dave,
>
>I copied the
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:
Please post a NEW topic instead of "hijacking" another discussion thread.
P
>
>From: Rakesh Sharma
>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 / file
>location
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 = F
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
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 mis-
*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, Jo
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 wo
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
> Dear All R/s Friends
>
> Dilip Pandey is great personality . That is truth. He is genius and great
> knowledge of excel vba. I salute
Hi,
Can anyone please assist me on this.
Thanks,
Sharma
On Wed, Sep 29, 2010 at 10:08 AM, amrahs k 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 solve this issu
Hi
Thanks Paul
On Wed, Sep 29, 2010 at 5:53 PM, Paul Schreiner wrote:
> 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 checking to see if t
Build a "key" in column g. The formula for the key should be:
=a2&b2&c2&f2
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 matc
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
wrote:
> A further question: Do you want the date in Col B to
34 matches
Mail list logo