Entering VLookup formula based on filtered data

O177812

Board Regular
Joined
Apr 16, 2015
Messages
82
Office Version
  1. 365
  2. 2021
I have a real head scratcher that I can't seem to get past and could use some assistance.

I have a spreadsheet that needs to be populated daily based on varying data (i.e. some days row 6, 8, &, 10 are populated and other days rows 1, 5, 9, & 11 are populated)

Currently I have a VLOOKUP (linked to a secondary document) in every cell (A1:AV54) that will return a blank if the beginning of that row is not populated on that given day, however that is causing the document and my computer to run slow and even sometimes crash.

I need HELP!

I am thinking one of two solutions will work but I am unsure on how to write either

1. Is there a VBA macro that will search column B for data and then enter the VLookup on only those corresponding rows in Column C?

2. Can I filter the data and then apply the vlookup to the top row (varries) and then copy down to the end of the filtered data?

Any help or guidance would be greatly appreciated.

Have a great week!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
I have gotten this far on option (2):

Range("A1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$C$17").AutoFilter Field:=2, Criteria1:="<>"
Range("C1").Select
ActiveSheet.AutoFilter.Range.Offset(1).SpecialCells(xlCellTypeVisible).Cells(1, 3).Select
ActiveCell.FormulaR1C1 = "=RC[-2]+2"
Selection.FillDown

The problem is that the above won't enter the formula.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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