I am fairly new to excel (or rather, use it infrequently) and I could sure use some advice.
I have a form that needs to pull information from another page (no worries there) but it needs to skip 6 lines for each frame reference. For example:
Sheet 1 D31
Sheet 1 D37
Sheet 1 D73
Sheet 1 D79
Is there a way to automate this so when I copy the last cell onto the next row it will automatically spot the sequence and assign it a value of
Sheet 1 D85
Hopefully this is an easy issue to resolve and someone will take pity on my non-excel brain.
Thanks!
William
Yes, I should think so, but ...
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
I believe I have uploaded a sample sheet (called EXAMPLE) that shows my point. I am new to this forum, so my fingers are crossed.
Please note that I am locked into the format of the existing spreadsheet, so the data has to stay as shown in this example.
I hope someone can help me with this!
Thanks in advance -
William
D3, copy down.
=INDEX(B:B,(ROWS(D$3:D3)-1)*6+2)
This is perfect. Thanks! Now if I can only figure out how to mark this thread as solved....
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks