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

vba

ResolvedVersion 2003

Matthew has attended:
Excel VBA Intro Intermediate course

VBA

If I have a spreadsheet that I need to take certain data from inthe same column but the row change is various can I run a macro to show this, then return certain lines until the next change?

RE: VBA

Hi Matthew

Thank you for your question

Can you clarify your question for me please? In particular can you define what you mean by the row change is various. If you could knock together a sample spreadsheet showing what you mean, and email that to me that would be helpfull

My email is stephen@stl-training.co.uk

Regards

Stephen

RE: VBA

Hi Stephen,

Thank you for your response and sorry for the delay in my responding to you, I've been away from the office on business.
I've got a Spreadsheet that is the raw data and also a spreadsheet that I want it to look like, Do you have an email address I can send the attachments to?

Regards,
Matthew

RE: VBA

Hi, I wonder if I might get a response to my question please, I've been waiting nearly a month and no response

Thank you
Matthew

RE: VBA

Hi Matthew

Thanks for your question

I apologise for the delay in getting back to you which was the result of both personal health issues and me being away from the office providing on site training.

If the issue is still live, my email address is stephen@stl-training.co.uk. I will give the matter my urgent attention

If it is not, the again please accept my apologies for the delay

Regards

Stephen

RE: VBA

Hi Matthew,

Did you manage to get the spreadsheet over to Stephen?

Regards, Rich

RE: VBA

Hi Rich,

I did get the spreadsheet over but no response yet,

regards,
Matthew

 

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:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

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