auto fill certain data from sheet1 to sheet 2
 

I have a workbook with 8 worksheets. I have a "main summary" page that I have
manually input data. What I would like to do next is to "auto"
fill in data from "main summary" to other worksheets. For example I have a
cell with the text "Egypt" in J3, I would like all information of that row
be filled into sheet 2 which has headings. I have the same "format" on each
worksheet and I would like to set up each worksheet to fill in text with the
same text from sheet 1 to the sheet it needs to go to?

auto fill certain data from sheet1 to sheet 2
 

Hi,

You will probably have to write a macro to do this. But regardless, we will
need to know how you determine which rows of data from the master go to which
sheets.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Coje" wrote:

I have a workbook with 8 worksheets. I have a "main summary" page that I have
manually input data. What I would like to do next is to "auto"
fill in data from "main summary" to other worksheets. For example I have a
cell with the text "Egypt" in J3, I would like all information of that row
be filled into sheet 2 which has headings. I have the same "format" on each
worksheet and I would like to set up each worksheet to fill in text with the
same text from sheet 1 to the sheet it needs to go to?

auto fill certain data from sheet1 to sheet 2
 

Hi Shane,

Thnak you taking time to reply, would it be of any help if I sent you the
EXCEL sheet and maybe you could see what I mean.

1. Sheet one which is is the Main sheet where all jobs are taken and
altered if need be. None of the jobs should be altered in any of the other
Spread Sheets to avoid any loss of data or wrong data occurring because
changes are not complete on all relevant sheets.

2. All relevant data should be transferred to the Principal Driver (Owner
of the Client Account) by indentifying the Principal driver ID on Sheet One
Colum K.

3. All Relevant data should be transferred from Sheet one to Principal
Driver (Driver driving the job) by Indentifying the driver by his Driver ID
in Colum O

My guess is that we might have to get somebody to write some code for all
this to work.

"Shane Devenshire" wrote:

Hi,

You will probably have to write a macro to do this. But regardless, we will
need to know how you determine which rows of data from the master go to which
sheets.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Coje" wrote:

I have a workbook with 8 worksheets. I have a "main summary" page that I have
manually input data. What I would like to do next is to "auto"
fill in data from "main summary" to other worksheets. For example I have a
cell with the text "Egypt" in J3, I would like all information of that row
be filled into sheet 2 which has headings. I have the same "format" on each
worksheet and I would like to set up each worksheet to fill in text with the
same text from sheet 1 to the sheet it needs to go to?