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

macros error

ResolvedVersion 2007

Cain has attended:
Excel Advanced course

Macros error

I am creating a macro that copies content from sheet 1 to sheet 2. The detail in sheet 1 is summaried in a table on sheet 2. When i change content on Sheet 1 i want to run the macro to copy the content and list in the table on sheet 2.

I set this up the other day and it worked perfectly. I open the worksheet and run it today and it doesnt work correctly. Can you please tell me why this may be happening? Any ideas?

Thanks,

Cain

RE: Macros error

Hello Cain

Thank you for your post relating the Excel issue you are facing.

We would need to see your actual working files to better understand what is happening and if we can find a solution.

Should it be a five minute fix we will let you know, however if it looks to be more involved and that we need to commit trainer time towards it then there will be related costs.

If you would like to take this further please reply to my email.

Kind regards

Jacob

Tue 29 Jun 2010: Automatically marked as resolved.

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

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