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
Bookmarks