VSTACK/HSTACK/IF

[gvoisard]

Sheet1:

Sheet: 123:

Basically I need a formula that takes all the lines that have 123 in column "I" on sheet1 to fill on sheet "123" starting in B12. I need columns K:Q to transfer over as well as the Debit/Credit columns. However, instead of the description column from Sheet1, I would like the Condensed Description to transfer to the description column on sheet "123". I do not want the rest of the columns to transfer from Sheet1.



Let me know if you have any questions, I appreciate the help!

 

[Fluff]

Glad you sorted it & thanks for letting us know.

 

[gvoisard]

The formula won't effect what is on the Checks sheet, so not quite sure what you are saying.

Do you think that it is possible to add a line to offset to the end of '27601 (with Formulas)' that changes what line it is on based on how many transactions there are? In other words, if that last line is in row 13, then I want the offsetting line in row 14, if the last line is 20, I want the offsetting line to move to row 21...etc. Thanks.

 

[Fluff]

I'm afraid I have no idea what you mean.

 

[gvoisard]

I'm afraid I have no idea what you mean.

Like so let's say once all the transactions are in. The debit column= $100, well I need the debits and credits to equal, so I want to add another line (this will not be pulled from 'Checks') the would be a credit in for $100. Columns B:H would always be the same, but the debit/credit would adjust based on the above transactions. This would make the net amount zero, which is what I want. Basically, I want the function to adjust what line it is on based on how many transactions there are and for the credit/debit to adjust automatically as well. It is pretty simple to do manually, but if there is a way for it to happen automatically that would be great. I tried putting the transaction that I want in row 13, but if there is more than one transaction that pulls from 'Checks' then I get a spill error.

 

[Fluff]

As this is a significantly different question it needs a new thread. Thanks