Hello there,
I'm quite new to all these macro functions, but I'm putting together a Q&A sheet for the sales team and it was getting quite messy so I'm building a new one which will hide information and when the user wants they can expand or unhide the rows with the data in it.
I did play with it a little and recorded a macro which can hide and unhide the selected section, but in the end if I insert rows above the section or inbetween topics everything slips.
How do I make a macro that will always stick with the certain section and not slip if i add rows above or within that section.
I have attached the file to show what I'm trying to do, but I'm a bit lost, hope someone can help me out. I'm a super new at macros so hope someone can help me.
Bookmarks