vba lookup

  1. W

    VBA copy data in a row and Paste in a separate row based on the weeks date

    Hi The table on the right updates automatically based on the data for that week. What I want to do is then copy & paste the data into the table on the left based on the latest date - which changes each week. The date in the column on the left do not change, so effectively I want to copy the...
  2. D

    VB range lookup to return a value?!?

    Hi All - I'm desperately hoping someone has the solution for what I'm trying to do here. Posting on mobile, so apologies in advance for not having code to paste outright. I have two worksheets in my workbook, one titled teams and the other data. On sheet 'teams' I have a listing of agents and...
  3. S

    VBA Lookup Help

    Can anyone tell me why this line of code is not working: ActiveCell.FormulaR1C1 = "=IF(RC[-5]>0,VLOOKUP(RC[-5],'C:\Users\Scott A. Schmeling\Google Drive\HCA Files\Projection Files\Projection Spreadsheets\Org 5110 Projections.xlsx'!Table2[#All],3),"")" I keep getting an application defined...
  4. N

    VBA retrieving information 2 spredsheet

    hello Forum, i would need your advise on solving the next chalenge in Excel. i have a list with invoice ordinal number ( from 1 to 40 - which depicts the position in a list ) in the Columns spreadsheet. see image attached image1 Uploaded with ImageShack.us in another spreadsheet...

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
Back
Top