dear all,
i have a dynamic column A which i used as a lookup value formula in column
B, but since the column A is dynamic, how to create a vba code to copy the
formula in say B1, down to the last row equal to column A.
im using excel2003 . thanks a lot.
--
--
Ayush Jain has sent you a link to a blog:
Dear Group, Here is a tip for you to faster access of worksheets in
Excel Best regards, Ayush Jain Group Owner
Blog: Excel Daily Tip
Post: Faster access to worksheets
Link:
http://exceldailytip.blogspot.com/2010/03/faster-access-to-worksheets.html
--
Pow
dear expert,
im new in vba but my work is truly repetitive. I want to select a range and
print preview it.
example my row heading is row 1:5, and my column heading is col A:D, I want
to select the range starting row 6 until last column with data and last row.
Any VBA please. Microsoft helps pro
Simplest possible. But needed unique list (no duplication).
Regards
Sandeep
On Thu, Mar 18, 2010 at 8:37 PM, Dilip Pandey wrote:
> Dear Venkatesan,
>
> Attached file has two solutions for your query.
> Let me know in case of any challenge(s).
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
Hi,
Did you try "Exit for" in FOR loop where the condition is met and
further looping is not required.
Give it a try...It should help.
Best regards,
Ayush Jain
On Mar 19, 7:00 am, scubagirl wrote:
> I have a fairly large VBA project for work - it runs a Monte Carlo
> simulation on some data th
I want to create an email when the value in column A changes. In
column A I have the email addresses of managers. When the email
address changes I want the VBA to compose the email and get the
employees names in column B assoicated to that email address. I
don't
want it 1 for 1. I want to take
I have a fairly large VBA project for work - it runs a Monte Carlo
simulation on some data that is grabbed from MS Project. It takes
longer than I'd like to run - about 4 minutes for 1000 iterations, not
including writing out to Excel. I have done everything I can think of
to make it efficient: usi
Hi everyone,
I have a program that generates Excel workbooks with multiple sheets
of data , and a function that create a chart each time it's called,
which happens 2 times per workbook. In order to make the chart, I have
to sort the data first, which I've tried a few different ways. No
matter which
Hello,
it seems not to be possible to program a real popup menu without the
usage of a command bar. Is this true?
I would like to create a button and when someone click on it a popup
(like on the right click on items) is shown at the position of the
button. With the command bars I have to create a
It should tell you which cell contains the link. Go to it and delete
it. You will need to hard code the data.
On Mar 17, 3:31 pm, "~slacker~" wrote:
> I need help in breaking data links to other excel workbooks. The excel
> workbook I am using (excel 2007) has links to other workbooks that can
>
with Excel 2007 the Help options seem to be much better. Along with
this a pretty extensive list of shortcut keys
http://office.microsoft.com/client/helppreview.aspx?AssetID=HP100738481033&QueryID=2M8Hx7LZd&respos=5&rt=2&ns=EXCEL&lcid=1033&pid=CH100947761033
some of my favorites:
CTRL+SHIFT+END e
hello friends, I have a biometric reader from Microsoft (Microsoft
fingerprint reader)
I can use it to identify people via Excel VBA?
Att,
Ulisses Flores
Baruch Ben Avraham
לוהים הוא האש מכלה
--
--
Some import
Dear Venkatesan,
Attached file has two solutions for your query.
Let me know in case of any challenge(s).
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Thu, Mar 18, 2010 at 2:31 PM, Ve
just applt vlook and get the data
On 3/18/10, Venkatesan c wrote:
>
> Dear All,
>
> Any one can Assist me attached file query It's something like reverse
> Lookup
>
> --
>
> --
> Some important links for excel users:
Thanks group for your overwhelmed response on this topic.
@Shyam : Thanks for sharing tips and bugs. you are excellent member of
group. I am proud that you are part of this group. Keep Posting.
@Sudhir : Thanks for idea but it appears tedious to edit the file and
upload in the group. There will b
Hi,
Is there any way of creating pivot table on horizontal data? Means the
headings are in the rows (instead of columns) and data is in horizontal form
instead of vertical.
I can't use copy and transpose option because of macros and functions in the
workbook.
--
Regards,
Ajay Varshney
--
---
Personally, whenever I start a new job, or install a new version of
Excel, the first thing I do is record the following macro.
Sub CopyPasteSpecialValues()
'
' CopyPasteSpecialValues Macro
' Macro recorded 27/11/2008
' Keyboard Shortcut: Ctrl+Shift+V
'
Selection.Copy
Selection.PasteSpecial
Try the following attached file
This is a left lookup
On Thu, Mar 18, 2010 at 5:01 AM, Venkatesan c wrote:
> Dear All,
>
> Any one can Assist me attached file query It's something like reverse
> Lookup
>
> --
>
> --
Hi Ayush
It is better idea. Please add an common file
which will used by every one and time to time
add their tips and then we have single file with lots of
formula's and idea's
Please everybody download common file, add your
suggetion and formula and upload as reply on the our group
mail.
Thank
Hello All
Some of bug i have remember.trying to share with you.
On Thu, Mar 18, 2010 at 9:56 AM, Ayush wrote:
> Hello Everyone,
>
> I request you all to share any tips or tricks that you have about MS
> Excel in the group. It really helps.
>
> The tip can be anything like formula, m
hello friends, I have a biometric reader from Microsoft (Microsoft
fingerprint reader)
I can use it to identify people via Excel VBA?
Att,
Ulisses Flores
Baruch Ben Avraham
לוהים הוא האש מכלה
--
--
Some importa
Hello Ayush
You have started a good topic,I think in this topic we can share our
some tips and tricks.I am starting a topic ...
''
Diffrence between VBA & .NET
'''
Dear All,
Any one can Assist me attached file query It's something like reverse Lookup
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Yes, that's true.
Can you clear the data from the file and send me the BLANK sheet?
I'm really only trying to see if the lock/unlock is being set properly.
Paul
From: Jeff
To: MS EXCEL AND VBA MACROS
Sent: Wed, March 17, 2010 7:11:26 PM
Subject: Re: $$Excel-
Hello,
I tried this Application.Caller function but it returned not a string
it returned a variant object. So I don't know how to get the button
from the variant.
I create the button with
Set MenuItem = Menu2.Controls.Add(Type:=msoControlButton)
MenuItem.Caption = aSheet.C
25 matches
Mail list logo
