LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 151
Default Autofill a list

I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotals in a list Bagheera Excel Discussion (Misc queries) 9 May 20th 06 01:46 PM
How to link data from one drop-down list to another dolfijntje33 Excel Worksheet Functions 6 May 19th 06 07:40 PM
Check 2 different list get associated value from a column deja Excel Worksheet Functions 1 April 20th 06 04:11 AM
LOOP - Adddress List -to email Paul. Excel Discussion (Misc queries) 0 April 13th 05 09:54 AM
Refresh a Validation List? jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 05:48 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"