Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
EXCEL & MSQUERY 1-to-many with calculated field in pivottable
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...- jwoo6452
- Thread
- Replies: 0
- Forum: Microsoft: Office
-
Excel Match Value to a date period in table and return adjacent #
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...- jwoo6452
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA AUTOFILTER & Copying table into Word from Excel Range
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...- jwoo6452
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
