[Solved] Filtered data results copied to new sheet?

Discuss the spreadsheet application
Locked
Hayukan
Posts: 2
Joined: Sun Apr 20, 2014 5:03 pm

[Solved] Filtered data results copied to new sheet?

Post by Hayukan »

Hi, I am working on a list where Columns a, b, c, d are used to filter all data below jointly. I created the filter using auto filter. The data array is A2:D687. After the user fine tunes their search using the drop down lists, A2:D5 need to be carried over to another sheet. I can seem to get the results carried over due to the variance in row numbers. :crazy: What would be a way without a macro to do this? :?:
Last edited by MrProgrammer on Thu Aug 13, 2020 6:42 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.0.1 on Windows 8
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Filtered data results copied to new sheet?

Post by acknak »

Greetings and welcome to the community forum!

Did you try to copy/paste the filtered rows to the other sheet? That works for me.

If it's not working, maybe you can describe what steps you're following and what happens that's different than what you need or expect.
AOO4/LO5 • Linux • Fedora 23
Hayukan
Posts: 2
Joined: Sun Apr 20, 2014 5:03 pm

Re: Filtered data results copied to new sheet?

Post by Hayukan »

Thank you. I'm glad I found this forum finally. The end user (friends and acquaintances) shouldn't have to copy and paste data into another field. It should automatically flow based on their selection. I understand I could copy and paste but I want it to do it on the fly. If I need to show example of the problem I would be willing to show you via e-mail.
OpenOffice 4.0.1 on Windows 8
User avatar
MrProgrammer
Moderator
Posts: 5297
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Filtered data results copied to new sheet?

Post by MrProgrammer »

Hayukan wrote:It should automatically flow based on their selection.
Read [Tutorial] Sorting and Filtering data with formulas. So that the other sheet can tell what you've filtered on the sheet with autofilter, you'll have to add a column to the filter containing the SUBTOTAL function. If the filtered range (including headings) is A1:D687, expand the range (Data → Define Range) to include column E. Put =SUBTOTAL(3;A2:A2) in cell E2 and Fill the formula to E687. You can hide column E if you want. Use the values in column E in the formulas on the other sheet as your automatically-filter-with-formulas criteria.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.6, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Locked