Home » Forums » Open Source Learning Center » Question and Answer

I need help to design a VBA code

Submitted by pmchris on 21 October, 2013 - 18:45

Hi;

I want to design a Macro to simplify my daily process. What I need to is that I need to compare fund's value between yesterday and today. However, the fund #s are not the same every day, because some old fund #s are out and some new fund #s are in. When new fund #s are in, they may not be starting from the last existed fund #, they could be in the middle.

I abstract some # from my fund. For example, from yesterday to today, the fund # 1022 and 1032 are gone, but the new fund # 1073 and 1074 are added in. And then, I need to copy value from yesterday to today based on the fund #. If we have new fund # added in, I need to insert a blank.

Thanks in advance.

Chris

AttachmentSize
if practice.xls22 KB
‹ Excel Transpose Macro (Button) Paste Named Range in next available row ›
»
Almir's picture

Try pivot table

Submitted by Almir on 14 February, 2014 - 17:31.

For each day add a column with a date and add data to the previous day data. Create pivot table to compare data. On fund # choose "Field Settings" and turn on "Show items with no data".

»