get data

Hi, I need to get a pivot row header name to another cell if another cell matches. DETAILED EXPLANATION: Se example of pivot table below. I have two sheets, lets call them "data" (sheet with pivot table) and "result" (without pivot table). If any text in C:C (in "result") matches any of the...

I copied and pasted a common table that I was using in my spreadsheets to save time. Now excel says it couldn't get the data from table "x" in a workbook in another location. I don't need the file to pull data from another location as it is already in my excel file. Is there a way to...

Code Example: Sub getLookup() GetData "\\myserver\SourceFile.xls", _ "2015", "A3:AW4", Worksheets("Lookup").Cells(3, 1), True end Sub I use the getdata several times to copy a range of data from a closed workbook to my current workbook and it seems to work fine for me in Excel 2010 except...

Good Day, For my first post I'd like to know if it is possible to use the "drill down" feature of a pivot table within a cell out side of that pivot table. I am using Excel 2010, on Windows 7. The end user(s) will have these (at a minimum) or newer. I have a report that tracks inventory a...

I am trying to figure out how to copy a range of data from a open file WITHOUT naming a file path. The file path varies, and is a temp file downloaded from our system. I would only like to apply this macro only when a file called pricedownload.csv is open My work team each downloads a pricing...

Hi, I have a macro that runs properly and does the following steps: - Alows you to select the files you want - Copy tha range "C30:K30" of every sheet called "Factura" - Merge all the ranges in a new sheet. I want to change it in order to get the same range ("C30:K30") but from the last sheet...