macro to copy values
Posted by Darci on May 30, 2001 3:05 PM
First of all, thank you for your input on my previous inquiries, as i am currently working on getting those items to function properly. I have another question, I have 1000 items of which i need to perform analysis on. I will be using a DDE link to pull in the latest prices of the items, and taking the ln of these prices, and other historical information will also be pulled in. If i have the names listed down a column in a separate sheet, and after creating the first one as a template with the necessary calculations, how do i get a macro to know to look at the next name in the list and perform the same calculations as in the template. I have not written code for macros before, rather i have just recorded them with the icon. thanks in advance for any assistance... Darci
Posted by Kevin James on May 30, 2001 7:27 PM
Macro vs formulas
Darci:
Maybe I'm not following you, but if you have formulas in the first row, why not copy those down? What would a macro buy you in this instance?
Kevin
Posted by Darci on May 31, 2001 6:03 AM
Re: Macro vs formulas
Thank you. I didn't think it could be that easy. I also didn't know how it would know to look at the next name in the list. But i got around that by transpose function to change the rows to columns and it should work just fine... thanks again.
Posted by Natalie Greppi on June 19, 2001 8:15 AM
Well, i may help but i was not able to understand the problem.
