LinkBack URL
About LinkBacks
Hiya,
Just wondering how I can use autofill in cells B1:P1 so they equal the data already entered into A2:A16. So in:
Cell B1=A2
Cell C1=A3
Cell D1=A4
and so on.
Thanks!
Hiya,
Just wondering how I can use autofill in cells B1:P1 so they equal the data already entered into A2:A16. So in:
Cell B1=A2
Cell C1=A3
Cell D1=A4
and so on.
Thanks!
Post that in B1 and drag across.
Please Login or Register to view this content.
Last edited by mewingkitty; 01-23-2009 at 07:31 PM. Reason: I R CAN NOT COUNT
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Thanks,
But I'd need a formula that would work on different rows and columns. For example, the one I'm making now needs to autofill in cells F4:AI:4 (sheet "catalogue") and display the data that is entered into cells C6:C35 (sheet "concepts"). Any ideas?
In F4, dragged across.Please Login or Register to view this content.
same code, different adaptation.
Here's what this is doing.Please Login or Register to view this content.
It's establishing concepts!$C$6:$C$35 as the area information will be INDEXed from. It is then taking the column number which the formula is placed in with COLUMN(), in this case, if it is placed in column F, then COLUMN() will return 6. in order to have this return the value in row 1 of C6:C35, we need to take 5 away from that, hence the -5. When you drag this across, the value returned by COLUMN() increases, thereby increasing which row is INDEXed.
Oh and the 1 at the end just means column 1 of the designated area C6:C35. It only has 1 row, but you need that anyways.
Hope that helps you configure it to whatever you need.
Last edited by mewingkitty; 01-23-2009 at 07:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks