How to Copy single Cell into Multiple cells

[Nitesh Mathur]

I'm Using MS Excel 2003 ,presentally I'm facing a problem while copy a single
cell into multiple cells. General copy or drag system is working but if I
have a sheet in which "column A" have Employee name and "column B" have "
Projects name". When I'm creating PIVOT table then its shows only one emp.
name to assign one projects . And I'm making these cells copy(manually) &
then pasted in front of related projects;then after its shows exact number of
project count related to epm. name and this is a big exercise to do for 300
Employees.

Any method which can resolve my problem and save my time to do this exercise.

 

[Max]

Not within the actual pivot itself, but possible on a pasted special as
values copy
of it

Try Debra Dalgleish's page for ways to fill in the col blanks:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells

Fill Blank Cells
Fill Blank Cells Programmatically
(Sub FillColBlanks() by Dave Peterson)

 

[Nitesh Mathur]

Mr. Max

Thanks a lot .....problem resolved in a very easist way.

 

[Max]

welcome, Nitesh.