Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2007

Ushettige has attended:
Excel Advanced course

Macros

I maintain a database of 750 listed companies analysed under various metrics. If I incorporate Macros to retreive the top 10 companies to invest in and later add more companies to the list would the original Macro still work?

RE: Macros

Hello Dilanthi

Thanks for your question and welcome to the forum.

I think we managed to solve this one for you at the end of the course - as long as you are inserting new rows of information within the current list then this should work fine.

Please let me know if you come across any problems though.

I will email you tomorrow when I'm back in the office.

Kind regards
Amanda

RE: Macros

Hello Amanda,

Many thanks for your response.

Yes we resolved it at the end of the course. The query was there as I entered it earlier along with the feedback form.

Kind regards,

Dilanthi.

Excel tip:

Quick Zooming in Excel with rollerball mouses

To zoom in and out of your page hold down the control key and roll the wheel up and down. This will zoom up and down 15% at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.