| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste Macro using large amount of Data
Hi All:
Can you please tell me if there is a macro that will copy at each change in Customer name and paste into a new worksheet. For example, if I have over 32,000 lines of data each subtotalled by Customer Name and Sales $, how can I get a macro to copy each group and paste into a new worksheet. I have about 60 different customers so wanted to try to reduce some of the manual copy and paste that is necessary. Thanks to all for your response. Nikki |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro stops with "Large Amount of Data" Message | Excel Discussion (Misc queries) | |||
| Reformating large amount of data | Excel Discussion (Misc queries) | |||
| Changing large amount of Data | Excel Discussion (Misc queries) | |||
| Large amount of data for plotting | Charts and Charting in Excel | |||
| How do I paste a large amount of text into a cell ? | Excel Discussion (Misc queries) | |||
Threaded Mode
