Fetching data from one sheet to another with some logic!?

Hi

I have added code to your [ADD] button.
This will append data for the selected drop-down item, to the next available row in your Product Name column.

I have used some 'helper-cells' in range [F1:H2] on the [QRY] sheet.
(You can hide these columns if required etc etc etc)

This uses INDEX/MATCH formulas to 'retrieve' data from the [DTL] sheet.
NOTE: I don't know where you get the CARTON NO.'S for column [C]

zeddy
Excel Soft Skin Analyst

Hi zeddy, Carton no. is fetched from sheet DTL's No. Of SB column. The first item in DTL sheet is "HYDRANET CREAM", so it's no.of cartons will be 1/113 to 5/113 in first row of the table and 6/113 to 6/113 in the second row, where 113 is the total of the column No.of SB.
Check the desired table in QRY sheet that I provided.

Hi 0Cool,

NOTE: I deleted your 'Active X' Control and replaced it with a 'Forms' Control. 'Active X' controls are prettier, but can cause Workbook Corruption problems.

Try the following code which is in the attached copy of your sample file (Ordinary Code Module ModExtractBatchAndCartonData) for a VBA solution to your problem. The items in Red should be modified if Sheet Names or the 'DTL' sheet format changes.

Please Login or Register  to view this content.

Lewis

Thanks LJMetzger. I need some time to digest it all