Using a selected criteria to copy cells into new sheet
Closed
Debs269
Posts
21
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
-
Apr 16, 2014 at 11:29 AM
Debs269 Posts 21 Registration date Monday October 15, 2012 Status Member Last seen August 18, 2016 - Apr 22, 2014 at 04:56 AM
Debs269 Posts 21 Registration date Monday October 15, 2012 Status Member Last seen August 18, 2016 - Apr 22, 2014 at 04:56 AM
Related:
- Using a selected criteria to copy cells into new sheet
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Mark sheet in excel - Guide
1 response
Ok Debs, I am going to tackle the second problem first.
When you say that you have slicers, and two sources, are you trying to upload data sliced from another query, and link the two tables based on the slice?
Is the data sliced and data uploaded the difference? You need to check for programatic duplicates, in which case duplicates will probably be discarded, as the slice is there to make the SMALLEST AMOUNT available to work with.
When you say that you have slicers, and two sources, are you trying to upload data sliced from another query, and link the two tables based on the slice?
Is the data sliced and data uploaded the difference? You need to check for programatic duplicates, in which case duplicates will probably be discarded, as the slice is there to make the SMALLEST AMOUNT available to work with.
Apr 22, 2014 at 04:56 AM
I have two worksheets with different data on, but the common search the regions, both worksheets have pivots tables, and the slicer is looking for the data based on the region.
I currently have two slicers which I can not link together is there a solution so I dont have to select the criteria twice on the page, as I need this to be as simple as possible for the users.
If you need to see the spreadsheet I can email to you.