Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Coding help request (I think?)
Ok... first I would like to say thank you to anybody who attempts an answer
for this... I really appreciate any ideas. What I would like to do is to have a workbook with a worksheet that pulls from specific cells on other worksheets. The kicker is that other worksheets are added as they are turned in so they are not in there at the beginning. I'm guessing this (if at all possible) would have to be done with code... any ideas? Once again, it's a very simple go to other spreadsheets (I could probably manipulate it if it looked at all) and pull a specific cell back to the first worksheet. Would be helpful if it also ordered them by the first cell it pulls back in. Again, thanks for any assistance. |
#2
|
|||
|
|||
Coding help request (I think?)
Hi,
I think a userform would be best suited. A Combobox or listbox filled with the workbook names A button to do the actions an update button that checks for more files See my stuff at: http://www.geocities.com/excelmarksway You can send me the info if you want me to write it up. - -mark "adodson" wrote: Ok... first I would like to say thank you to anybody who attempts an answer for this... I really appreciate any ideas. What I would like to do is to have a workbook with a worksheet that pulls from specific cells on other worksheets. The kicker is that other worksheets are added as they are turned in so they are not in there at the beginning. I'm guessing this (if at all possible) would have to be done with code... any ideas? Once again, it's a very simple go to other spreadsheets (I could probably manipulate it if it looked at all) and pull a specific cell back to the first worksheet. Would be helpful if it also ordered them by the first cell it pulls back in. Again, thanks for any assistance. |
#3
|
|||
|
|||
Coding help request (I think?)
I've reviewed your pages and have been unable to find what you have
referenced below. It may be items that are not collectively stated in one category so I'm missing it. Could you please point me in the right direction? However, looking at what I think you have suggested below, I think it is important to mention that the worksheet titles may not necessarily always be named the same thing. If there is a way to pull specific cells from all of the other worksheets in the workbook, or all the worksheets to right of the active worksheet, or something similar... and then order them by one of the cells pulled, I would be a happy duck. :) Even if they weren't ordered by the cells pulled, I think I could be a happy duck, but that is preferred. Thanks for your assistance! Please let me know of any suggestions. "exceluserforeman" wrote: Hi, I think a userform would be best suited. A Combobox or listbox filled with the workbook names A button to do the actions an update button that checks for more files See my stuff at: http://www.geocities.com/excelmarksway You can send me the info if you want me to write it up. - -mark |
#5
|
|||
|
|||
Coding help request (I think?)
One way. Assume you start with 3 sheets. Summary (or whatever your main
sheet with the caluclations is called), First and Last. In the Summary sheet you can enter the formula: =SUM(First:Last!$A$1) This will sum the values in Cell A1 in the sheets First and Last. Now if you add any other sheet to the workbook and place this sheet between First and Last that sheets cell A1 will also be included in the result. Hope this helps Rowan adodson wrote: Ok... first I would like to say thank you to anybody who attempts an answer for this... I really appreciate any ideas. What I would like to do is to have a workbook with a worksheet that pulls from specific cells on other worksheets. The kicker is that other worksheets are added as they are turned in so they are not in there at the beginning. I'm guessing this (if at all possible) would have to be done with code... any ideas? Once again, it's a very simple go to other spreadsheets (I could probably manipulate it if it looked at all) and pull a specific cell back to the first worksheet. Would be helpful if it also ordered them by the first cell it pulls back in. Again, thanks for any assistance. |
#6
|
|||
|
|||
Coding help request (I think?)
I am impressed! =SUM(First:Last!$A$1) I did not think of that. Four GOLD STARS to you! "Rowan Drummond" wrote: One way. Assume you start with 3 sheets. Summary (or whatever your main sheet with the caluclations is called), First and Last. In the Summary sheet you can enter the formula: =SUM(First:Last!$A$1) This will sum the values in Cell A1 in the sheets First and Last. Now if you add any other sheet to the workbook and place this sheet between First and Last that sheets cell A1 will also be included in the result. Hope this helps Rowan adodson wrote: Ok... first I would like to say thank you to anybody who attempts an answer for this... I really appreciate any ideas. What I would like to do is to have a workbook with a worksheet that pulls from specific cells on other worksheets. The kicker is that other worksheets are added as they are turned in so they are not in there at the beginning. I'm guessing this (if at all possible) would have to be done with code... any ideas? Once again, it's a very simple go to other spreadsheets (I could probably manipulate it if it looked at all) and pull a specific cell back to the first worksheet. Would be helpful if it also ordered them by the first cell it pulls back in. Again, thanks for any assistance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coding help request (I think?)
I think you're on to something, but it's not that I want to sum all of the
cells, only if a particular cell matches another. For example: =SUMIF(First:Last!D2,'Summary Raw Data'!A2,First:Last!D4) The response I receive from this is "VALUE" and I suspect it's because sumif doesn't work across separate worksheets? "Rowan Drummond" wrote: One way. Assume you start with 3 sheets. Summary (or whatever your main sheet with the caluclations is called), First and Last. In the Summary sheet you can enter the formula: =SUM(First:Last!$A$1) This will sum the values in Cell A1 in the sheets First and Last. Now if you add any other sheet to the workbook and place this sheet between First and Last that sheets cell A1 will also be included in the result. Hope this helps Rowan adodson wrote: Ok... first I would like to say thank you to anybody who attempts an answer for this... I really appreciate any ideas. What I would like to do is to have a workbook with a worksheet that pulls from specific cells on other worksheets. The kicker is that other worksheets are added as they are turned in so they are not in there at the beginning. I'm guessing this (if at all possible) would have to be done with code... any ideas? Once again, it's a very simple go to other spreadsheets (I could probably manipulate it if it looked at all) and pull a specific cell back to the first worksheet. Would be helpful if it also ordered them by the first cell it pulls back in. Again, thanks for any assistance. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coding help request (I think?)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Coding | Excel Discussion (Misc queries) | |||
Where do I find the Payment Request Wizard in Outlook? | Excel Discussion (Misc queries) | |||
Hidding Macro names and coding | Excel Discussion (Misc queries) | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
trendline - request power --> get linear | Excel Worksheet Functions |