HELP!!!!!

[Coje]

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?

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
I am not sure if we can display an excel sheet here so that it can be worked
on if there is some other idea that some one can help then plz let me
know....

I hope that there might be someone who could help write some code for all
this to work.

Thank you in advance

 

[Luke M]

Are you wanting formulas, or macros? Part of what you described could be
accomplished easily with formulas, while other parts (transferring data that
you then want to change) would best be done with VBA.

1. This would be done easiest by Going to Tools-Macro and simply recording
yourself copying everything from Summary sheet to Main sheet. Then when you
want to do this again in future, simply call macro either through Alt+F8, or
create a shortcut key/button.

For 2 and 3, I'd recommend reading XL's help file on LOOKUP and VLOOKUP, as
they are designed for the exact type of thing I believe you are describing.

If you still need more detailed help, you could post on workbook on a file
sharing site, and then post the link here.