Arrangement of auto downloaded report in specific format

[tariqnaz2005]

Hello all,

wish you good health.

I have attached 2 sheets. One is report data which is downloaded. And one is my requirement sheet

can someone help me to arrange the report as per my requirement as per attached.

I just want all yellow highlighted fields to be arranged. This is only 3 statements for example. But i can be more than 1000 reports in one report.

Also company code first 4 digits can be unique number. (just for your info).

Thanks in advance.

[tariqnaz2005]

Dear All, you are requested to help me out. cuz this report is very important for me to arrange a big data.

Thanks in advance.

[AliGW]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[jindon]

VBA, for the data uploaded.

Please Login or Register  to view this content.

[tariqnaz2005]

Dear Jindon,

You are genius.. i dont have words to thanks you. you are great.. Thank you very much. you did exactly what i wanted.

Once again thank you very much.. and thanks to this forum admin also.

Can you add in same VBA a last coluumn N of sheet "my requirement" which gives me total aging days from { (date of clomn c - today() } = total aging days of invoice??

also i got an error Debug at (.Cells(x(i) + 7, 1).Resize(myRows, LC).Copy LastR(2, 3)

Also please instead of "phone" x = Filter(.[transpose(if((a1:a10000="phone")+(a1:a10000="sub total:"),row(1:10000)))], False, 0) please choose another way as sometimes more row were added over the phone row.

So if you choose a unique first 4 digits of Company code that is 2200 always, then may be it can help. so please based on company code 2200 (first 4 digit) find a solution for me. because if you will based on "Phone" it is giving error becase some times more rows added over the phone row.

Thanks

[jindon]

also i got an error Debug at (.Cells(x(i) + 7, 1).Resize(myRows, LC).Copy LastR(2, 3)

I have tested the code before I post and tested it again had no ERROR.
So, your Excel might be different from mime.

[tariqnaz2005]

Ok. Noted.. with many thanks

Please Login or Register  to view this content.

Is there any possibility to solve this issue?? because in my report some times 2 or 3 more lines comes over the phone.. example as below.. i am not sure how many rows can happened.

ABC COMPANY
Place
Street
Phone
EMAIL

I dont know about excel, but if you base unique code first 4 digits, might be it can solve my issue?? please spare your time again.

55881234 ABC COMPANY

[jindon]

If you are talking about the file that is different form the one you posted, I can not offer any suggestion.

If the data imported from some kind of text file, it would be easier to work from it directly.
Otherwise, I need to see the file with ALL possible variation of the data structures.

[tariqnaz2005]

Dear Jindon,

Thanks for reply.

Kindly find attached file. i just want 2 column to be added in beginning for sales person and company name. Pls help me

[jindon]

tariqnaz2005,

You are now asking completely different question from your original one.
So I suggest you to mark this thread as [Solved] and open a new thread.

New question is just Delete/Insert/Cut..etc, I believe it is not so complicated.