Hey!
I'm v.new to macros & the like so i need some advise.
I have a task i need to automate as I seem to have to do it manually 10 times a day.
I just need help with the principle really - so, hypothetically, if i was recording a macro to just multiply cell A1*B1 in cell C1,; I could have a file that has just 5 rows with A & B values, but other files may has 20,0000 A & B values.
What is the most efficient way to do this so after the macro runs I have no tidying up to do? - i say this as the way i would do it at the moment is to copy cell C1 through to C65536, and when i get a file with just 6 rows i have to clear the remaining 65531 cells!
I'm v.new to macros & the like so i need some advise.
I have a task i need to automate as I seem to have to do it manually 10 times a day.
I just need help with the principle really - so, hypothetically, if i was recording a macro to just multiply cell A1*B1 in cell C1,; I could have a file that has just 5 rows with A & B values, but other files may has 20,0000 A & B values.
What is the most efficient way to do this so after the macro runs I have no tidying up to do? - i say this as the way i would do it at the moment is to copy cell C1 through to C65536, and when i get a file with just 6 rows i have to clear the remaining 65531 cells!