Excel Macro to find values in a Pivottable and send that values to data cells
Budget: $10 – $30 USD
I am looking for a freelancer who can create an Excel macro that will allow me to find specific values in a Pivottable and send those values to data cells. Here are the specific requirements for the project:
Specific values in the Pivottable: The macro should be able to find only specific values in the Pivottable.
Preferred format for the data cells: I have a specific format in mind for the data cells, which should be used when sending the values from the Pivottable to the cells.
Additional features required: Automation is needed in the macro, so that the process of finding and sending values can be automated.
Skills and experience required:
- Strong proficiency in Excel and VBA programming
- Experience working with Pivottables and data manipulation
- Knowledge of automation techniques in Excel macros
This is the specific explanation within my file (Excel)
The macro should work in the Tab :"O_U"
The Datacells (where the found values should be added) are also in tab "O_U"
The Pivottable is called "ELOd_ELOh" and is found in Tab "O_U" in cells B7 till H7 and downwards.
The Macro must look for values which are highlighted in cells C2 till F2 and searches the whole Pivottable.
The Pivottable is adjusted daily with new data.
The Datacells are in column K11 and downwards.
The Datacells will be added daily (new data are added) and the macro must fill that Datacells with its findings.
The values the macro should look for are out from Datatable, called "Matchday". Right now the wanted data for search are being send to cells C2 till F2 by a macro called "Aus Zeile kopieren". Unfortunaltely only line by line. Very timeconsuming till now...
As I do not want to send out my file to everyone, I would like to send it only to the ones who are interested in quoting. I am enclosing a screenshot though for your first view.
The file size itself is around 60-70mb
If your skills are good, I believe you can have this arranged in few steps. I tried myself, but got stuck with the filtering inside that Pivottable. Though I m not a skilled programmer or macrowriter at all ... :-)
If you have the necessary skills and experience to complete this project, please submit your proposal. Thank you.
Thomas
Specific values in the Pivottable: The macro should be able to find only specific values in the Pivottable.
Preferred format for the data cells: I have a specific format in mind for the data cells, which should be used when sending the values from the Pivottable to the cells.
Additional features required: Automation is needed in the macro, so that the process of finding and sending values can be automated.
Skills and experience required:
- Strong proficiency in Excel and VBA programming
- Experience working with Pivottables and data manipulation
- Knowledge of automation techniques in Excel macros
This is the specific explanation within my file (Excel)
The macro should work in the Tab :"O_U"
The Datacells (where the found values should be added) are also in tab "O_U"
The Pivottable is called "ELOd_ELOh" and is found in Tab "O_U" in cells B7 till H7 and downwards.
The Macro must look for values which are highlighted in cells C2 till F2 and searches the whole Pivottable.
The Pivottable is adjusted daily with new data.
The Datacells are in column K11 and downwards.
The Datacells will be added daily (new data are added) and the macro must fill that Datacells with its findings.
The values the macro should look for are out from Datatable, called "Matchday". Right now the wanted data for search are being send to cells C2 till F2 by a macro called "Aus Zeile kopieren". Unfortunaltely only line by line. Very timeconsuming till now...
As I do not want to send out my file to everyone, I would like to send it only to the ones who are interested in quoting. I am enclosing a screenshot though for your first view.
The file size itself is around 60-70mb
If your skills are good, I believe you can have this arranged in few steps. I tried myself, but got stuck with the filtering inside that Pivottable. Though I m not a skilled programmer or macrowriter at all ... :-)
If you have the necessary skills and experience to complete this project, please submit your proposal. Thank you.
Thomas