Macro running 35+Macros

[jbarnard]

I have a building with 35 suites, I am trying to track rent.

I created a table on sheet 1 to act as the register, the goal was to have the data from that register filter to the different suites. Each suite will have its own sheet, I have only done 11 so far because I wanted to make sure I did it right.

Created a Macro on each sheet for its specific Advanced Filter. Then created a Macro to run all the Macros. Then created a button labeled "Save Rents" to activate the Macro.

Works perfect for the first 5 sheets then stops, all of the filters work individually just not with the Macro. Also it clears my data from my register. I don't want it to clear the data.

New to Macros created this by reading off the internet now I am stuck.

Thanks for the help.

-Jeremy

[ag273n]

i tested your macros one by one...

and i noticed the problem is with macro "Suite6", then later i noticed the other macros from Suite6 going up has the same problem...

this is macro suit5:

Please Login or Register  to view this content.

and this is macro suite6:

Please Login or Register  to view this content.

notice the difference?

well..
this part is the problem: (suite6 and up)

Please Login or Register  to view this content.

the target range for pasting was not defined upon recording the macro, or maybe overlooked upon editing...

this means (if the macro was recorded), some steps crucial for its function was skipped - the paste area...


i recommend record all the other macros, from macro suite6 going up to macro suite 10
i'm not sure what macro suite11 does...

[stnkynts]

Get rid of all the macros. Try this and see if it does what you want.

Please Login or Register  to view this content.

[jbarnard]

"i tested your macros one by one...

and i noticed the problem is with macro "Suite6", then later i noticed the other macros from Suite6 going up has the same problem...

this is macro suit5:"

Ah I do see the difference. They must have messed up when I recorded them. I will rerecord 6-11.

Editted 6-11 and it worked PERFECTLY Thank you so much!

[jbarnard]

"Get rid of all the macros. Try this and see if it does what you want."
I deleted the Macros and copy pasted this into the VBA. Saved, closed then reopened.

It didn't seem to do anything am I missing something?

Sorry for my ignorance I am still learning.

[ag273n]

if you wanna try the macro that stnkynts advised, what you wanna do is:

1st. go to your VBA editor (Press alt+F11)
on the left side, you'll see somethings name "Module"

2nd. just double click any module
you'll see some that has contents, and others that doesnt
find one that doesnt have contents,

3rd. Paste the code created by stnkynts
just copy all the code he created and remember its sub name "RunME"
then you'll paste it on this part (the module)

4th. close the editor (just hit the "X" button on the top right)
then go to your macros and asign it to the button you created on that page like how you did with the macros you had..

5th. click "Save" before testing it coz after macros are run, it will not let you undo the action made...




and

if the tips we gave you helped:
click the star "*" icon that says add reputation (to say thank you)
and mark this thread closed by going to the top of the thread and clicking "Thread Tools"
then select "Mark as solved"