Copy Paste in proper format - VBA

[pankajinfo]

Dear All,

i was stuck in a situation in Excel. When i am downloading a file from SAP it it exporting in .xls but in different format. PFA

 

[PeterB]

Hi Pankajinfo,

Welcome to Chandoo. Please read http://forum.chandoo.org/forums/new-users-please-start-here.14/

In terms of your query, are you saying that you want a VBA solution to take the SAP Exported format and turn it into the Required Format?

And if so, will the SAP format always have the same structure as the few lines that you have shown in your file?

Regards,

Peter

 

[sudipto3003]

will you tell me which sap code you are using here? actually in some sap reports there is a option ctrl+shift+F7 which open a excel report format on the same window and you can copy the data from there to any excel sheet.

 

[pankajinfo]

yes it will always be the same format but i want it by loop. Multiple items in same structure these are only sample.

if you have any better solution without using VBA then please provide.


i am using MB52


Thanks in Advance

 

[sudipto3003]

hi pankaj,
please go through the attach file may be it help you.

 

[SirJB7]

Hi, pankajinfo!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, give a look at the uploaded file, just in case you can't manage to handle telling SAP to obey you.

Regards!

 

[pankajinfo]

Hi, pankajinfo!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, give a look at the uploaded file, just in case you can't manage to handle telling SAP to obey you.

Regards!

I already read