• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data paste in particular format

Abhijeet

Active Member
Hi

I have data in excel i want pull that data in particular format. In attach file i show the data & expected result also i upload only 1 sheet data but i have for than 10 to 15 sheets data and i want dynamic range because data is more than this till 100 rows & columns are till Z.Please give me macro for this
 

Attachments

  • Data paste in particular format.xlsx
    11 KB · Views: 9
Hi:

Please find the attached. I have created a macro for formatting
Thanks
 

Attachments

  • Data paste in particular format.xlsm
    20.5 KB · Views: 2
Hi Nebu can u please give me dynamic range data is Range is A1:Z1000 so please give me dynamic range. As well as more than 15 to 20 sheets data
 
Done....
Find the attached
 

Attachments

  • Data paste in particular format.xlsm
    18.7 KB · Views: 3
I this macro pull only one sheet data i have more than 15 to 20 sheets so i want those data also so can u please tell me how to add those & please add which sheet data is in last column that is G column
 
you have to put a loop to skip through multiple sheets , upload a file with multiple sheets the macro I have give will more or less remain the same...
 
This is more than 1 sheet data please give me Dynamic Range
 

Attachments

  • Data paste in particular formatVer1.1.xlsx
    22.4 KB · Views: 1
Please find the attached it will loop through multiple sheets and consolidate the data in expected results tab...
 

Attachments

  • Data paste in particular formatVer1.1.xlsm
    34.8 KB · Views: 2
Hi Nebu

Can please help me.In this file Assignment Column that is Column A Problem is Only 1st cell the assignment number is mention If Column B more than 1 cells date value then fill the assignment number & pull that data in expected result sheet. I am highlighted those blank cells assignment numbers in Expected Result sheet in Color .Please tell me
 

Attachments

  • Data paste in particular formatVer1.2.xlsm
    18.7 KB · Views: 2
Back
Top