Automatic copy filter data from one sheet to another?

[mjdormer]

Hi All,

Wondering if you can help, I will probably explain this really badly.

So I have a a sheet which is filtered at the top, at the bottom is a formula to calculate certain data.. I then copy that data into another excel sheet (summary) is there a way to make this easier? or automatic? currently I switch between the two sheets, adjust my filter, scroll to the bottom, copy the formula data, switch to the other sheet and paste into the correct cell.


Thanks so much for the help!

[Pete_UK]

It's a bit difficult to tell what you are doing from those pictures. It would help if you attached a sample Excel workbook instead.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

You might be able to use a SUMIFS formula on the second sheet.

Hope this helps.

Pete

[mjdormer]

Hello Pete,

Thanks so much for the quick reply. I have attached a spreadsheet with similar data on.

I have highlighted in Yellow, the key areas.

So on the AW19 up to 30-06-19 tab, this is the main data that is filtered by the 'vendor' section,

from here I look at the bottom formula to view the combined data, copy that information highlighted in yellow and then select the Summary tab and paste that data into the relevant vendor.

Is there a way to automatically copy the 'AW19 up to the 30-6-19' bottom formula into the Summary sheet? filtered by each vendor.

Thanks again for the help!

[Pete_UK]

I'll take a look later on, as I'm just about to go out now.

Pete

[Pete_UK]

You can put this formula in cell G4 of the Summary sheet:

=SUMIF('AW19 Up to 30-06-19'!$A:$A,$C4,'AW19 Up to 30-06-19'!G:G)

Copy it into H4:I4, then copy those formulae down to row 17. This accounts for all the data in the AW19... sheet, but if you had other data in there that relates to different months and wanted the Summary sheet to pick out a particular month, you would need to use SUMIFS, which has a slightly different syntax.

Anyway, this removes the need to use AutoFilter to fill the data.

Hope this helps.

Pete

[mjdormer]

Hi Pete,

Thats amazing, thanks so much! .. works perfectly.