=IF('Part 2'!C10="","","H,"&'Part 2'!C10&",allocation,"&TEXT('Part 2'!$F$9,"dd/mm/yy"))
=IF('Part 2'!C11="","","H,"&'Part 2'!C11&",allocation,"&TEXT('Part 2'!$F$9,"dd/mm/yy"))
=IF('Part 2'!C12="","","H,"&'Part 2'!C12&",allocation,"&TEXT('Part 2'!$F$9,"dd/mm/yy"))
Hi
i need to be able to copy the above, from A1 to BP1
but for the C to stick and the row number to go up 1
can any one help
thanks
post an excel example without confidential information.
please also add the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Cheers
attached
so the formula in A1 to go across to BP1
with just the row number in the formula increasing
thanks
Replace each instance of:
'Part 2'!C10
With:
INDEX('Part 2'!$C$10:$C$100,COLUMNS($A1:A1))
Adjust for the correct end of range where I use down to C100.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
thank you sir
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks