using macros across a sheet

**daveyboy123** · 02-03-2008, 09:51 AM

Hi all,
how do I use a macro across a spreadsheet?I can record a macro OK,but when I try to use it again on the same spreadsheet all I get is the macro calculating using the same data as when I recorded it.I have several groups of data across one spreadsheet and I want to use the same macro over the entire sheet.How do I do this?Thanks in advance,
Dave

**VBA Noob** · 02-03-2008, 09:54 AM

Please read forum rules below. I've move your post to programming

If you add your code use

Please Login or Register  to view this content.

as per example and someone will take a look

VBA Noob

**daveyboy123** · 02-03-2008, 10:00 AM

Hi all,
how do I use a macro across a spreadsheet?I can record a macro OK,but when I try to use it again on the same spreadsheet all I get is the macro calculating using the same data as when I recorded it.I have several groups of data across one spreadsheet and I want to use the same macro over the entire sheet.How do I do this?Thanks in advance,
Dave

**VBA Noob** · 02-03-2008, 10:24 AM

daveyboy123,

Please read forum rules and message to cross posters below and then add a link to your cross post

Also your duplicate posts have being merged

VBA Noob

**royUK** · 02-03-2008, 10:26 AM

I think this is the same question

http://www.excelforum.com/showthread.php?t=631931

**daveyboy123** · 02-03-2008, 10:38 AM

Ok,here is the workbook.Hopefully someone can help!Pleas keep in mind I am a complete noob with Excel!

**Norie** · 02-03-2008, 11:19 AM

Nice workbook - shame there's no code in it.

**royUK** · 02-03-2008, 12:04 PM

There's nothing to indicate what you are averaging.

**daveyboy123** · 02-03-2008, 12:29 PM

Sorry all,as I said I am new to all this!I need the averages across all the %age rows for every compartment(A1,A2,A3 etc)Here it is again,this time if you look at A1(column 18) I have worked out the averages across all the rows....I need a simple macro that will do this for me over the whole sheet.I have very little of experience of Excel,but I can get a macro to work for one compartment.

**royUK** · 02-03-2008, 01:35 PM

I can't see why you need a macro to do this.

Why not set up a sheet for each compartment? If you did you could have a template sheet with all the formatting & calculations in ready to use.

**daveyboy123** · 02-03-2008, 03:15 PM

That would seem to be a good idea mate.Trouble is I have know idea how to set up a template that could be used in that way.

**royUK** · 02-03-2008, 03:21 PM

Originally Posted by daveyboy123

That would seem to be a good idea mate.Trouble is I have know idea how to set up a template that could be used in that way.

You just set up one sheet formatted how you want it to look, then add all the formulas that you need. Then ximply copy the sheet for each compartment, adding the relevant data.

**daveyboy123** · 02-03-2008, 03:58 PM

Cheers for your help Roy.I understand what you are saying,but how do I set the calculations into the template?I probably sound completely thick....but as I said I have not used Excel much before.The actual data entry has been fine,and I have created graphs and calculated coefficients without many problems.Its just that with this sort of software if you dont know what you are doing its very hard to just stumble onto the solution.....it takes a while to even learn the correct terminology to use when asking questions!

**VBA Noob** · 02-03-2008, 04:23 PM

daveyboy123,

Add the link to the cross post as requested or thread will be locked

VBA Noob

**daveyboy123** · 02-03-2008, 05:11 PM

Here is the link to the cross post...
http://www.excelforum.com/showthread.php?t=631931

**daveyboy123** · 02-03-2008, 06:27 PM

My initial question has been solved here
http://www.mrexcel.com/forum/showthread.php?t=301445

But I would still like to know how to set the calculations into a template,if you dont mind Roy.

**royUK** · 02-03-2008, 06:31 PM

If you had included the code in your workbook you might have had a solution here sooner. I'll look at your template needs later.

**daveyboy123** · 02-03-2008, 06:59 PM

I realise I should have included the code earlier,but I didnt know how to find it then!Thanks for your continuing help Roy.Cheers,
Dave

**royUK** · 02-04-2008, 09:10 AM

There's an example of using a sheet as a template - Summary sheet - here

http://www.excel-it.com/workbook_downloads.htm

**daveyboy123** · 02-04-2008, 06:34 PM

Thanks a lot for your help Roy,my problems have been solved.

using macros across a sheet

LinkBack

Thread Tools

Rate This Thread

Display

using macros across a sheet

using macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions