I am hoping to get some help on copy and paste! Seems like something simple and probably is but here goes....I need to repeat several data sets that have 6 rows of data down a single column, the data sets point to various other sheets but the constant is that I need each row within the data set to increase by 1 each time I paste the data set, however, it is increasing each row 6 due to the 6 individual lines of data...See example below..... (I will need to copy and paste the data sets around 60 times).
You only need to enter the 2 formulas once. Change the A2 and B2 values, and it'll repeat down as far as you want. The C3 formula for the titles is not bad, but the D3 formula is a bit of a mess. If you have the LET function (not every Excel 365 has that yet), it could be simplified.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.