| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel automaticly advancing copied cell numbers
Forgive me, I don't know much Excel lingo. I'm changing the layout of
packing slips for a fundraiser company. The Tally Sheet read: Column A Column B Column C Cookies Cakes Row1: Joey 5 2 Row2: Billy 3 1 The packing slips read: Row1: Name - Joey Row2: Cookies 5 Row3: Cakes 2 Row4: _________________________ Row5: Name - Billy Row6: Cookies 3 Row7: Cakes 1 The individual student's sales are on one worksheet, but when I'm pulling them onto the packing slip, the cells are several rows apart, therefore the cell number advances that many. Any way to do this besides entering it on all 250-500 packing slips by hand? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel automaticly advancing copied cell numbers | Excel Worksheet Functions | |||
| how to make excel automaticly jump to next cell? | Excel Worksheet Functions | |||
| how do I convert copied Text numbers into values in Excel? | Excel Worksheet Functions | |||
| converting copied data to numbers in excel xp | New Users to Excel | |||
| how do you change invoice numbers automaticly | New Users to Excel | |||
Hybrid Mode
