Putting Data in One Sheet

[Guest]

Hi,
IS THERE ANY METHOD OF PUTTING DATA FROM DIFFERENT SHEET INTO ONE SHEET
ECCEPT (CUT, COPY, PASTE).
Because I have to do make weekly report in one sheet (as I receive weekly
report from my 15 engineers in 15 different sheet. ).
Please Help me in saving my time.

Regards,
Nad

 

[starguy]

attach a sample data file so that format of your data could be seen the
it would be possible to make a pertinent suggestion.

 

[Guest]

Data Format is very simple like
Project# ActivityThisWeek PlannedAction Phase
MitigationPlan
AF-0511048 -(Text)- --(Text)--- -(Text)
--(Text)--

Infact every week i send blank sheet (with this format ) to the every enggs.
to fill this sheet.
Then i put all the data in one sheet (Using Copy-Paste) to make report for
all enggs.

Thanks & Regards,
Nad

 

[starguy]

in which format you want to summarise the data.

 

[Guest]

i just want to display data of my one engg. then next and then next.....
(At the top of the sheet there will be column heading and then data of the
enggs. one by one)like
Project # Activity Phase ProjectEngg.
AF-051144 ---- --- ABC
AF-0012 ---- ---- XYZ

 

[starguy]

if you use separate workbook for each engg. then copy data sheets from
each workbook in a single workbook and send me a sample file because
many other factors are to be considered while making a formula.

 

[nad]

Sir,
Please find attachment as per request.

I explain you again

I receive weekly report in seperate workbook, then i copy it into one
sheet(called SUMMARY) in a new workbook.

Thanks & Regards,
nadeem


+-------------------------------------------------------------------+
|Filename: WEEKLY REPORT ENDING 30TH MAY 2006.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5000 |
+-------------------------------------------------------------------+

 

[Guest]

hello starguy
Please........ solve my problem.
regards,
nad

 

[starguy]

I am working for a solution, sorry for delayed response because I wa
busy.
However don't worry you will be given a good solution.
Tell me that which of the fields are filled by you and which b
engineers.
Following are the fields in your workbook.
PROJECT ENGINEER, PROJECT NO., PROJECT TITLE, PLANT/UNIT/DEPT and so o
to SCHEDULE: PLANNED VS ACTUAL
Tell me the exact fields filled by you and engineers.