Đã hoàn thành

Modify Existing Excel Macro to add value of similar items and insert an entry in the sheet

Hi I have existing excel macro workbook, when we open and select the excel file it will extract data from work sheets in the file and populate it into a sheet of macro workbook. Now i want help regarding the data populated into the macro workbook. Just we have to add similar data and add its value at the end of data items with the names i give you. You can find the results sheet in the attached macro workbook. we need to add product wise all tanks based on station name present in tank name. For Example in Tank names you will find station as Mundra and its product is H4, then we need to add all the tanks having m4 as product in Mundra and add an entry with a name and its value(sum of all).

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

Xem nhiều hơn: excel macro move data existing cell, code compare excel files find similar items, excel macro cut paste based cell value, excel vba script modify existing vba, install macro existing excel, excel install add macro menu, excel macro add row fill data, excel macro add row increment, cut value cell contains excel macro, add value front data excel, add references excel macro, check add install excel macro vba, excel internet macro add, excel macro display value display, excel macro display value, excel macro add internet explorer favorite, simple excel macro add data form, excel macro find replace multiple items, excel macro add

Về Bên Thuê:
( 0 nhận xét ) Hyderabad, India

ID dự án: #21932875

Được trao cho:

pogodin

Hello ! My experience with vba is more than 10 years. I'll need to clarify a lot. For example, the "Clear Results" button does not clear the data - do you need to fix this ? It is also unclear how the names in the sh Thêm

₹950 INR trong 7 ngày
(3 Đánh Giá)
2.1

16 freelancer đang chào giá trung bình ₹1286 cho công việc này

bhupendrayadav

I am postgraduate with more than 6 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my port Thêm

₹4000 INR trong 1 ngày
(35 Nhận xét)
5.2
reubengi

Hi, I can give you a solution which will give a summary of the data you have on the results sheet. It will be a table with the stations on the left column and Products in the top row. It will show the total stock per s Thêm

₹900 INR trong 1 ngày
(2 Nhận xét)
1.1
krishnakumarh112

Proven experience as data entry clerk Fast typing skills Excellent knowledge of word processing tools 3 years of experience with spreadsheets (MS Office Word, Excel etc.) Basic understanding of databases

₹1200 INR trong 7 ngày
(0 Nhận xét)
0.0
kaptanbharat

Hello, i am interested in your work. I am a dedicated and hard working person who believes in honesty and good working relation. Though I am new at this sector of job but I have certain qualities which makes me good at Thêm

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
WALEEDCIVIL3D

Hello. This sounds like a job I could allocate around 15 hours a week for. I can start immediately, and I am highly skilled in using a computer and being precise. I can start immediately - reach out to me and let's get Thêm

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
₹1300 INR trong 1 ngày
(0 Nhận xét)
0.0
cahandupama

Sri Lanka

₹1300 INR trong 1 ngày
(0 Nhận xét)
0.0
GovindThangavel

We can do it by adding lookups and formulas in macro. I will have to look into the sheet though.

₹1350 INR trong 3 ngày
(0 Nhận xét)
0.0
Sharmaram204

Hello

₹1300 INR trong 1 ngày
(0 Nhận xét)
0.0
TuralGuliyev93

Hi, I am Tural. I would like to help you on your work. I did similar jobs before. I have enough experience.

₹600 INR trong 7 ngày
(0 Nhận xét)
0.0
azimibrahim31

Hi there, I like to be considered for your hire position. I'm a strategic freelancer with strong background expert in Office 365, including data entry, proof reading, social media post, and digital marketing work. I ca Thêm

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0
Loganathan1994

I have done many macros for my office project. hopefully I can do to that macro has you requested... gives us chance....

₹1150 INR trong 5 ngày
(0 Nhận xét)
0.0
₹1300 INR trong 1 ngày
(0 Nhận xét)
0.0
sharmapritam311

Hello there, I can write macro for you that will selectively load data into desired worksheet. I will try to make it adaptable and flexible

₹1029 INR trong 1 ngày
(0 Nhận xét)
0.0
Jsantoso90

I have been working with similar proyects for more than 5 years, job guaranteed and will support after delivering

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0