teejaydubya
New Member
- Joined
- Aug 1, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Afternoon all,
Apologies for what is probably a very simple question, but I've been unable to find the answer anywhere - though perhaps I'm simply asking it incorrectly!
Regardless, my question is as follows:
I am trying to create a quick means of copying specific data from cells to elsewhere on the same sheet - I thought this would be possible just by typing a few examples then using the drag tool to extrapolate what I'm looking to do (increase by 14 each time), but it isn't working cause I'm using a formula, I think...
In short, I'm looking to copy data as follows:
=D32
=D46
=D60
... etc. However, Excel isn't picking up the pattern of increasing 14 cells each time.
Again, I apologise for my ignorance. I'm very new to Excel and trying to learn.
Thank you in advance for the assistance!
Tom
Apologies for what is probably a very simple question, but I've been unable to find the answer anywhere - though perhaps I'm simply asking it incorrectly!
Regardless, my question is as follows:
I am trying to create a quick means of copying specific data from cells to elsewhere on the same sheet - I thought this would be possible just by typing a few examples then using the drag tool to extrapolate what I'm looking to do (increase by 14 each time), but it isn't working cause I'm using a formula, I think...
In short, I'm looking to copy data as follows:
=D32
=D46
=D60
... etc. However, Excel isn't picking up the pattern of increasing 14 cells each time.
Again, I apologise for my ignorance. I'm very new to Excel and trying to learn.
Thank you in advance for the assistance!
Tom