copy line with 2 condition....

S

sal21

http://www.gssitaly.com/IMPORT.ZIP

In this wbook are present 2 sheets SOURCE and TARGET, and a button
named IMPORT.

Into column of SOURCE column C and E are present variuos value(Are
similar an index, for me).

My problem is:

If i press on the button IMPORT show msgbox with 2 other buton "FROM
CODE" or "FROM AGENCY".

OPTION FOR CODE
==============

If i click on "FROM CODE" active a userform named "SELECT FROM CODE".
Show into this userform "SELECT FROM CODE" the list of value (without
duplicate) into column E of sheet SOURCE.
If i click, for example, on code "01" into a list of userform "SELECT
FROM CODE", import all record from SOURCE indetify with code "01" and
insert into sheet TARGET.


OPTION FOR AGENCY
==============
If i click on "FROM AGENCY" active a userform named "SELECT FROM
AGENCY".
Show into this userform "SELECT FROM AGENCY" the list of value (without
duplicate) into column C of sheet SOURCE.

Note: in this case show into userform only the first 4 cahracter on
lleft from column C; for example "4500", "4501"... ecc..

If i click, for example, on code "4501" into a list of userform "SELECT
FROM AGENCY", import all record from SOURCE indetify with code "4501"
and insert into sheet TARGET.
....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy line based a click into userform... 0
copy line nased 2 button on userform... 0
Hidden sheet bleeds through 3
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria 0
Transfer data from user form to register spreadsheet 0
use ComboBox value to select range and then use selected range tocreate a chart 3
ListBox with 2 Columns 3
Autoload UserForm TextBoxes 4

Top