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.

 

[Simon Lloyd]

I don't see any problem with doing that, how would you want to trigge
the copy of the information?, as for a copy of the data it would just b
on the same lines as
Code
-------------------

Sheets("Sheet1").Range("A1").EntireRow.Copy Destination:=
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0


-------------------
feel free to join our forum for free where you can attach a workbook t
your post, if you do join please make sure you post in the thread lin
shown below so that people who have been following this thread o
helping you may continue to do so

I have a workbook with 8 worksheets. I have a "main summary" page that
hav
manually input data. What I would like to do next is to "auto" fill i
dat
from "main summary" to other worksheets. For example I have a cell wit
th
text "Egypt" in J3, I would like all information of that row be fille
int
sheet 2 which has headings. I have the same "format" on each workshee
an
I would like to set up each worksheet to fill in text with the sam
text fro
sheet 1 to the sheet it needs to go to

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

2. All relevant data should be transferred to the Principal Drive
(Owne
of the Client Account) by indentifying the Principal driver ID on Shee
On
Colum K

3. All Relevant data should be transferred from Sheet one to Principa
Driver (Driver driving the job) by Indentifying the driver by hi
Driver I
in Colum
I am not sure if we can display an excel sheet here so that it can b
worke
on if there is some other idea that some one can help then plz let m
know...

I hope that there might be someone who could help write some code fo
al
this to work

Thank you in advanc

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com