• 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.

Export trough VBA userfrom on a new excel file through Seleted Condition

A

aryan

Member
Hi Team,

Please help me in making a user form through I wan to pull the data from a pre-exit excel file and want to pull certain data based on the selected conditons into a new excel file according the selected heading.

Regards
Aryan
 

Attachments

Thanks Dear Marc,

Give me sometime I will modify the changes and reply on the same. Thanks for answering my question.

Regards
Aryan
 
Dear Marc,

Please find the attachment.
In this userform I want to pull the data in two sheets namely fresher and experience sheet.

Like if i choose employee code then then it give me result in fresher and experience sheet result in their column headings.
second thing if i choose combination with other fields, like emp code with dates, process or without process, status with active and inactive and tenure with combination or without combination i want to pull the data in their respective sheets.
In Tenure If i put the numbers it give the selected months(like i put 5 give the 5 months results or etc.)
Overall In userform I want combination of selecting the data or without selecting the data.

Request to you please help me in coding
 

Attachments


I can't understand anything of your need !
Maybe another one could …
In case of any more answer, try to detail.

​
 
Dear Marc,
Sorry for non-understandable language
In simple term what I want is this:

I have a master sheet in excel which contains data for fresher or experience people.

Over all I have three sheets in my workbook. Master sheet, Fresher Sheet, or experience sheet.

Master sheet is my source data through I want to pull the data in fresher and experience sheet.
Fresher sheet has certain column heading which has taken from master sheet and I want to pull the fresher sheet data from master sheet data.

same goes for experience sheet case.

Through Userform I want to pull the data in different sheets.

Userform has different fields through i want to pull the data with combination of it.


Regards
Aryan
 
You must log in or register to reply here.
Back
Top