Hi,

I have 2 sheets, in sheet 1 I have the following data

@15Kmdm
@30Kmdm
@250Kmdm
@500Kmdm
@1to5Hz
@6to10Hz
@11to20Hz
@21to40Hz

in sheet 2 I have the following data


UserType
Proteomics
Application
ListSource


What I need in sheet3 is

Column A Column B

@15Kmdm UserType
@30Kmdm UserType
@250Kmdm UserType
@500Kmdm UserType
@1to5Hz UserType
@6to10Hz UserType
@11to20Hz UserType
@21to40Hz UserType
@15Kmdm Proteomics
@30Kmdm Proteomics
@250Kmdm Proteomics
@500Kmdm Proteomics
@1to5Hz Proteomics
@6to10Hz Proteomics
@11to20Hz Proteomics
@21to40Hz Proteomics
................ ................
................ ................
................ ................


If I delete any data in sheet 1 or sheet 2 it should be updated in sheet3 accordingly.

Help me with formulas, NO MACRO please.

Thanks