Run recorded macro based on current sheet, not the original sheet

**magillmjl** · 08-22-2012, 03:31 PM

Hi,

I took a quick look and couldn't find quite what I am looking for so I figured I'd ask the question instead.

I'm working on a document that's borderline database, but I need to be able to do the entire thing in excel instead of access. Essentially what I'm doing is using the workbork to create individual reports for a group of people. This is how it works:

There is a tab for each person (instructors). They are being evaluated by a number of different people and on a number of different criteria. The data is all entered on the instructors individual tab. I'm in the development phase so I currently only have three test tabs (WO1 Bloggins, WO2 Smith, FSGT Cadet).

Now there is a fourth tab labeled "Report". What I've done is created a macro to put on each tab to populate the individual reports. When I'm on WO1 Bloggins I want to click "Report" and populate a report for that instructor, when I'm on the WO2 Smith sheet I want to be able to click "Report" and have the same report template populate with the information on the WO2 Smith tab.

Right now when I'm on the WO2 Smith tab and click my report button the "Report" tab get's populated with the information from the WO1 Bloggins tab since that's where I recorded the macro.

I'm not overly familiar with macros and VBA so any help on this would be greatly appreciated.

**Mordred** · 08-22-2012, 03:34 PM

How about providing the forum with the macro you recorded? How are we supposed to help otherwise?

**mike7952** · 08-22-2012, 03:34 PM

Hard to tell without seeing your code.. Post your code and or workbook and I'm sure someone can help.

**magillmjl** · 08-22-2012, 03:35 PM

Please Login or Register  to view this content.

That's the code I have, there's a lot of the same action (copy from one sheet, paste to another) and back and forth. I cut all those out since it's the same as the above, with a different cell being referenced.

**rvasquez** · 08-22-2012, 03:36 PM

Hello there,

Could you post your recorded code?

It should just be that you change the lines that look like

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**magillmjl** · 08-22-2012, 03:38 PM

I had tried a few things like that, but I wasn't sure how to use the activesheet function.

**rvasquez** · 08-22-2012, 03:41 PM

If you want to clean up your code you could update it to look like this

Please Login or Register  to view this content.

**magillmjl** · 08-22-2012, 03:48 PM

Thanks, that's exactly what I was looking for. Cleaned up, and it's doing what I want it to do. Thanks again!

**rvasquez** · 08-22-2012, 03:54 PM

Glad to hear it!

**Cutter** · 08-22-2012, 06:23 PM

@ magillmjl

Welcome to the forum. Nice to see your problem has been solved already, but:

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.