| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto extract data & inserts rows additional rows automatically
I have the following data from scala:-
Account No. Cost Center Desc. Jan Feb ........ Dec 54000 100 salary 2,500 3000 ........ 4000 54001 100 allowance 3000 4000 .........5000 54002 100 housing 2000 5000.......6000 I would like to extract the data in another worksheet as follows:- Row# Payroll Related ( heading) 2 Account No. Cost Center Desc. Jan Feb ......... Dec 3 54000 100 salary 2,500 3000 ......... 4000 4 54001 100 allowance 3000 4000 ..........5000 5 54002 100 housing 2000 5000 .........6000 6 Total 7500 12000 ...... 15000 In this worksheet i have a sum total on row 6, but in next month when i extract data from scala, what if i have more account no., i would like that the information is auto extracted with the account no. with the respective months amount and would automatically add it in rows 6, 7 and then the sum total is automatically shifted to row 8 without manually inserting additional rows. Need your kind help. thanks meeru |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create additional rows containing data from one original row | Excel Discussion (Misc queries) | |||
| select and extract rows of data to new excel worksheet | Excel Worksheet Functions | |||
| marco that inserts rows? | Excel Worksheet Functions | |||
| marco that inserts rows? | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
