Đã hoàn thành

Excel VBA Code & Formatting

Hello,

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.

Kĩ năng: Xử lí dữ liệu, Excel, Excel Macros, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: excel vba format number decimal places, vba format percentage, excel vba format text, excel vba numberformat currency, vba time format, vba format currency, excel vba format number with comma, vba format date, excel vba code save web page, excel vba code pull internet data, ftp connection excel vba code, create domain class excel vba code, excel vba code data web page, excel vba code check add ins, optimize excel vba code

Về Bên Thuê:
( 1 Nhận xét ) Houston, United States

ID dự án: #16976568

Được trao cho:

schoudhary1553

Hello, I can help with you in your project Excel VBA Code & Formatting. I have more than 5 years of experience in Data Processing, Excel, Visual Basic, Visual Basic for Apps. We have worked on several similar projec Thêm

$50 USD trong 1 ngày
(250 Đánh Giá)
7.5

22 freelancer đang chào giá trung bình $31 cho công việc này

KulfiSoftwares

I love excel VBA and automation.. I can write the error free Macro to do the job. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work. https://freelancer.com/u/kulfiSoftwares Thêm

$100 USD trong 3 ngày
(229 Nhận xét)
7.3
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your macros. Please send me a message so that we can discuss more.

$50 USD trong 1 ngày
(264 Nhận xét)
7.1
$25 USD trong 1 ngày
(49 Nhận xét)
6.0
SShtv

I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my works. [login to view URL] Thêm

$25 USD trong 1 ngày
(55 Nhận xét)
5.5
archanaoswal

I have excellent command on MS Excel and have understood your requirements. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automa Thêm

$50 USD trong 1 ngày
(36 Nhận xét)
5.3
$30 USD trong 1 ngày
(36 Nhận xét)
4.8
aubrey03

A proposal has not yet been provided

$30 USD trong 1 ngày
(26 Nhận xét)
4.9
$30 USD trong 1 ngày
(33 Nhận xét)
4.5
guruvenkat

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

$25 USD trong 1 ngày
(17 Nhận xét)
3.7
$30 USD trong 1 ngày
(4 Nhận xét)
3.3
robcastillo

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.

$35 USD trong 2 ngày
(11 Nhận xét)
2.9
maximwang8661

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.

$25 USD trong 1 ngày
(5 Nhận xét)
3.0
$25 USD trong 1 ngày
(2 Nhận xét)
2.4
nguyenanh78

I am very profesional on Excell. I have done many data processing project by using VBA code that I can show you. This solution will reduce mistake and faster than human doing. I also can create very cute templat Thêm

$25 USD trong 1 ngày
(4 Nhận xét)
2.1
tsft

Dear Sir/Madam: I offer to make your macro Excel VBA ASAP. Expertise since 90s. Software architecture and engineering. Personalized service, full back-end and front-end programming. Background Samples at m Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
sarikayadav86

A proposal has not yet been provided

$33 USD trong 1 ngày
(0 Nhận xét)
0.0
ankurcool1995

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.

$15 USD trong 1 ngày
(0 Nhận xét)
0.0
fastwriter24

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SI Thêm

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
sum8809

A proposal has not yet been provided

$10 USD trong 2 ngày
(0 Nhận xét)
0.0
MagdaCichocka

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.

$10 USD trong 3 ngày
(0 Nhận xét)
0.0