Завершено

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).

Квалификация: Excel, Visual Basic, Обработка данных, Visual Basic для приложений, Excel Macros

Показать больше 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

О работодателе:
( 0 отзыв(-а, -ов) ) Hyderabad, India

ID проекта: #21932875

Поручен:

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 Больше

₹950 INR за 7 дней(-я)
(3 отзывов(-а))
2.1

16 фрилансеров(-а) в среднем готовы выполнить эту работу за ₹1286

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 Больше

₹4000 INR за 1 день
(35 отзывов(-а))
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 Больше

₹900 INR за 1 день
(2 отзывов(-а))
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 за 7 дней(-я)
(0 отзывов(-а))
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 Больше

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
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 Больше

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
₹1300 INR за 1 день
(0 отзывов(-а))
0.0
cahandupama

Sri Lanka

₹1300 INR за 1 день
(0 отзывов(-а))
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 за 3 дней(-я)
(0 отзывов(-а))
0.0
Sharmaram204

Hello

₹1300 INR за 1 день
(0 отзывов(-а))
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 за 7 дней(-я)
(0 отзывов(-а))
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 Больше

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
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 за 5 дней(-я)
(0 отзывов(-а))
0.0
₹1300 INR за 1 день
(0 отзывов(-а))
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 за 1 день
(0 отзывов(-а))
0.0
Jsantoso90

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

₹1050 INR за 7 дней(-я)
(0 отзывов(-а))
0.0