Input part numbers and description into selected spreadsheet
Closed
antkerr
Posts
1
Registration date
Sunday 21 January 2018
Status
Member
Last seen
21 January 2018
-
21 Jan 2018 à 17:17
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 22 Jan 2018 à 21:08
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 22 Jan 2018 à 21:08
Related:
- The region of the spreadsheet where data has been input is displayed.
- How to input @ in laptop - Guide
- Input phone password ✓ - Phones, PDA & GPS Forum
- Input phone lock code - Phones, PDA & GPS Forum
- Input phone lock code sos - Phones, PDA & GPS Forum
- What is hosted app data ✓ - Google Chrome Forum
2 responses
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Moderator
Last seen
6 September 2024
262
22 Jan 2018 à 04:23
22 Jan 2018 à 04:23
Hello Antkerr,
Could you please upload a sample of what you have done so far with your workbook showing inputs and expected outputs and showing exactly how you have the data set out. This will make it easier for us to understand what you would like to do and to do some testing.
You can upload a sample to a free file sharing site such as GE.TT or Drop Box and then post the link to your file back here.
In the meantime, here is some homework for you. Have a look at the following link:-
https://www.exceltrick.com/how_to/insert-a-checkbox-in-excel/
This is a very good example of how to set up tick (check) boxes and is very easy to follow. This will save us some time in trying to resolve your query.
Cheerio,
vcoolio.
Could you please upload a sample of what you have done so far with your workbook showing inputs and expected outputs and showing exactly how you have the data set out. This will make it easier for us to understand what you would like to do and to do some testing.
You can upload a sample to a free file sharing site such as GE.TT or Drop Box and then post the link to your file back here.
In the meantime, here is some homework for you. Have a look at the following link:-
https://www.exceltrick.com/how_to/insert-a-checkbox-in-excel/
This is a very good example of how to set up tick (check) boxes and is very easy to follow. This will save us some time in trying to resolve your query.
Cheerio,
vcoolio.
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Moderator
Last seen
6 September 2024
262
22 Jan 2018 à 21:08
22 Jan 2018 à 21:08
Hello Antkerr,
There appears to be a few problems with the buttons on your main sheet. A "Subscript out of range" error appears when one clicks on the buttons. This generally means that the code cannot find the correct sheet which means that the codes have not been assigned to the correct buttons. So, that's your next homework assignment! Assign the correct code to the buttons.
How are the tick boxes coming along? We'll need to see how you have set them up before we can create a macro to do the transferring of data to the "Pick" sheet. When you have sorted out these two items, upload a new working sample and we'll then be able to put the finishing touches to your workbook.
BTW, when you allocate the link cells to the tick boxes, pick a column out of sight of your main input areas (such as Column Z). We only need the True/False values to work with. These are built in functions with the tick boxes and will appear in the link cells automatically. You will not have to add any "IF" statements as per the tutorial.
Cheerio,
vcoolio.
There appears to be a few problems with the buttons on your main sheet. A "Subscript out of range" error appears when one clicks on the buttons. This generally means that the code cannot find the correct sheet which means that the codes have not been assigned to the correct buttons. So, that's your next homework assignment! Assign the correct code to the buttons.
How are the tick boxes coming along? We'll need to see how you have set them up before we can create a macro to do the transferring of data to the "Pick" sheet. When you have sorted out these two items, upload a new working sample and we'll then be able to put the finishing touches to your workbook.
BTW, when you allocate the link cells to the tick boxes, pick a column out of sight of your main input areas (such as Column Z). We only need the True/False values to work with. These are built in functions with the tick boxes and will appear in the link cells automatically. You will not have to add any "IF" statements as per the tutorial.
Cheerio,
vcoolio.
22 Jan 2018 à 06:19
https://www.dropbox.com/s/d23xdq2d4ukodwv/WORKSHOP.xlsm?dl=0