nickxx4360
10-10-2008, 01:03 PM
Hello,
I am new to coding so please forgive the ignorance on the subject.
I have to do a project for my company and part of it has to do with editing a excel spread sheet then saving it. I need to automate it so I used the macro recorder to do one have of what I need to do. The other half of what I need to do is where I get stuck.
Attached is the spreadsheet.
First I need to delete A1:A9. I get that done fine by recording a macro. After I delete those lines I then have to get the sum for C12 and C13. notice they are have the same trade ID (oxy) after I get the sum I need to delete either one (oxy) and leave the sum in place so I ned up with one entry for oxy.
I will attach two spreadsheets, one before and one after the edit.
Thanks for the help in advance.
Nick ?The computer guy?
I am new to coding so please forgive the ignorance on the subject.
I have to do a project for my company and part of it has to do with editing a excel spread sheet then saving it. I need to automate it so I used the macro recorder to do one have of what I need to do. The other half of what I need to do is where I get stuck.
Attached is the spreadsheet.
First I need to delete A1:A9. I get that done fine by recording a macro. After I delete those lines I then have to get the sum for C12 and C13. notice they are have the same trade ID (oxy) after I get the sum I need to delete either one (oxy) and leave the sum in place so I ned up with one entry for oxy.
I will attach two spreadsheets, one before and one after the edit.
Thanks for the help in advance.
Nick ?The computer guy?