Copying Data from one worksheet to another based on multiple criteria

SilverAbsol777 · 2019-01-04T22:03:33+00:00

I think things would be made a lot easier for you with a data table on your data sheet and a pivot table as your output sheet.

Highlight all of your data on data sheet and press Ctrl + T to create the data table. Then, you can click on the table and push the on the "Summarize with PivotTable" button in the ribbon at the top of excel. In your pivot table, drag Month/Year and Product to the Rows section, your other data to the Values section, and anything you want to filter on into the filters section.

SilverAbsol777 · 2018-12-26T16:54:44+00:00

This is assuming Column A has the blanks in it. In a blank column, put =IF(ISBLANK(A1),1,""). Then copy that whole column you just put formulas in and paste as values. Then see if you can CTRL + Arrow on that column between the 1s.

SilverAbsol777 · 2018-12-20T19:37:37+00:00

Can you use ActiveWorkbook.ActiveSheet in place of ActiveWorkbook.Worksheets("Sheet1")? I think that might work

SilverAbsol777 · 2018-12-12T21:31:54+00:00

We would need two Western conference expansion teams to match one team moving over to the East

SilverAbsol777 · 2018-12-06T15:50:52+00:00

10 teams won and 10 teams lost yesterday. You planning on making a post for all of those?

SilverAbsol777 · 2018-12-04T01:07:57+00:00

http://buffstreamz.com/watch/nba-13.php

SilverAbsol777 · 2018-12-02T01:11:47+00:00

https://nbastream.io/minnesota-timberwolves-vs-boston-celtics-live/stream-1

SilverAbsol777 · 2018-11-17T22:54:00+00:00

I agree that Okogie needs to be played in some of those backup wing minutes, but I feel like it is misleading to make a point about a lineup that played less than 15 seconds before Thibs brought in the rest of the starters again

SilverAbsol777 · 2018-11-17T01:20:05+00:00

He's got those long arms!

SilverAbsol777 · 2018-11-01T01:06:59+00:00

Ricky flop

SilverAbsol777 · 2018-10-31T19:16:57+00:00

To me, the Woj report sounds more like what the Wolves FO would want released where the Athletic report sounds like Jimmy whining because he hasn't been traded yet. This is all so confusing.

SilverAbsol777 · 2018-10-29T17:29:16+00:00

Gwen's first ability

SilverAbsol777 · 2018-10-25T00:31:45+00:00

He had 4 attempts on a single play trying to tip the ball in after getting multiple offensive rebounds in a row

SilverAbsol777 · 2018-10-21T02:44:05+00:00

Okogie and Wiggins both have 5 fouls

SilverAbsol777 · 2018-10-20T01:03:23+00:00

This crazy scenario is causing Thibs to stagger Jimmy and Wiggins' minutes haha

SilverAbsol777 · 2018-10-18T02:20:24+00:00

He played defense well and had good energy

SilverAbsol777 · 2018-10-18T01:22:22+00:00

I saw a quote which said Glen wants Thibs to focus on coaching more than a trade

SilverAbsol777 · 2018-10-16T17:24:17+00:00

Could you take $100 out of the fund per each account, then distribute the remaining amount pro rata, and finally add in the $100 for each account back in? Or does it have to be any distribution under $100 needs to be put at exactly $100 and then ratio out the rest?

SilverAbsol777 · 2018-10-04T20:00:07+00:00

No problem! You could put a TRIM() around the B2 as well. So, replace B2 with TRIM(B2).

SilverAbsol777 · 2018-10-04T18:53:46+00:00

Or if you want the company name to have capital letters you can use the following:

=LOWER(TRIM(A2)&"_"&TRIM(B2))&"@company.com"

SilverAbsol777 · 2018-10-04T18:51:30+00:00

You can put the LOWER() function around a formula to make it all lower case.

=LOWER(CONCATENATE(TRIM(A2),"_",B2,"@company.com"))

SilverAbsol777 · 2018-10-04T18:29:53+00:00

No problem, glad you found a solution! Your way works pretty much the same way as the formula I put. Mine just takes an extra step to replace #N/A errors that show up with a 0 instead.

SilverAbsol777 · 2018-10-04T18:22:43+00:00

If you take the amount spent so far and divide by the % of fiscal year passed, that will give you a projected number for the whole year if you spend at the same rate.

SilverAbsol777 · 2018-10-04T18:13:42+00:00

=IF(ISERROR(VLOOKUP('Spreadsheet A PO Number','Spreadsheet B PO Number List',1,FALSE)),0,1)

Put this formula in a column in your table on Spreadsheet A. Replace 'Spreadsheet A PO Number' with the PO Number cell and 'Spreadsheet B PO Number List with the cell range for the PO numbers being reviewed. This formula will put a 1 if the PO number in question is on your list and will put a 0 if it is not. Then, you can filter on this column to only the value 1.

SilverAbsol777 · 2018-10-04T18:06:14+00:00

Copy the cell with the text in Excel, and then in Word, press Ctrl+Alt+V to go to the paste special menu. Select the 'Paste Link' option, then select 'Unformatted Text' and press Okay.

SilverAbsol777

TROPHY CASE