Macro sheet export

[santille]

Hi,

The macro in attachement allows me to export lines from a sheet to another sheet according to a predefined criteria.
Here is the macro :

Please Login or Register  to view this content.

With this macro I can only write a variable and export from sheet 1 to sheet 2 one time.
I would optimize this giving the possibility to the user, on the sheet 1, to write a value and a place to export. For
inventaire.zipexample the user writes in an input the Number (Numero) 00.00. and in an another input Sheet4 (Feuil4). Next he press
execute button.

Is it possible and how to do that?

Thanks for your help.

seb

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[AlphaFrog]

This uses cell I2 as the destination sheet name input.

Please Login or Register  to view this content.

[santille]

Thanks Mr. Davis.

Execution error. Property or method not recognized.
Inputs are OK but the macro does not finish.

seb

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[santille]

Thanks.

Mr. Davis, your last script always returns the same incorrect message.

Thanks.

seb

[JOHN H. DAVIS]

When I tested it with the first code it error because there was a mistake in the code. I fixed that and used the code posted in Post #5. That code did not error when I tested on your sample. What message are you receiving now? Did you try AlphaFrog's suggestion?

[santille]

Thanks John, it's working with #5 code.
However there is a bug when you execute the macro two times one after the other : for example firstly I write the value 00.00. then 1 (sheet number 1) and the result is correct. Secondly I write 01.01. and sheet 2 and strangely it empties the sheet 1... It must be something missing in the code but what?

I just ask myself about the AlphaFrog's suggestion : what is the difference with yours?

Thanks for your help.

seb

[santille]

The bug seems to appear only with sheet number 2 ;-)

[JOHN H. DAVIS]

This line was part of your original code;

Please Login or Register  to view this content.

It clears the data on sheet 2? I only added the input values. Not certain of what you want too happen, though.

[santille]

Hi,

Yes, sorry, forget my last thread.
All is OK for me now.
I mark as solved.

Thank for your precious help.

Have a great day.

seb

[frog0208]

Thank you very much

[JOHN H. DAVIS]

You're welcome seb. Glad to help out and thanks for the feedback.

[santille]

Sorry, but it's missing something for me to be ok.

I've deleted the line post #10 cause I don't want the data cleared.
On the contrary if I add another number in the sheet 2 for example I want the new rows are added to the first one.

Thanks

seb