Hi all,
I couldnt find any help on my small issue, so please help if you can.
I have an excel which on "A" sheet has data on horizontal so A1=Me,B1=You,C1=They and then on the "B" sheet i retrieve these values and concatenate with some text but on vertical, so A1=Me,A2,You,A3=They. So far so good but then when i have values in the "A" sheet on A2,B2,C2 and so on , on the second sheet I want to just copy past the formulas from above but still to keep the pase by incrementing all 3 values with 1 not every value with 1. Does it make sense?
Thanks.
I couldnt find any help on my small issue, so please help if you can.
I have an excel which on "A" sheet has data on horizontal so A1=Me,B1=You,C1=They and then on the "B" sheet i retrieve these values and concatenate with some text but on vertical, so A1=Me,A2,You,A3=They. So far so good but then when i have values in the "A" sheet on A2,B2,C2 and so on , on the second sheet I want to just copy past the formulas from above but still to keep the pase by incrementing all 3 values with 1 not every value with 1. Does it make sense?
Thanks.