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

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.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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?

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

I don't see any problem with doing that, how would you want to trigger
the copy of the information?, as for a copy of the data it would just be
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 to
your post, if you do join please make sure you post in the thread link
shown below so that people who have been following this thread or
helping you may continue to do so.

Coje;183843 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?

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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=50807