How do I pull data from one sheet and place it in another?

[Fred]

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.

 

[Jacob Skaria]

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

 

[Fred]

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]

You can copy the formula to the rows down..

Am I missing something here?

If this post helps click Yes

 

[Fred]

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]

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]

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

 

[Fred]

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.