I'd like an automated macro to generate readable reports from an Excel table. The source is a diff of tables, where the differences between cells are highlighted. The destination is mockuped in the document attached.
I want the Excel macro to act as proposed below :
1. In the worksheet "source", check if each line contains (in any cell) the characters "->"
2. If the line contains the characters "->", create a worksheet according to a mockup
3. In that created worksheet, take the content of the columns "Name" and "Surname" of this line, and put them in designated cells
4. For each cell containing a "->", create a new line in the table of the worksheet, with 4 columns
5. In column 1, insert an ID for the line
6. In column 2, insert the name of the column of this cell
7. In column 3, insert what's on the left of the "->"
8. In column 4, insert what's on the right of the "->"
I'm available for any precisions.
Hi, I have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.
Bu iş için 8 freelancer ortalamada €18/saat teklif veriyor
Hi, I am an excel VBA expert and read through your project description. Thank you for the brief. Each data will have its own sheet represented according to the mockup. Hope to chat with you soon mate! Thanks Sajid