Recent content by jwoo6452

I have a pivottable that uses MS QUERY to relate three tables: COST TABLE, REVENUE TABLE, and a relating table between the two. They relate 1-to-many with EACH Revenue Item (potentially) containing multiple Cost Codes (and by relation cost amounts). I am hoping that it is possible to create...

I know how Vlookup would work I enter a table of dates and matching period numbers for EACH day on sheet2, but then I may as well assign a period number to the data itself since the number of entries per day is about 10-20(I assign manually now). But, I would like to be able to enter a date...

I have daily data on Sheet1 containing many columns including a "period#" column and a "date" column. Sheet2 contains a table of ~monthly periods (1-24 so far) that have variable start-end dates in adjacent columns (three columns: period #, startdate, enddate). I would like to find a function...

... Figured it out. After copying the entire filtered range to the hidden sheet, I copied the still selected range that was pasted without the rows hidden by autofilter. The copied selection was then pasted into Word. Another solution is to PasteSpecial as a Metafile type. This will not copy...

I was hoping there was a simpler solution; How did you account for a variable number of rows in the internally copied data so that the table in Word includes all the rows needed (and no more)? I would assume countif or select and offset until blank...

I am pasting a range into a word document from an excel range after running autofilter (from VBA) on the range. Worksheets("Sheet1").Range("YourExcelrange").AutoFilter Field:=2, Criteria1:=chosenValue YourExcelrange.Copy YourWordDocument.Bookmarks("YourBokmark").Range.PasteSpecial This...