Adding a searchbox and exporting data from a row to a new template (have existing code)

**Gti182** · 08-08-2013, 04:16 AM

Hi All,

I was fortunate enough to receive some excellent code (below) from this forum recently which exports project data from a "project register" file to a template file.

Each row in the project register constitutes a project with a unique project reference number found in column "L" e.g. PS00015.

If there are 50 rows in the project register 50 templates would be populated and saved down. At the momement this macro exports ALL projects within the file.

I've now been asked to add an option to only export 1 project at a time by means of an input box by inserting the project reference number i.e. if i choose project PS00015 only 1 template will be populated with its data.

The below code have some non relevant sections removed to keep it short.

Please Login or Register  to view this content.

**Gti182** · 08-08-2013, 09:16 AM

anybody?

**Leon V (AW)** · 08-08-2013, 09:28 AM

need more detail. there are a lot of undefined variables and a test sheet would be usefull. without that it is really hard to do test runs and de-bugs on any solution.

you can try this as a guess

Please Login or Register  to view this content.

**Gti182** · 08-08-2013, 09:41 AM

Ok will work on a quick example and load it up

**Gti182** · 08-08-2013, 09:55 AM

uploaded the two files, sorry should have thought about that sooner.

This is the actual layout of the files i'm using, only data values have been removed or modified.

**Gti182** · 08-08-2013, 11:14 AM

Thanks Leon, your code works perfectly although noticed had to remove the "Set" from the below code for it to work.

Please Login or Register  to view this content.

changed to

Please Login or Register  to view this content.

I also noticed if you type in an incorrect number it gives a debug error, is there a bit of code i can use to stop the macro if this is done and maybe give an error message "number not found"?

Gave you some reputation kudos

**Leon V (AW)** · 08-08-2013, 11:50 AM

how about this?

Please Login or Register  to view this content.

**Gti182** · 08-08-2013, 11:55 AM

getting a compile error type mismatch on this part

Please Login or Register  to view this content.

**Leon V (AW)** · 08-09-2013, 05:34 AM

change it to

Please Login or Register  to view this content.

**Gti182** · 08-09-2013, 05:47 AM

ah that fixed the compile error but it isn't really doing what i want it to now

When i put a wrong number in still gives a runtime error 91 and if i put nothing in and click ok it exports all the project files? Does your bit of code work in the test files I attached?

**Leon V (AW)** · 08-09-2013, 06:40 AM

I can't download test files (Secure Site) am trying to do this blind.
it was my fault made BG the row property of a range which screws up when you fail to find a range.

Please Login or Register  to view this content.

**Gti182** · 08-09-2013, 06:45 AM

that now works great

didn't realise you were doing it blind, that's really impressive!

Thanks so much Leon!

Adding a searchbox and exporting data from a row to a new template (have existing code)

LinkBack

Thread Tools

Rate This Thread

Display

Adding a searchbox and exporting data from a row to a new template (have existing code)

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Re: Adding a searchbox and exporting data from a row to a new template (have existing code

Thread Information

Users Browsing this Thread

Similar Threads

Adding cell zoom code to already existing code in single worksheet

Help adding to existing code

Adding Code to an Existing UserForm with VBA

Code imports new sheet instead of updating existing & overwrites existing data

adding to an existing line of VBA code

Bookmarks

Bookmarks

Posting Permissions