Creating a macro where values are copied and pasted into a sheet
Think about using a pivot table instead of a macro... That way, you
don't have to subtotal anything. The pivot table does it for you. You can set the table to refresh up opening the workbook, or write a macro to refresh whenever you want. Rob BrianMo wrote: I am trying to create a macro that when run will take information from one sheet and copy it into another. On the first sheet called Multi basis report there are 4 columns. (B) Security Id, (C) Security, (D) Realized G/L, and (E) Total Gain/Loss. I need to take the security Id #, the security name, and it's realized gain/loss and paste it onto a sheet named 2006 Sched D changes for transfers. The issue I am having is that on my first sheet there are multiple lines for each security Id instead of just one consolidated line. I have created subtotals for each security so there is a single line with the security Id and the total column summed up. Any help that can be offered is greatly appreciated. Thanks in advance, Brian Monaghan |
All times are GMT +1. The time now is 02:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com