Needing a macro that will -
!) Unhide MASTER_CALENDAR (it's not hidden in sample)
2) copy formulas from E11-AI111 from MASTER_CALENDAR to same range in CALENDAR WS (with no links or references, of course)
3) rehide MASTER_CALENDAR
Please and thank you
Brenda
Can you try this:
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
as you are after MACRO
this should of been posted in the VBA section
in VBA you can copy from hidden worksheets
so your code is really just one line
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
GC Excel,
Seems so easy when you put it like that.
Perfect.
Thank you!
Humdingaling,
This works perfectly too. Thank you.
Just what a girl wants when she shops. Choices! lol
Thank you both, Humdingaling and GC Excel.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks