Filtering Data and copying the rows back to the Summary Page

**DBarker1** · 02-04-2014, 08:01 AM

Hi All,

My first post here so please excuse any ignorance.

I have a spreadsheet of raw data that has been downloaded in Excel. In Column N there are different site numbers.

I want to use a new Sheet for each site. Using a formulae I want to filter the data for each site and then copy the entire row to the relevant site`s page.

So I should end up with a sheet for each page and allthe data sorted correctly?

Can anyone help?

**sbabu16** · 02-04-2014, 08:33 AM

Hi, Try this code.

Please Login or Register  to view this content.

**DBarker1** · 02-04-2014, 08:35 AM

Hi,
Sorry but how do I enter that code? Normally i enter formulae into the cells. Sorry my knowledge on Excel isnt very good.

**sbabu16** · 02-04-2014, 08:43 AM

1.Copy the sample code that you want to use
2.Open the workbook in which you want to add the code
3.Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
4.Choose Insert | Module
5.Where the cursor is flashing, choose Edit | Paste
save and close,
back on excel file
6.On the Excel Ribbon, click the View tab
7.At the far right, click Macros
8.Select a macro in the list, and click the Run button