Afternoon all,
I'm hoping i can get some help with this problem.
I have a spreadsheet with 5 sheets. The first sheet needs to be a combination of the other 4 tabs. The last 4 tabs are managed by individuals and only specific rows from each ones are required on the first tab.
Basically if column L has "Active" typed into it, it needs to be added to the front sheet dynamically. As the number of rows required to be copied to tab 1 will constantly be changing, they need to be added dynamically, rather than using a formula which will designate a certain cell or row to the data from a specific cell or row from a specific sheet.
I am desperate for help on this one as i have been trawling google etc and have found some macros or VB scripts but unfortunately, as i dont understand any of it i have no reference points to try to kind reverse engineer them.
Your help is most appreciated and i have attached an example of the workbook i am using.
Many, many thanks
Bookmarks