I am trying to do a vlookup in vba, save the results in a variable and
then place the value in a cell. I used to have the vlookup as a
function for the cell:
Cells(LastRow, 2).FormulaR1C1 = "=VLOOKUP(R1C2,[Garnishment_2009_4.xls]
Sheet1!R3C1:R100C4,4)"
However, I don't want it linked, I just wa
I asked this question to soon. Right after I posted the question, I
found the answer.
On Mar 4, 8:38 am, iwasinnihon wrote:
> I am writing a macro and would like to have it find the next available
> row on a sheet, enter the date, do a vlookup, and enter a running
> sum. I can do e
I am writing a macro and would like to have it find the next available
row on a sheet, enter the date, do a vlookup, and enter a running
sum. I can do everything except find the next available row. How
would I do this?
--~--~-~--~~~---~--~~
--
I have two files. One file has a list of id numbers, names and
amounts. The other file has a seperate sheet for each person that has
the id number in the A1 cell. I would like to have a macro that will
go through each line on File1, find the correct sheet in File2 and
copy the amount to the nex
