I'm just learning macros. Here's the setup.
i.e. a1 I input city a. a2 I input City b the on b2 it will tell me what the mileage is.
It's pretty much set up like every other mileage chart you see on a map with the city name across the top row and the same name on the left column
then the mileage is set in the grid
every once in a while I will input a city name into sheet 1 and I haven't yet input that number into sheet 2 yet so 0 is displayed
I have added 3 cells in sheet 1 to automatically enter the correct mileage into the mileage chart
the 2nd cell city b and the 3rd cell the mileage
the 1st cell (lets call it A1) tells me the r#c# of the intersection of the 2 cities
the 2nd one (A2) tells me the opposite r#c# since each mileage is listed twice depending on whether its from city 1 to city 2 or city 2 to city 1
the 3rd (A3) is the mileage that I input in sheet 1
and then I type in the mileage
then copy and paste the 2nd address located in A2 into the name box and entering the miles again.
what I want is a macro so all I have to do after entering the 2 city names and mileage into sheet 1
is run the macro and have it automatically go to the addresses specified in sheet 2 and input the mileage in for me
every time I try this the macro does not record me pasting the R#C# from A1 and A2 into the name box and hitting enter.
It just inputs the mileage into the same boxes every time. Since the address is going to be different every time this just wont work.
Edited by Katralic, 21 November 2015 - 11:21 AM.