Hi Pankaj,
Please find attached excel for solution.
Regards,
Swapnil.
On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar rajputpanka...@gmail.comwrote:
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
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.
PFA
Vaibhav J
www.excel.blog.com
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Pankaj Kumar rajputpanka...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 30 Sep 2010 21:15:12
To: excel-macrosexcel-macros@googlegroups.com
Reply-To:
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
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 Ramesh,
I guess if you only want time stamp then you can also use the below formula
in column B.
=IF(A10,TEXT(TODAY(),mm/dd/yy),)
Regards,
Deepak
On Thu, Sep 30, 2010 at 9:02 PM, Paul Schreiner schreiner_p...@att.netwrote:
Where did you place it?
It belongs in the Sheet module for the
Hi Pankaj,
In your case the attached formula can also help.
Regards,
Deepak Rai
On Thu, Sep 30, 2010 at 8:58 PM, Venkat venkat1@gmail.com wrote:
Dear Pankaj,
Look attached resolved formula
Best Regards,
Venkat
On Thu, Sep 30, 2010 at 6:28 PM, Pankaj Kumar
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
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
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
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
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
Dear Mr Hiren Sheth,
Perhaps you are refering to {=TABLE(,B3)} listed in the cells. This is
not an actual function but a table which is part of excel what if
analysis. In Excel 2007 you can go to Data tab What if analysis
Table and with older versions this feature is available in Tools menu.
Hi,
You Can import Data from Web ,Other Excel sheets ,Text, etc by using Get
External Data in The DATA MENU of Excel.
Regards,
Vijay Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for
I noticed that the email was off-line instead of to the group.. so I
included it here.
--
My solution seems to work if the file hasn't been named, so I got more
elaborate:
Hi Paul,
This code is excellent! I've looked up the Help for the Dictionary object,
which clarified it's use quite well. At first I wondered why you had decided to
work backwards, up through the code; then realised (I think) that it's so you
can delete a row (Delete Shift:=xlUp) without
Hi,
How would I prove row 32 is the first visible row through VBA
A = Activewindow.VisibleRange.Row
If i then wanted to make row 50 the first visible row, how could it be done
through VBA
Range(A2).Select
ActiveWindow.SmallScroll Down:=48
There's probably a better way of doing the
Hi,
A simpler alternative for your second requirement:
ActiveWindow.ScrollRow = 50
Regards - Dave.
Date: Tue, 28 Sep 2010 16:08:14 -0700
Subject: $$Excel-Macros$$ Visible Row Below Freeze Pane
From: spa...@corbetteer.co.uk
To: excel-macros@googlegroups.com
With the top row
Hi ALL
am in a process of coding a macro that converts excel to pdf..this has
to perform for an automation process..am almost close to the
result..but need to bypass the savepdf dialogue ..can any body help me
on this...
earlier help is highly appreciated...
Global Const dhcRegSz = 1
Dear Vijay,
In the DATA menu of Excel I have options for Web, Text, Acess, and other
source, I do not have a button for excel-files.
I already tried several option in the menupath but I couldn't let it work
.
In the attachment an example. In practice there are several 100's of
datafiles. The
Hi dave,
Thank you so much I pasted in right place and now it is working
Thanks once again
Regards
Ramkesh
On Thu, Sep 30, 2010 at 9:02 PM, Paul Schreiner schreiner_p...@att.netwrote:
Where did you place it?
It belongs in the Sheet module for the specific sheet.
Not a standard module, or the
Yeah, back about 100 years ago (ok, maybe that's exaggerating)
I discovered that when moving top-to-bottom and delete a row,
it makes the next row the current row, then the next loop iteration
caused it to skip that row.
You handled that by reducing the loop counter.
But I decided that working
Sheet attached for your query.
On Thu, Sep 30, 2010 at 5:58 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 not Match shows Mismatch
in next
Hi Peter,
For this you need to have a common folder where you can store all your Data
files after that through VBA macro you can consolidate all those N numbers
of Data files into a consolidated excel file. You would not able to do this
by manual approach.
Regards,
Deepak Rai
On Fri, Oct 1,
Peter,
I have this macro I will customize it as per your need will soon share the
same with you.
Regards,
Deepak Rai
On Fri, Oct 1, 2010 at 11:35 PM, Deepak Rai daksh1...@gmail.com wrote:
Hi Peter,
For this you need to have a common folder where you can store all your Data
files after
25 matches
Mail list logo