I'd like to have a checkbox on one sheet send information to another sheet in excel
So I want to have a database of materials I use often with other information like cost, relail and available lengths et cetera. Then check the box next to it and have it populate on another sheet ready to have quantity adjusted. It's for an estimator I'm going to start putting together but this step underpins the whole thing and I don't know how to go about it as I am an HVAC tech and not a professional programmer. I looked through a library of functions and nothing jumped out at me and most of them are quite foreign to me.
microsoft-excel
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
add a comment |
So I want to have a database of materials I use often with other information like cost, relail and available lengths et cetera. Then check the box next to it and have it populate on another sheet ready to have quantity adjusted. It's for an estimator I'm going to start putting together but this step underpins the whole thing and I don't know how to go about it as I am an HVAC tech and not a professional programmer. I looked through a library of functions and nothing jumped out at me and most of them are quite foreign to me.
microsoft-excel
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
Welcome to SuperUser! Your post does not have enough information for us to help you. An example of your data along with the expected outcome would assist us in assisting you. Also, it is usually more useful for you when you try something first and post that along with what it doesn't do that you need. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
Feb 20 at 0:31
Could you provide a sample about your problem?
– Lee
Feb 20 at 8:33
I've read the how to ask section but I really don't know how to ask properly. I'll try to boil it down as much as possible. I want to know if I can click on an item in a list and have the contents of the row populate in a different spot. I'll continue to persue this until I can ask a competent question. In the meantime if you have any suggestions it would be much appreciated.
– Joe Fala
Feb 20 at 13:49
add a comment |
So I want to have a database of materials I use often with other information like cost, relail and available lengths et cetera. Then check the box next to it and have it populate on another sheet ready to have quantity adjusted. It's for an estimator I'm going to start putting together but this step underpins the whole thing and I don't know how to go about it as I am an HVAC tech and not a professional programmer. I looked through a library of functions and nothing jumped out at me and most of them are quite foreign to me.
microsoft-excel
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
So I want to have a database of materials I use often with other information like cost, relail and available lengths et cetera. Then check the box next to it and have it populate on another sheet ready to have quantity adjusted. It's for an estimator I'm going to start putting together but this step underpins the whole thing and I don't know how to go about it as I am an HVAC tech and not a professional programmer. I looked through a library of functions and nothing jumped out at me and most of them are quite foreign to me.
microsoft-excel
microsoft-excel
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
asked Feb 19 at 23:52
Joe FalaJoe Fala
1011
1011
Welcome to SuperUser! Your post does not have enough information for us to help you. An example of your data along with the expected outcome would assist us in assisting you. Also, it is usually more useful for you when you try something first and post that along with what it doesn't do that you need. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
Feb 20 at 0:31
Could you provide a sample about your problem?
– Lee
Feb 20 at 8:33
I've read the how to ask section but I really don't know how to ask properly. I'll try to boil it down as much as possible. I want to know if I can click on an item in a list and have the contents of the row populate in a different spot. I'll continue to persue this until I can ask a competent question. In the meantime if you have any suggestions it would be much appreciated.
– Joe Fala
Feb 20 at 13:49
add a comment |
Welcome to SuperUser! Your post does not have enough information for us to help you. An example of your data along with the expected outcome would assist us in assisting you. Also, it is usually more useful for you when you try something first and post that along with what it doesn't do that you need. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
Feb 20 at 0:31
Could you provide a sample about your problem?
– Lee
Feb 20 at 8:33
I've read the how to ask section but I really don't know how to ask properly. I'll try to boil it down as much as possible. I want to know if I can click on an item in a list and have the contents of the row populate in a different spot. I'll continue to persue this until I can ask a competent question. In the meantime if you have any suggestions it would be much appreciated.
– Joe Fala
Feb 20 at 13:49
Welcome to SuperUser! Your post does not have enough information for us to help you. An example of your data along with the expected outcome would assist us in assisting you. Also, it is usually more useful for you when you try something first and post that along with what it doesn't do that you need. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
Feb 20 at 0:31
Welcome to SuperUser! Your post does not have enough information for us to help you. An example of your data along with the expected outcome would assist us in assisting you. Also, it is usually more useful for you when you try something first and post that along with what it doesn't do that you need. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
Feb 20 at 0:31
Could you provide a sample about your problem?
– Lee
Feb 20 at 8:33
Could you provide a sample about your problem?
– Lee
Feb 20 at 8:33
I've read the how to ask section but I really don't know how to ask properly. I'll try to boil it down as much as possible. I want to know if I can click on an item in a list and have the contents of the row populate in a different spot. I'll continue to persue this until I can ask a competent question. In the meantime if you have any suggestions it would be much appreciated.
– Joe Fala
Feb 20 at 13:49
I've read the how to ask section but I really don't know how to ask properly. I'll try to boil it down as much as possible. I want to know if I can click on an item in a list and have the contents of the row populate in a different spot. I'll continue to persue this until I can ask a competent question. In the meantime if you have any suggestions it would be much appreciated.
– Joe Fala
Feb 20 at 13:49
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1407647%2fid-like-to-have-a-checkbox-on-one-sheet-send-information-to-another-sheet-in-ex%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1407647%2fid-like-to-have-a-checkbox-on-one-sheet-send-information-to-another-sheet-in-ex%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Welcome to SuperUser! Your post does not have enough information for us to help you. An example of your data along with the expected outcome would assist us in assisting you. Also, it is usually more useful for you when you try something first and post that along with what it doesn't do that you need. Please review site guidelines on How to Ask and Minimal, Complete, and Verifiable example and then edit your post instead of adding information in a comment.
– Rey Juna
Feb 20 at 0:31
Could you provide a sample about your problem?
– Lee
Feb 20 at 8:33
I've read the how to ask section but I really don't know how to ask properly. I'll try to boil it down as much as possible. I want to know if I can click on an item in a list and have the contents of the row populate in a different spot. I'll continue to persue this until I can ask a competent question. In the meantime if you have any suggestions it would be much appreciated.
– Joe Fala
Feb 20 at 13:49