-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
copy formula across table
-
A
Adding two columns with equations in every other column using VBA
Hey I hope someone can spare some time to help me with this. It's starting to hurt my brain. I'm a novice user. I'm part way through a macro to handle a data set and this has me stumped. I can't find a macro that works to add 2 columns in every other, and then to add (or copy) equations for...- afletcher79
- Thread
- add columns copy formula across table
- Replies: 0
- Forum: Excel Questions
-
S
Some assistance with indirect / Offset gratefully received!!
Hi all, Hoping someone can help here. I need to reference cell values on an other sheet and on researching it seems like "Indirect" was the most suitable function to use. I have managed to get this working as per below:- =INDIRECT("'Sheet2'!N"&ROW(N4)) I can copy this down all the rows i...- stevedhawes
- Thread
- copy formula across table indirect offset
- Replies: 3
- Forum: Excel Questions
-
K
copy table column x times
I thought this: =IF(COLUMN(C$4:C14)<($J$2+2),C$4:C14 ,"") would work, but it doesn't seem to. Let me explain what I am trying to do: $J$2 is the number of participants and is a number the user will enter. Table Column C is data for participant 1 with all the drop down lists and everything set...- ksleep10
- Thread
- copy column copy formula across table
- Replies: 4
- Forum: Excel Questions
