Ask Experts Questions for FREE Help !
Ask
    cturner's Avatar
    cturner Posts: 1, Reputation: 1
    New Member
     
    #1

    Oct 30, 2008, 04:27 AM
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Oct 30, 2008, 07:41 AM

    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

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Run Macros In Excel [ 1 Answers ]

Hi, I have created a few macros in an Excel spreadsheet, but I had to click "RUN" Macro every time in order for the data to update. If possible, can you please show me if there is a way for me to update the data and it runs automatically. Thanks for any helps.

Linking Excel Spreadsheets [ 1 Answers ]

:confused: Hi There ANyone know how I can link excel spreadsheets to each other?:confused:

Excel: Linking from one worksheet to another [ 8 Answers ]

I'd like to link from a cell in one worksheet to a LINE in another. If that doesn't make sense, I've got a member list of people with address, phone, etc. For folk that have not renewed this year, I want to have a separate worksheet that documents my contact efforts... so to link from the...


View more questions Search