Draw data from Master Tab to Template tabs

Hi all

Im just delving into the world of Macros and have a little issue.

I have raw data on a single tab and need to pull those matching an identifier in column A (A,J,C,D,E,F,G,H) into the corresponding tabs returning data in column B and imputing it into the relevant tabs

How do i do this?? I have tried a few basic macros but i am completely baffled.

I know excel is able .... but i am not.

Any help is greatly appreciated.

Hello BEXJT,

Help us to help you by uploading a sample of your workbook showing inputs and expected outputs. The gold coloured banner at the top of this page explains how to upload a sample.

Cheerio,
vcoolio.

Does the entry e.g. "A-2-01" (an identifier) contain any coordinates specifying the place of copying to the "A" sheet, or is it enough to copy it to the first empty place in "Cell Location" ?

Just into the first empty space for cell location - it just identifies a physical place.

The idea will be there are multiple places identified under "A" - so A-2-02, A-2-03 etc

For example:

Please Login or Register  to view this content.

Absolutely perfect!!

Thank you