Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date changes when copied and pasted | Excel Discussion (Misc queries) | |||
Preserving lock on cells even when copied and pasted within a sheet | Excel Discussion (Misc queries) | |||
How do I protect a worksheet from being copied & pasted? | Excel Discussion (Misc queries) | |||
Worksheet_Selection Change code will not allow cell contents to be copied and pasted onto the sheet it's running on | Excel Programming | |||
Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) |