Homework Questions? Ask a Tutor for Answers ASAP
Hope you are doing well.
Zip pdf and excel files; upload the zipped file to http://wikisend.com or http://ge.tt and post download link here.
What is the deadline?
you can upload one by one and provide two download links
i have viewed your excel file. The way the data is arranged, it will require a macro to fix it. I can write one for you, but there will be an additional charge for this. This is not too complicated and will not take very long.
I am sending you an additional service offer. If you choose to accept it. Then I will get started on it right away.
please Let me know what you decide one way or the other.
to the first question, yes, as long as the data is aranaged in the same way. So for example as long as it is 7 rows in 2 columns A and B for each record, then yes the macro would work the same. But if for example, the next one had 8 or 9 rows per record, then it would require modification and that would be additional time, and there would be another charge for that time. So in other words, whatever format you give me your initial file in, will be the format the macro will work on.
As far as what it will do is to split out all of those rows into columns, so since there are 7 rows, it would make 7 columns of the data, and sort the data into those columns on sheet 2, this way the original data would not be modified but rather arranged how you want it to be on sheet 2.
The price that was proposed reflected creating a macro based on the example file you sent. Now if you need each line to be broken up more for example separating the address from the sate and zip that would increase the price. I just assumed you wanted to take 7 rows and just put all of that data into 7 columns instead.
so you only want certain info extracted, and city, state and zip need to be separated out.
That will increase the price a bit.
Yes it would be easier if it were all in a single column.
also, I noticed that some records have 6 lines and some has 7. Is it possible that they could all have the same amount even if one of the rows is blank?
If not I can try to program around it.
Just let please send me an updated example that shows how the source data will be arranged.
please don't yell at me about charges. Why do people always assume I know anything about it. I am just a sub contractor, I don't know anything about how the site bills. I think what I wanted to charge was very reasonable considering the amount of work involved in what you requested.
If you want to get your billing straightened out you will have to contact the customer service for this site. I have no control over this. As it stands, Now I don't trust I will be paid for my time. So therefor I will not be able to assist you.