• 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 pull in Specific Format

A

Abhijeet

Active Member
Hi

I have Data in Excel In Column B Assignment Numbers Column C is Day mention & E1 cell has Month & Year mention. If Column D data any Units mention then Expected result sheet Pull Standby NR NHS in Element Name Column That is Col D Value2 In Col N i want Local On-Call Standby.

Same For Work Done NR NHS If any Units mention in Column H then i want in excpected result sheet column D Work Done NR NHS.Only in Column I which Band is mention as per that Data pull in Value 2 that is column N

For Both element Units i want in Column O & Date in Col P i want Data from which sheet pull that sheet name in Col Q
 

Attachments

  • element wise.xlsx
    26.2 KB · Views: 13
Hi

I tried to do this now i want each file data pull in this type & which sheets data that sheet name i want please tell me how to do this
 

Attachments

  • file format.xlsm
    35 KB · Views: 5
This macro pull only Sheet1 data in Result & work done sheets. I have same format of data in 10 to 15 sheets i want to pull all sheets data in Result & Work done Sheets please tell me
 
You must log in or register to reply here.
Back
Top