owner

Using Power Query From folder to return the folder details. The folder I am working with also shows the "owner". That information doesn't automatically pull into Power Query. Is there a way to add a column for that? Ultimately, we want to be able to filter by modified date and owner. Thanks...

Hey Everyone! I need to create a macro to make come reports easier to handle. One of them looks like this when it gets put into excel. Basically it tells who the owners are to certain stocks. I need only the rows where it tells the stock owners only. A cell like that looks like this for...

Hi Board, It's been so long since I've done this I've forgotten how! <tbody> A B C D E Owner First Name Surname Name Owner Anne Joe Bloggs Joe Joseph Bloggs ANother </tbody> For ease I have put this data on one table, however, the data is split across two tables in two sheets. So...

Hi All, I’m really hoping for some help as I’ve been trying to do something on Excel for a few days now and it’s driving me mad – my VBA skills are limited at best so any help would be hugely appreciated. I’m looking to build a macro that allows me to pull rows of information from multiple...

I have 4-5 different project trackers that track key dates for different projects taking place at each "store location". I am creating one excel file that will load the data from the 4-5 trackers and pull they key dates for each "store location" and organize them in one easy to view report...

Hi, I'm building an action tracker at work to monitor actions arising from the various meetings. Within the spreadsheet, there are numerous worksheets, all with the same sub headings. Within the sub headings there are 'Reference, 'Description & Action', 'Owners', 'Action Owner', 'Due...

I ran into this rather simple problem, however, when tackling it -- seems more difficult to do. I have a Region (G) and a Department (H) on 'FP&A Owner' sheet and have a look up table with ranges. Based on a region/range, I want it to go to the "Lookup Table" and retrieve FP&A Approver (F)...

Hi, I am using excel to track maintenance calls. Every call is entered into excel master sheet based on "Location, Task, Labor (00:00), Material Cost ($00.00), Material Description" there are several other cells but not needed for final output. At the end of the month, we take these values and...

I'm trying to display the owner of a particular folder, but I can't find the code. Any ideas? Here is what I have: Sub ShowFolderInfo() FolderSpec = "C:\Documents and Settings\user\My Documents\test\" Dim fs As Object Dim f As Object Set fs =...