If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Making field values appear in every cell
I have a question: is it possible to make the field values appear in every cell, instead of just the first row for that particular level? For example, instead of:
Quarter Amount 2004/2 $36.52 $95.24 $57.25 $10.98 I would like to see: Quarter Amount 2004/2 $36.52 2004/2 $95.24 2004/2 $57.25 2004/2 $10.98 Basically, I'm wanting to use a Pivot Table as a way to create another table. I know this can be done in Access, but I'd rather do it in Excel if possible. Please help! Thanks, Eric |
#2
|
|||
|
|||
Making field values appear in every cell
You could copy the cell with "2004/2", then select the entire range you want it to appear in and paste. It will paste it into every cell in the selected range. If you want it to automatically appear in the left cell when you enter more data in the right cell, I don't know how to do that.
Good luck. "Eric Stephens" wrote: I have a question: is it possible to make the field values appear in every cell, instead of just the first row for that particular level? For example, instead of: Quarter Amount 2004/2 $36.52 $95.24 $57.25 $10.98 I would like to see: Quarter Amount 2004/2 $36.52 2004/2 $95.24 2004/2 $57.25 2004/2 $10.98 Basically, I'm wanting to use a Pivot Table as a way to create another table. I know this can be done in Access, but I'd rather do it in Excel if possible. Please help! Thanks, Eric |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |
Do you have what it takes... | darno | Worksheet Functions | 0 | February 22nd, 2004 08:01 PM |
Howto: Filling in values based upon a particular cell | Eric Tubbs | Worksheet Functions | 6 | December 3rd, 2003 07:24 PM |
Seperating values in one cell | Marcus Horcher | Worksheet Functions | 3 | October 20th, 2003 01:03 PM |