Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel Linking & Macros (https://www.askmehelpdesk.com/showthread.php?t=275228)

  • Oct 30, 2008, 04:27 AM
    cturner
    Excel Linking & Macros
    I need to create a summary sheet from input into different worksheets. Original sheet is the input sheet, summary will automatically pull from Original into summary from just certain cells. The problem is, the original worksheet changes, the person inputting uses the last sheet he created and renames it.

    I think if I name the cells I need to be on the summary sheet and but the formula to copy the cell range it will work. How far off am I. I also want to be able to have the summary automatically start a new row after each sheet finishes. So if I have 12 columns pulling from the original after the 12th column is complete start a new row.? :eek:

    I just want to know that I'm on the right track or do I need to start over in my thinking.

    Thanks
  • Oct 30, 2008, 07:41 AM
    JBeaucaire

    Your terms appear to contradict. A summary would pull info FROM other source documents, it wouldn't be used by them to provide data... typically. Also, you say a "new row" is started after the "12th column" is complete... that also doesn't make sense. Data sets are usually gathered in columns OR in rows.

    I don't know how far off you are since I think you're doing it backward.

    Twelve sheets with data in it from people who have input things?
    To get the data from one cell to appear in another sheet, you just need to use a reference that includes the full pathname to the other spreadsheet. Read this thread to get complete instructions on doing that:

    https://www.askmehelpdesk.com/spread...-246269.html#2

  • All times are GMT -7. The time now is 03:22 PM.