I have a database form that is "powered by progress" that I would like
to write a few small macros for inputing redundant data from an excel
file. The AppActivate command brings the Progress form to the front
but Sendkeys does not work. Any advice for dealing with non-microsoft
programs in this
See attached. I have attached a macro that might help you.
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we d
Hi Michelle,
I don't know such a formula.
Maybe you could find a Database containing Zip Code, Area Code & Time
Zone. Then write some SQL to get what you want.
Eric
--~--~-~--~~~---~--~~
---
Hi there,
Does anyone know of a formula or macro to convert location (zip or
state) to a time zone? (US only)
Thanks!
~Michelle
--~--~-~--~~~---~--~~
-
Some important links for e
Hi Kanwal,
Sorry for being late. Here is your Solution attached with the mail.
It was more easy than before. By putting HLookup, you're half done already.
Do tell us, if more help needed.
Thanks and Regards
Ashish Jain
For more tips, tricks, downloads and problem solutions: visit -->
http://www
Skanda,
How often do you have to do this?
I write reports and macros for a living..
I have reports with 30,000 lines of data.
If I have to do this for an individual report, it's just not worth the effort
to write the macro and test it.
It's just easier to insert the formula and drag it down.
Ho
Paul,
Thanks for the help.Is there any macro for this?
On Tue, Mar 10, 2009 at 11:46 AM, Paul Schreiner wrote:
> This is basic Excel functionality.
> let's say your sample data is in rows 2,3,4 (column headings in row 1)
>
> to "build" your function, select Cell C2 and start the Function Wizard
Hi Skanda,
Not just 1000 but even if you've 5 or more rows of data, you can
drag your formula down to fill all cells of rows automatically. Here
is how to achieve it:
1. Suppose you've data in rows 1 to 1000. and data in Col A and Col B.
Then, Type Formula as suggested in Col C and Col D.
2
This is basic Excel functionality.
let's say your sample data is in rows 2,3,4 (column headings in row 1)
to "build" your function, select Cell C2 and start the Function Wizard
select the "IF" function.
with the type-in bar in the Logical_Test box, click cell A2, then type <>
and click in cell B2
Ashish,
Thanks for the help. This is helpful if we have less number of rows. If I
have a couple of thousand how do we do it?I mean a macro or something like
that.
On Tue, Mar 10, 2009 at 11:38 AM, Ashish Jain <26may.1...@gmail.com> wrote:
>
>
> -
Hi Skanda,
Try this formula based solution:
Col A Col B Col C Col
D
Row 1 5 5 =IF(A1=B1,0,1)
Hi Guys,
If I need to compare two columns in the same worksheet say column A and
Column B. If there is a difference between two corresponding cells in A and
B then result should be '1' in correspoding cell in column C else result
should be '0'.And the difference between col A andCol B should be d
Hi Zaki,
Thanks for your feedback. Can you please send us a snapshot of the
problem/error you received?
or send us the error, what it is saying in written format.
That's how we can improve it and the world. By Constant Feedback and
Improving Mistakes.
P.S. - Please "Enable Macros", when it prom
i downloaded the file but it showed some error and it was not gettin
refreshed.
On Tue, Mar 10, 2009 at 9:46 AM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Friends,
>
> Quite Amazing - No feedbacks !!
>
> For more tips, tricks, downloads and problem solutions: visit -->
> http://www.exc
14 matches
Mail list logo
