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