Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy paste manually
I have the format in excel file as below: Employee Number Location Payment Type Amount ($) 123 City RI $50 City RA $25 City RX $15 124 Brisbane RA $14 Brisbane RU $12 158 Perth RT $56 Perth RA $11 €¦€¦ and so on €“reach thousand of lines. If I wish to have this second format €“per example below (in excel) , I do need to copy and paste the Employee number to each row one by one.Is there any way (any vb code /macro) that I can use for automation to get the second report (as example below)? Format as result of manual copy paste the Employee number as follows: Employee Number Location Payment Type Amount ($) 123 City RI $50 123 City RA $25 23 City RX $15 124 Brisbane RA $14 124 Brisbane RU $12 158 Perth RT $56 158 Perth RA $11 €¦€¦ and so on €“reach thousand of lines. Anyone can help and much appreciate any input /suggestion. PA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activesheet.Paste does OK manually between worksheets but not in M | Excel Discussion (Misc queries) | |||
Protected document loses all protection(hidden columns) when manually copy-pasted | Excel Discussion (Misc queries) | |||
protected document loses all protection(hidden columns) when manually copy-pasted | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming |