Opening a MasterData File Read Only and Lifting Data from that into a Table into a Current Workbook using VBA Code

[Ibbo1978]

Hi All,

• I have a Master Data Table, this has a huge amount of info across 500 products
• I also have a Daily workbook that may use 50 Products and only a number of the columns of data
• I want to ensure that the data in my Daily workbook is exactly the same as Master Data Table.
• So when I open Daily Workbook I want to open the Master Data table read only as many other files may do the same thing concurrently.
• I then want to lift specific data from the Master Data table that satisfy the column headers within my daily workbook.

Master Data

PRODUCT CODE	Customer Code	Work Centre	Packs / Hour	Packs / Case	Cases / Hour	Eff'cy %	Plan Rate
P CODE	CUST	W/C	PPH	PPC	RATE	EFF	PRATE
CQ6762	Ct	1	1,650	12	138	1	1
CT6762	Ct	1	2,475	12	206	1	2
IC10008	Ic	2	2,200	10	220	1	2
IC10009	Ic	2	2,200	10	220	1	2
KD00051	Al	2	2,200	14	157	1	2
KG10042	Al	1	1,500	12	125	1	1
KD10042	Al	1	1,500	12	125	1	1
KD10045	Al	1	1,500	12	125	1	1
KD10065	Al	1	1,500	12	125	1	1
KD10066	Al	1	1,500	12	125	1	1
KD90014	Al	1	1,800	6	300	1	3

<colgroup><col width="140" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;"> <col width="108" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;"> <col width="120" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="71" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="2"> <col width="75" style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;"> <col width="75" style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;"> <col width="89" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <tbody> </tbody>

Daily Workbook

PRODUCT CODE	Packs / Hour	Packs / Case
P CODE	PPH	PPC
KD10042
KD10045
KD10065
KD10066

<colgroup><col width="140" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;"> <col width="71" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="2"> <tbody> </tbody>

Hope this explains my requirement, I just need to get started, I think if I had code to open the sheet read only and could fill in the first code efficiently, I presume it would be some sort of loop to continue the process.

Hope you can help Excel Family,

Ibbo