MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.