I am new to Excel, and trying to write code for VBA, but just found myself spending whole day on it and running in to error all the time.
I attached Utilization new template file, and what I am trying to do is:
1)A-Asset Inventory WorkSheet - Cell D3 I created a dropdown validation for "All, Owned and Rental".
I need to insert a button "Hide/Show Rows" above D3, that will reffect dropdown selection.
I need to be able to filter based on the D3 value. There are multiple tables in this spreadsheet, and I need to keep them this way without combining, that's why I can't use Autofilter option.
All - suppose to show all vendors
Owned - "Sunshine"
Rental - rest of it ("Vendor1", "Vendor2", etc)
2) If you go to Equipment tracking Worksheet - purpose of it to track each equipment on a daily basis.
So far I just used data from Table 1 for Separators in there, and each day will be selecting where it currently is.
Since Data in this Worksheet is extracted from "A-Asset Inventory", every time I sort or filter data in there, it will reflect "Equipment tracking" too, however, the actual tracking by dates (D7:D14) are not being sorted, and it messes up everything. I tried to put them independent / set down as a column, still it's not changing while the rest of the data is being sorted.
23 pekerja bebas membida secara purata $31 untuk pekerjaan ini
Hello I can help you to get it done quickly. I have 10+ years experience in Microsoft Technologies development Like MS SQL, Visual Basic, MS Access and Excel. Thanks Guru Venkat
Hello, I am interested in help you with your worksheet, if there are any other details I should need to know, please send me a message, so I can help you in the best way possible. Best Regards, Roberto C.
hello. nice to meet you. I am a good excel vba expert. I have a lot of experience in excel vba. If you hire me, I will try my best for your project. Thank you for your job posting.
Hi I am good in excel with advanced formulas & VBA Macros. I will deliver best on time. As soon as , you give me your project, under 3-4 Hrs, I will deliver. Thanks.
12+ Years of experience in preparing reports with Excel. Well aware of Excel formulas, pivot tables and VBA Macro coding to generate the desired output from raw data in CSV/txt/doc formats.
I can help you with this project. I’ve done projects that filter, sort and format data, for example 50 000 rows of restaurant orders, created automatic filters in VBA to show statistics for chosen by user product.