Hi
My name is Mamoke
I am not very good in Writing macro, but i need help.
I have an excel sheet with data in one sheet(Database), and i want a button in another sheet (weekly), so that when i click on the button, it looks at cell the Week Number (Cell F3 in Weekly), it goes to the first sheet (Database), in Column E (start week) it filter (filters for all the activities that was done in that week number in Database sheet) and then copies all the filtered contents (each row) into the Weekly sheet.
Can you also help me with a button that clears all the content in the Weekly sheet, so that if i want can repeat the function
See attached the spreadsheet
Bookmarks