Hi
Ive got the formula of
=INDEX($BA$1:$CT$1,ROWS($A$6:A28))&" "&INDEX($BA$2:$CT$2,ROWS($A$6:A28))
which I believe takes the data from cells BA1-CT1 and also from BA2 to CT2 and works it way down the rows on a page. What Im trying to do is get the data starting from BA3 and copy all the way down the sheet as It is with other formula. The only thing is it will always be row 3 and just the one row.
Any Ideas?
Thanks
Try the following: =INDEX(BA$3:CT$3,ROWS(A$6:A6))
If that doesn't work then I suggest uploading a small nonproprietary sample of your spreadsheet to show us some data you might want to copy and the results you would expect based on that data.
As you haven't been here for a while the paperclip icon no longer works so you will need to click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Dear Tweacle, It is not clear what you are trying to do. Could you condense your problem to a few rows & columns in an example workbook, and attach it?
Spot on. Big Thanks
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks