| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros to copy and paste data
I have a complex sheets. 4 separate sheets in fact. Each sheet has a data for
12 months by ( months) for four separate product. each month there a macro to copy data from these four separate sheet and compile into one. Your help is much appreciated. here is an example JAN RanK pdt# Account # Revenue FEB RanK pdt# Account # Revenue All four sheets are in same format. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros to copy and paste data
You need more detail
1) Describe each page in more detail. It appearrs you have a row with just JAN and the next row with data. then a row with just FEB and another row of data 2) How do you want the Summary to look. Describe column and rows. "Migyu" wrote: I have a complex sheets. 4 separate sheets in fact. Each sheet has a data for 12 months by ( months) for four separate product. each month there a macro to copy data from these four separate sheet and compile into one. Your help is much appreciated. here is an example JAN RanK pdt# Account # Revenue FEB RanK pdt# Account # Revenue All four sheets are in same format. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use macros to copy and paste from 1 file to several files | Excel Worksheet Functions | |||
| Problem with copy and paste together with macros | Excel Worksheet Functions | |||
| Copy and Paste Macros | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Creating a macros to copy and paste cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
