Extracting only some data from one worksheet to another

[mellymoo22]

Hi all,

I'm new here and hoping someone can help solve my problem. I'm fairly novice when it comes to Excel and can really only do basic formulas, I have no experience using Macros at all.

I have designed a form which allows my colleagues to complete for visitors coming to our workplace. It contains lots of details (required by security), what I would like to be able to do is extract only some of the data to another worksheet which will show upcoming visitors for the following week in a simplified format. So some people will input visitors that are coming well in advance and others are last minute entries. I would like some sort of automated way that the data will transfer to the appropriate worksheet.

Hope that makes some sort of sense!

[ranman256]

just add your sheet to the save routine:

Please Login or Register  to view this content.