Having a brain freeze in excel...

[BJIII]

This question is about copy / pasting formulas across cells.


I have two sheets in the same workbook:

Feature Sheet
Submission Sheet

I want to copy a column from the Feature sheet and paste it into a row on the submisson sheet and have it update automatically on the submission sheet if I change the feature sheet. I would rather just link the cells then use a macro to do it.

I made the formula:

=IF('Feature Sheet'!A19>0.5,'Feature Sheet'!A19," ")

and it works fine as if there is the issue is with copying this formula across the rows on the Submission sheet without having the modify the formula for each cell.

Example I would need to do the following:

Cell B10: =IF('Feature Sheet'!A19>0.5,'Feature Sheet'!A19," ")
Cell C10: =IF('Feature Sheet'!A20>0.5,'Feature Sheet'!A20," ")
Cell D10: =IF('Feature Sheet'!A21>0.5,'Feature Sheet'!A21," ")
Cell E10: =IF('Feature Sheet'!A22>0.5,'Feature Sheet'!A22," ")

I don't want to have to manually type the updated cell number as I could have a few hundred cells to edit in some cases.

Any help is much appreciated and please let me know if you need an other information!

Thanks,
BJW

 

[BJIII]

No problem thanks for trying Glory!

gsistek:
Thanks your formula works!!! I don't understand it or why it works but it does lol

I am assuming it's using A19 as it's reference starting point and moving over cells from there as I copy along right? I don't understand the -2 either but it selects the correct cell A19 verus the previous which selected A17.

Thanks,
BJW

 

[gsistek]

Offset moves the reference a specified number of rows then columns(in this case 0). Column(B10) finds the column reference (which for column B is 2) and uses that in the offset formula to move it to rows down (hence the -2). If you want a slightly shorter and more universal formula, use MrKowz's.
Glad to help.