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

excel vba

ResolvedVersion 2003

Vijay has attended:
Excel VBA Intro Intermediate course

Excel VBA

TO ANTHONY:

Hi Anthony,

I trust you are well.

I had an urgent enquiry relating to some data I have to populate on a daily basis - I am currently having some difficulty coding the process, even though I have attempted to use the course delegate file as a template.

It is not a complicated process, literally some data in excel which needs to be categorised by: a monthly date, agent and product, ie three separate spreadsheets.

Please advise on the simplest coding to format some data in excel and resave it under separate tabs.

Thanks,

Vijay

RE: Excel VBA

Hi Vijay

Thanks for your question

First I apologize for the delay in responding to your post.

It would make the task of responding to your post much easier, if I could see an example of your workbook. If you could email it to me at sw@stl-training.co.uk, I will give the matter urgent attention.

Regards

Stephen

RE: Excel VBA

Hi Stephen,

I trust you are well.

Upon your response, I had emailed you a few hours ago re my query - did you receive the email?

Regards,

Vijay

RE: Excel VBA

Hi Vijay

I don't seem to have received the email, but I did have an outlook problem last week so it might be an error at this end

Please send it again and I will investigate

Thanks

Stephen

RE: Excel VBA

Hi Stephen,

I have forwarded the email to you just now.

Regards,

Vijay

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

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.13 secs.