Hi, I've written this macro to add a lookup formula in column Z if there is a value in column A and it works fine for this month. The only problem is it will only cover as far as Z 681 as that's how many rows are in column A this month but next month it might be 600 or 847, I simply don't know...
I pretty much recorded a macro and have decided that because of my lack of VBA skills, this would be the easiest route. However I have 2 problems with this. My range selection for VLOOKUP is not static and will change, thus I need to come up with a way to select all the same columns, but the...
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.