data updating

  1. A

    VBA delete old rows with certain value then replace with new rows

    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...
  2. M

    VLOOKUP wild card matches

    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...
  3. S

    Macro to Update Data Between 2 Workbooks

    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...
  4. W

    data updaing problem

    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...
  5. 1

    Pivot Table Data Range Folder

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top