Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
Okay, so it's not as simple as the subject but here it goes. I have multiple
worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
In your example you have not mentioned in which sheet to populte...Assume you
want to populate in Sheet2 Col C; Try this in Cell A1 of Sheet2 =IF(Sheet1!A1="","",Sheet1!A1) If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
The issue is not so much how to post the info but how to skip to the next
populated cell when it is not populated and when it is populated for the information to be posted and then move down one row to look for the next populated cell and continue. "Jacob Skaria" wrote: In your example you have not mentioned in which sheet to populte...Assume you want to populate in Sheet2 Col C; Try this in Cell A1 of Sheet2 =IF(Sheet1!A1="","",Sheet1!A1) If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
You can copy the formula to the rows down..
Am I missing something here? If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: The issue is not so much how to post the info but how to skip to the next populated cell when it is not populated and when it is populated for the information to be posted and then move down one row to look for the next populated cell and continue. "Jacob Skaria" wrote: In your example you have not mentioned in which sheet to populte...Assume you want to populate in Sheet2 Col C; Try this in Cell A1 of Sheet2 =IF(Sheet1!A1="","",Sheet1!A1) If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
Yeah, but It is complicated so I'm not suprised.
If you use your formula it works for one specific cell "Sheet1!$A$1" and it will post it in "Sheet2!C1". If you copy this formula down it will put "Sheet1!$A$1" in "Sheet2!C2". More specifically I am trying to put information in "Contract!A7". First I look at "Framing!$C$2" to see if it is populated, if it is then in "Contract!A7" I have the equation =IF(Framing!$C$2="","",Framing!$C$2). If Framing!$C$2 is not populated then I want to skip to "Insulation!$C$2" to see if it is populated, if it is to input "Insulation!$C$2" into "Contract!A7". However if "Framing!$C$2" was populated then I need to input "Framing!$C$2" into "Contract!A7" and then I need "Contract!A8" to check "Framing!$C$16", if it is not populated then skip to "Insulation!$C$2", if it is then again input the data and then "Contract!A9" needs to check "Framing!$C$30". On Each sheet "Framing" and "Inulation" there will be three possible cells to check. Once any of them is not populated I need to skip to the next sheet. As soon as one is found that is populated It inputs info into the current "Contract" cell and then moves down a row so that it can search for the next populated cell. It is a bidding system I am building for a home improvement business. Each sheet allows me to give three different numbers for possible bids like frame basement, frame new bathroom, frame addition. Then it will put each one of those as a line-item on the contract page. They are filled out in order so as soon as one of them is blank I also know that none of the ones below it are populated and I can skip to the next sheet, in this case insulation, but when I'm done there will be about 10 different job type sheets. "Jacob Skaria" wrote: You can copy the formula to the rows down.. Am I missing something here? If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: The issue is not so much how to post the info but how to skip to the next populated cell when it is not populated and when it is populated for the information to be posted and then move down one row to look for the next populated cell and continue. "Jacob Skaria" wrote: In your example you have not mentioned in which sheet to populte...Assume you want to populate in Sheet2 Col C; Try this in Cell A1 of Sheet2 =IF(Sheet1!A1="","",Sheet1!A1) If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
Try the below and I think this should solve the problem. Suppose you have 10
sheets from Sheet1 to Sheet10.. You can have the formula =Sum(Sheet1:Sheet10!C2) which will bring you the sum of all the values of C2 from all 10 sheets. If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Yeah, but It is complicated so I'm not suprised. If you use your formula it works for one specific cell "Sheet1!$A$1" and it will post it in "Sheet2!C1". If you copy this formula down it will put "Sheet1!$A$1" in "Sheet2!C2". More specifically I am trying to put information in "Contract!A7". First I look at "Framing!$C$2" to see if it is populated, if it is then in "Contract!A7" I have the equation =IF(Framing!$C$2="","",Framing!$C$2). If Framing!$C$2 is not populated then I want to skip to "Insulation!$C$2" to see if it is populated, if it is to input "Insulation!$C$2" into "Contract!A7". However if "Framing!$C$2" was populated then I need to input "Framing!$C$2" into "Contract!A7" and then I need "Contract!A8" to check "Framing!$C$16", if it is not populated then skip to "Insulation!$C$2", if it is then again input the data and then "Contract!A9" needs to check "Framing!$C$30". On Each sheet "Framing" and "Inulation" there will be three possible cells to check. Once any of them is not populated I need to skip to the next sheet. As soon as one is found that is populated It inputs info into the current "Contract" cell and then moves down a row so that it can search for the next populated cell. It is a bidding system I am building for a home improvement business. Each sheet allows me to give three different numbers for possible bids like frame basement, frame new bathroom, frame addition. Then it will put each one of those as a line-item on the contract page. They are filled out in order so as soon as one of them is blank I also know that none of the ones below it are populated and I can skip to the next sheet, in this case insulation, but when I'm done there will be about 10 different job type sheets. "Jacob Skaria" wrote: You can copy the formula to the rows down.. Am I missing something here? If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: The issue is not so much how to post the info but how to skip to the next populated cell when it is not populated and when it is populated for the information to be posted and then move down one row to look for the next populated cell and continue. "Jacob Skaria" wrote: In your example you have not mentioned in which sheet to populte...Assume you want to populate in Sheet2 Col C; Try this in Cell A1 of Sheet2 =IF(Sheet1!A1="","",Sheet1!A1) If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
You can have a validation in place to notify if multiple values are
pasted...REplace Sheet2 with the 1st Sheet and Sheet3 with the 10th sheet for your requirement =IF(COUNT(Sheet2:Sheet3!C2)=1,SUM(Sheet2:Sheet3!C2 ),"Multiples") I am not sure whether this helps; if not please let me know.. If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Yeah, but It is complicated so I'm not suprised. If you use your formula it works for one specific cell "Sheet1!$A$1" and it will post it in "Sheet2!C1". If you copy this formula down it will put "Sheet1!$A$1" in "Sheet2!C2". More specifically I am trying to put information in "Contract!A7". First I look at "Framing!$C$2" to see if it is populated, if it is then in "Contract!A7" I have the equation =IF(Framing!$C$2="","",Framing!$C$2). If Framing!$C$2 is not populated then I want to skip to "Insulation!$C$2" to see if it is populated, if it is to input "Insulation!$C$2" into "Contract!A7". However if "Framing!$C$2" was populated then I need to input "Framing!$C$2" into "Contract!A7" and then I need "Contract!A8" to check "Framing!$C$16", if it is not populated then skip to "Insulation!$C$2", if it is then again input the data and then "Contract!A9" needs to check "Framing!$C$30". On Each sheet "Framing" and "Inulation" there will be three possible cells to check. Once any of them is not populated I need to skip to the next sheet. As soon as one is found that is populated It inputs info into the current "Contract" cell and then moves down a row so that it can search for the next populated cell. It is a bidding system I am building for a home improvement business. Each sheet allows me to give three different numbers for possible bids like frame basement, frame new bathroom, frame addition. Then it will put each one of those as a line-item on the contract page. They are filled out in order so as soon as one of them is blank I also know that none of the ones below it are populated and I can skip to the next sheet, in this case insulation, but when I'm done there will be about 10 different job type sheets. "Jacob Skaria" wrote: You can copy the formula to the rows down.. Am I missing something here? If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: The issue is not so much how to post the info but how to skip to the next populated cell when it is not populated and when it is populated for the information to be posted and then move down one row to look for the next populated cell and continue. "Jacob Skaria" wrote: In your example you have not mentioned in which sheet to populte...Assume you want to populate in Sheet2 Col C; Try this in Cell A1 of Sheet2 =IF(Sheet1!A1="","",Sheet1!A1) If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull data from one sheet and place it in another?
It does help a little so thank you. I think I came up with a long way of
doing it. I am creating another sheet. On each row it will us "IF(Sheet1!$C$2="","",Sheet1!$C$2). The new sheet will have one row for each cell I need to check. Then I am going to create a macro so when I push the button it will sort alphabetically so that it will get rid of all of the blank rows and then pull information from the new list into the Contract Sheet. Thanks for you help and ideas. "Jacob Skaria" wrote: You can have a validation in place to notify if multiple values are pasted...REplace Sheet2 with the 1st Sheet and Sheet3 with the 10th sheet for your requirement =IF(COUNT(Sheet2:Sheet3!C2)=1,SUM(Sheet2:Sheet3!C2 ),"Multiples") I am not sure whether this helps; if not please let me know.. If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Yeah, but It is complicated so I'm not suprised. If you use your formula it works for one specific cell "Sheet1!$A$1" and it will post it in "Sheet2!C1". If you copy this formula down it will put "Sheet1!$A$1" in "Sheet2!C2". More specifically I am trying to put information in "Contract!A7". First I look at "Framing!$C$2" to see if it is populated, if it is then in "Contract!A7" I have the equation =IF(Framing!$C$2="","",Framing!$C$2). If Framing!$C$2 is not populated then I want to skip to "Insulation!$C$2" to see if it is populated, if it is to input "Insulation!$C$2" into "Contract!A7". However if "Framing!$C$2" was populated then I need to input "Framing!$C$2" into "Contract!A7" and then I need "Contract!A8" to check "Framing!$C$16", if it is not populated then skip to "Insulation!$C$2", if it is then again input the data and then "Contract!A9" needs to check "Framing!$C$30". On Each sheet "Framing" and "Inulation" there will be three possible cells to check. Once any of them is not populated I need to skip to the next sheet. As soon as one is found that is populated It inputs info into the current "Contract" cell and then moves down a row so that it can search for the next populated cell. It is a bidding system I am building for a home improvement business. Each sheet allows me to give three different numbers for possible bids like frame basement, frame new bathroom, frame addition. Then it will put each one of those as a line-item on the contract page. They are filled out in order so as soon as one of them is blank I also know that none of the ones below it are populated and I can skip to the next sheet, in this case insulation, but when I'm done there will be about 10 different job type sheets. "Jacob Skaria" wrote: You can copy the formula to the rows down.. Am I missing something here? If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: The issue is not so much how to post the info but how to skip to the next populated cell when it is not populated and when it is populated for the information to be posted and then move down one row to look for the next populated cell and continue. "Jacob Skaria" wrote: In your example you have not mentioned in which sheet to populte...Assume you want to populate in Sheet2 Col C; Try this in Cell A1 of Sheet2 =IF(Sheet1!A1="","",Sheet1!A1) If this post helps click Yes --------------- Jacob Skaria "Fred" wrote: Okay, so it's not as simple as the subject but here it goes. I have multiple worksheets that each contain three sets of bidding data. So on each worksheet I could have up to three sets of a data filled in. I want to say on one worksheet that if this cell on another sheet is filled in then put it here, if not move to the next available set to see if it is filled in. Do this until it finds one filled in and then it moves to the next row and looks for the next populated cell of the ones I want to check. Here is a simple version: A B 1 5 10 2 3 4 12 4 5 6 5 6 In cell C1 look if A1 is populated, if it is then put the info in C1. Then in C2 look if A2 is populated, if it is then put it in C2, if it is not then go to A3 to see if it is populated, if it is then put it in C2. Etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Data from one sheet to another | Excel Worksheet Functions | |||
Grabbing data from 1 sheet to place in another | New Users to Excel | |||
How do I use a formula on wk sheet 2 to pull data from wk sheet 1 | Excel Discussion (Misc queries) | |||
VLookup / pull data from 1 sheet to another | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |