I have a database in excel and I need an automated way to do some constant moves (using filters).
I want to write some numbers on the yellow area (Columns N until Y) and then the excel filter and show the rows that this number appear.
Doing all this manually takes me a lot of time and I want an automated way with macros or any other suggested easy way to do it
Also I need a button or a way to reset all moves done so I can start again writing new numbers, and not clearing manually all filters..I have and example and attach a sample of the excel
Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
Μιλώ ελληνικά (αν είσαι πατριωτάκι).
€25 EUR en 3 días
4,9 (266 comentarios)
7,6
7,6
10 freelancers están ofertando un promedio de €24 EUR por este trabajo
Hi Sir. I can write a VBA macro to automate your Excel sheet. You shall be able to do it all on the click of a button. Please discuss so we may continue. Thank you. Usman
We have both passion & expertise to do the job well, we are passionate team working in Excel for well over 15 years.
Looking forward to work with you.
Thank you.
Hi! I can do this macro for 1 or two hours. Really, it`s easy for me. And i will make for You button which clearing yellow row and all of filtres will be clear.