Blog of Mr C

Educational ICT links and musings….

I love a challenge…

Steve asked if anyone could help with a little excel project he was working on and I’ve had a go and the result can be downloaded here.

I copied the original sheet into a new sheet and recorded a quick macro that copied the random numbers from one sheet and then pasted them as values in the next.  I also added a little conditional formatting for the incorrect/correct statements.  I think it works OK but if you change the sheet names you will need to change the macro as well.

Advertisements

May 24, 2007 - Posted by | ICT

1 Comment »

  1. […] thanks to Tim I have now completed the additional model, you can download it from […]

    Pingback by Thunder » Addition in Excel (part2) | June 7, 2007 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: