08-15-2019 05:54 PM
08-15-2019 05:54 PM
I receive data about several locations within the company, and need to send that data on (after much manipulating) to each place individually. The easiest way to do this would be to pick the data from the large list, and put it into a new tab so that the trend graphs etc can be created from a single tab. and manually doing it would take too long with the amount of data there is.
I have made a dummy dataset to figure out how to do this before using the confidential data that i work with. My problem is I'm not sure where to start. I assume there would be some kind of
IF Name = "X", [command to make it paste into the column of the same name on another tab]
Statement, but I have no background in coding languages so I am lost.
In this image the locations are represented by the "name" column.
08-21-2019 10:31 AM
@astralomega If I am understanding your need correctly, you are basically wanting to sort this data by location (column K) and then have an individual report for each location to send off. Correct?
If so, I would personally recommend creating a using Excel's PivotTable feature and break out your data by location. Depending on how often you update this data table, you can refresh your PivotTable and everything will update. Additionally - you will be able to double-click on the individual location in your table which will open a separate tab with your data for that location - rather than manually transfer the data to a new tab for each location. Additionally, you can create PivotCharts for this data to help with your tending reporting.
If you are unfamiliar with PivotTable, here is a link with a quick tutorial.
Hope this helps.
08-21-2019 12:54 PM
@astralomega +1 on the PivotTable suggestion!
In addition, if you add the Name field to the report Filter section, you can use the Show Report Filter Pages option, which will create individual PivotTable worksheets for each name in the list. They'll still contain the underlying data, so you'll want to Copy > Paste Special > Values before distributing, but there's a ton of VBA code around to help you automate that.