Sheet one has 74 foods in spanish, each of which has 2 or 3 codes laid out horizontally, and for each code, there is a quantity value below it.
The foods are highlighted yellow, the codes are highlighted grey and the quantities are white.
Sheet two has a list of IDs and Foods (in spanish). It also has an empty column for codes and another one for quantity.
What needs to be done:
1) Data in sheet 1 needs to be matched to the data in sheet two. For each food, the codes and quantity need to be added vertically (add new rows as needed). The first few rows have been done to show what is needed
2) The codes shouldn't have any spaces. In some cases they appear with spaces in the first sheet e.g. "12 x 3". These should appear in the second sheet without spaces e.g. "12x3"
3) Finally, the codes and crop names need to be copied to the new rows that were added (this has been done with the first few rows too)
This si an easy task. I will provide a VBA macro that you can use for future needs. All will be done automaticaly. No manual task and the macro can be used later. Waiting for your reply and ready to start. Thanks
13 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $24
Dear we have a team of 12 people that can handle your [url removed, login to view] have done many projects..we will follow according to your [url removed, login to view] only after the [url removed, login to view] will give you best result with limited [url removed, login to view] Більше
I can do the job. I have lot of experience with excel(you can see previous comments). I can start working on this right now. (I am from Aiken, South Carolina)