Thread: Data Manipulation Examples

Attached is a WorkBook with a data sheet, I thought it would be interesting for members to add their examples of common forum questions to it without disturbing the Data Sheet.

Add a sheet for your example. Keep it simple.

This first example gets the value between two dates. Click the calendars for the dates you want to find the value of.

In order to keep file size under control, it might be a good idea to delete the sheets other than the Data sheet and then just add the sheet with the member's manipulation suggestion?

Here my take at a very simple Pivot Table.

Select company in the page area and see a breakdown of model and cost total by year.

This example will get the Unique Company names from the Data Sheet, then will count and get the total Cost for each item.


Edit:

Code:

dim FmlRg2 as range

appears to be missing from the code

Using formulas to: Filter Data, Getting unique items, Countif, Sumif