Would you be able to send me the file so I can take a look at the data. To do so go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
Where is the File ID or download link
Got it, thanks
One moment while I take a look...
Ok this cannot be done with formulas, functions or pivot table. A macro must be written to generate the list in that format. It will however take some time to set up the macro. Let me know
Ok Can you set up a macro. This is only a piece of one file for example only. The file has dates that from 1/1 - 6/30
Upload it at this same site that I gave you
That is a lot more complex than the sample sheet you sent me. Also do you want to generate vertical list for one sheet or all sheets
Accordingly I have sent a price adjustment report. Please confirm if the price looks ok to you and let me know so I can start working on this
If you agree to the suggested price adjustment please confirm so I can start working on it
JA should have sent it to you by email
I have not received anything via email
hmm..There must be an issue with the site
Ok experts are not allowed to suggest a prices in this forum (only through a special price report via JustAnswer). But customer can make an offer and the expert can either take it or not. So you can make an offer and I will let you know
No problem, but there are some reported issues where the system fails to send some emails
In the meantime I finished the major part of the macro. Here is a screenshot of part of the output sheet for the first block of data on sheet 'Greenville'
Please check the above output and let me know is this is what you're trying to accomplish
Ok will send you the result the Greenville tab
Here is the Greensville output for the for the first block of data on Greensville (rows 4 thru 65)
Please check it and let me know
IT LOOKS GOOD AFTER A QUICK REVIEW
I will send the file with the macro for that sheet which should work on any sheet with identical data structure (same columns and starting in the same row). Meanwhile you can rate the answer. Then when you get the file you can add the difference between the suggested price and the current question price as using the Add Bonus button
Thanks. (but the bonus is not the correct balance amount)
Here is the file with the code.
To run the macro click the Go! button on the Greensville main sheet. It will process all data from row 4 until it hits a title row with the phrase "Sort Options:" in column A. To make it work for all data on that sheet you need to remove all intermediate headers and type "Sort Options" in the last row so the macro can know where to stop
Please note that since there is a macro in the file you need to make sure that you have your Excel Options configured so that macros are allowed to run, otherwise nothing happens when you click the button. If you need assistance in this regard please let me know,.and provide the version of Excel you are running
Please use this file instead
It takes care of Ref numbers so they are not increased by 1 within the same client name
Did you notice my comment about the phrase "Sort Options:" which was posted with the message where I sent you the first file.
If you are not familiar with macros I can install a button for you on each sheet, but as I said before the data structure of all sheets should be identical to the first sheet for which the macro was written
Yes please install on all sheets for me. The structure should be identical
Ok I will do that. But as I mentioned before the bonus you paid falls quite short of what was suggested for the question. So how do you intend to correct that
Ok I have set up buttons on all the sheets so will be able to run the macro for each sheet. However as I mentioned before the sheets have to 100% identical with the first sheet for which the macro was created in order that the macro can produce the correct results
Hope this helps