Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default copy line with 2 condition....

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Cell From Subtotal Line To Detail Line Tickfarmer Excel Discussion (Misc queries) 2 November 5th 09 02:40 PM
How to change line chart color based on condition like + and -. egii Charts and Charting in Excel 1 May 8th 09 09:06 AM
how to delete an excel line based on a condition The cricket Excel Worksheet Functions 2 October 7th 08 12:04 PM
insert a line on condition jinvictor Excel Discussion (Misc queries) 1 June 4th 06 12:04 PM
Number format as condition for not deleting a line mjwillyone[_8_] Excel Programming 6 December 30th 03 10:25 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"