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

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

Nad Wrote:
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
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555951

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" wrote:


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

Nad Wrote:
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
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555951

in which format you want to summarise the data.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555951

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
----
----
Regards
Nad
starguy" wrote:


in which format you want to summarise the data.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555951

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.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555951

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 |
+-------------------------------------------------------------------+

--
nad
------------------------------------------------------------------------
nad's Profile: http://www.excelforum.com/member.php...o&userid=36179
View this thread: http://www.excelforum.com/showthread...hreadid=555951

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

"nad" wrote:


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 |
+-------------------------------------------------------------------+

--
nad
------------------------------------------------------------------------
nad's Profile: http://www.excelforum.com/member.php...o&userid=36179
View this thread: http://www.excelforum.com/showthread...hreadid=555951

I am working for a solution, sorry for delayed response because I was
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 by
engineers.
Following are the fields in your workbook.
PROJECT ENGINEER, PROJECT NO., PROJECT TITLE, PLANT/UNIT/DEPT and so on
to SCHEDULE: PLANNED VS ACTUAL
Tell me the exact fields filled by you and engineers.

Nad Wrote:
hello starguy
Please........ solve my problem.
regards,
nad




--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=555951