creating a final list of selected amount

Hello there,

Can you please provide a sample workbook of your data showing you orginal data and mimicing what you would like the end result to be. Based on what you've post maybe highlighting the information you would select from a worksheet in one color and then selecting the information that would be retrieved from the other workbooks in another color. Then creating a worksheet entitled summary which shows your desired results. Please do this with a small portion of your data manually and attach a sample workbook so I can see exactly what you are trying to do.

Thanks!

basically if you scroll through the pages and see whats been selected

i would like a chart or a page whatever with the items chosen then the total price

Right now it just looks like you are adding all the totals on the Summary worksheet?

yes i do , but i also want the list of items i selected with quantity and sub totals

Sorry I do not see an example of that in your example worksheet, can you please update it to mimic an instance where you do this?

Thanks!

thats why im asking , i dont know how to do that

Hello there,

Sorry, maybe I should have been more clear. I understand you are asking because you do not know how to do it programmatically. What I am asking you to do is create an example worksheet that shows what you would like done. So referring back to my previous post:

Based on what you've post maybe highlighting the information you would selected from a worksheet in one color and then selecting the information that would be retrieved from the other workbooks in another color. Then creating a worksheet entitled summary which shows your desired results.

This can be done manually so that I can see what you want done programmatically. I could try and guess what you mean by the selecting and adding to the summary worksheet but I have a feeling we'd then be going back and forth quite a bit.

For instance, here are some interpretations that can be made based on your first post:

1. you want to be able to select/double click on a cell in any of the first three worksheets, when you do this cell's row is added to the summary worksheet.

2. You want to select a cell in one worksheet and then find any cells in any of the other worksheet whose value is like the selected cell and add their rows values to the summary worksheet

3. You want to make the copy paste method simpler by just selecting a cell and it automatically adds it to the summary worksheet.

option 1 is what i need

when i put a number in the amount bit in the 1st 3 sheets ,i want the entire lines to show in the summary page, then at the bottom of the list the total cost

The columns are different on each worksheet, would you like just the amount to be transferred over?

Thanks!

yeah columns are different, but if possible just the 1st column and then the amount and then subtotal, would be easier i think

also is it possible once its done to make it an executable, so people without excell could use it as a tool for the game?

Try the attached worksheet.

Because the worksheet has Visual Basic coding I am unsure how to make this usable for a game.

Thanks!

it says macros have been disabled because security levels are hi , what can i do

Close the workbook. When opening the workbook enable macros.

ok done that, now when i 0 an amount for a selected ship it still shows on the summary

change the below line in the code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

To view the code press Alt+F11 on your keyboard.

im trying to work out the code, which line/s pastes the details into the summary sheet, should the summary sheet show reference to it?, im not changing any lines just trying to understand it, i did have some progamming abilility years ago, but this code is kinda new to me

also i do think i didnt give enough correct info, the whole sheet is to caluclate 1 ship and loadout at a time.i.e a player would select 1 ship, goto each weapon and equipment page, and select relevant loadout for that ship ONLY, and then the summary page would show that ship and the list of selected loadouts and total values

Hello there,

I'm sorry but this is what I was afraid of. I feel that we will continue to go back and forth if you cannot provide me with an example worksheet. I can continue to guess what you are trying to accomplish but this would not only be tedious but unproductive. That being said can you please attempt to create a sample worksheet. I know that you are unsure how to have it happen programmatically but possibly color a row in one color, to show that a user has selected that ship. Then from the other worksheets, color those rows the same color, finally on the summary worksheet add the colored rows to that. This way I can see what you are trying to accompllish.

Thanks!

sorry took some time but ive coloured the bits i need and in the summary thats how i need them displayed, each ship will be chosen individually, then equipment and weapon loadout

hello my friend are you here?

I'm sorry I am currently unable to spend as much time on this forum as I was previously.

How do you know what information goes to what ship?

thats not a problem as players know anyway what ships can use which equipment