How to Copy single Cell into Multiple cells

  • Thread starter Thread starter Nitesh Mathur
  • Start date Start date
N

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.
 
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)
 
Back
Top