gregfthompson
asked on
Extend Excel macro across multiple worksheets
The macro retrieves specific rows from a single worksheet. The objective is to have the macro work across all worksheets within the file. See attached file with macro attached to sheet 1.
2011-Australia-ailments-macro.xlsm
2011-Australia-ailments-macro.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jigneshthar,
Thanks for your question.
I want to be able to amend "MyCodes = Array(2621)" to a specific postcode and then have each worksheet show only the rows that contain that postcode.
Does this make sense?
Thanks,
Greg
Thanks for your question.
I want to be able to amend "MyCodes = Array(2621)" to a specific postcode and then have each worksheet show only the rows that contain that postcode.
Does this make sense?
Thanks,
Greg
ASKER
Oops. My error. It already works as required.
Open in new window
Should paste on sheet called 'Main'
So make a sheet called main and call the sub from there.