+ Reply to Thread
Results 1 to 9 of 9

Putting Data in One Sheet

  1. #1
    Nad
    Guest

    Putting Data in One Sheet

    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



  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

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

    Quote Originally Posted by Nad
    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

  3. #3
    Nad
    Guest

    Re: Putting Data in One Sheet

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


  4. #4
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    in which format you want to summarise the data.

  5. #5
    Nad
    Guest

    Re: Putting Data in One Sheet

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


  6. #6
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    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.

  7. #7
    Registered User
    Join Date
    07-08-2006
    Posts
    1

    Putting data in one sheet

    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
    Attached Files Attached Files

  8. #8
    Nad
    Guest

    Re: Putting Data in One Sheet

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


  9. #9
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    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.
    Tell me also that do you send the whole workbook to all engineers or a single workseet to individual engineers of their name?

    Quote Originally Posted by Nad
    hello starguy
    Please........ solve my problem.
    regards,
    nad
    Last edited by starguy; 07-12-2006 at 08:59 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1