<div>
I don't have that Excel version available but maybe if you can post a (redacted) example Excel file other experts could try and help you.
</div>


I don't have that Excel version available but maybe if you can post a (redacted) example Excel file other experts could try and help you.

<div>
I'm going to close this question....found a very simple solution after all. &nbsp;After setting up the sequential numbering with Subtotal...just turn off automatic calculations, remove the filter, then copy / paste values as one would normally perform. It's easier and faster than probably most other solutions.
</div>


I'm going to close this question....found a very simple solution after all.  After setting up the sequential numbering with Subtotal...just turn off automatic calculations, remove the filter, then copy / paste values as one would normally perform. It's easier and faster than probably most other solutions.

Sr. IT Engineer

Gerwin Jansen

<div>
<div class="content wysiwyg-content fr-view">
Experts: Need assistance with a filtered &nbsp;column of data, using a Subtotal formula to provide sequential numbering of the filtered data. It seems Office 365 provides challenges in Copying and Pasting the Subtotal formulas as Values within the sequential column. Even with just a 6-8 rows of data, filter to three or four rows and attempting to copy/paste the formula values back to a specific column. Several references have been tried but not successful, with either VBA, or formulas,...it seems to be specific to Excel 365. Has anyone ever accomplished this with this latest version. &nbsp;Formulas, or VBA, solutions are fine....
</div>
</div>



Experts: Need assistance with a filtered  column of data, using a Subtotal formula to provide sequential numbering of the filtered data. It seems Office 365 provides challenges in Copying and Pasting the Subtotal formulas as Values within the sequential column. Even with just a 6-8 rows of data, filter to three or four rows and attempting to copy/paste the formula values back to a specific column. Several references have been tried but not successful, with either VBA, or formulas,...it seems to be specific to Excel 365. Has anyone ever accomplished this with this latest version.  Formulas, or VBA, solutions are fine....

Copy Paste Values in a Filtered Column - Office Excel 365

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.