data updating

Ok, this may seem like an odd question - so hear me out please. Currently, we work within an Government client environment which has heavy restrictions on what we can and can't use, or do. Macros are a no go, but mercifully Power Query is ok. The business problem that drives me up the wall is...

Hi All, I have a file with macro in it. There are two different macros in it but I want to merge them using "Call". Both macros are working when run separately, but if I merge them, one of them stops with an error. Dim r As Long For r = hlpR To 1 Step -1 If Not...

Hi there, I am stuck and maybe VLOOKUP is not the way to go at all but here is what I am trying to do. I have a column where uses paste data ex: HP LaserJet 4014n Printer I want to update this data with the Correct Product name from a different tab in the sheet. Table_Array 'Price List Jan...

Hey guys, I am having some issues creating a macro to update cell data in a "master" workbook from another workbook that is generated weekly based on a Part ID. The Part ID is located in Column A in both workbooks, and the weights in the workbook to be read are in Column B. Here's a sample to...

Hi there, I have an on going problem with updating data from linked excel files. 1. I'm working with excel 2010. 2. The source files are excel 2007. 3. The link formula is VLOOKUP, for example: =VLOOKUP(A3,'C:\mobiledep\marketing\Documents\[output (1).xls]Sheet1'!$A:$B,2,0) 4. The data from...

Is there a way to use VBA or other solution to have my pivot tables point to the same file name and range, but in different folders? For example, I have a folder named 2010-MAY. I have pivot tables that update from a file in that folder called Data.xls. The file has a text-import range...