|
How to Copy single Cell into Multiple cells
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. -- ------------------------------ Thanks Nitesh Mathur ------------------------------ |
How to Copy single Cell into Multiple cells
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) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nitesh Mathur" wrote: 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. -- ------------------------------ Thanks Nitesh Mathur ------------------------------ |
How to Copy single Cell into Multiple cells
Mr. Max
Thanks a lot .....problem resolved in a very easist way. -- ------------------------------ Thanks Nitesh Mathur ------------------------------ "Max" wrote: 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) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nitesh Mathur" wrote: 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. -- ------------------------------ Thanks Nitesh Mathur ------------------------------ |
How to Copy single Cell into Multiple cells
welcome, Nitesh.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nitesh Mathur" wrote in message ... Mr. Max Thanks a lot .....problem resolved in a very easist way. -- ------------------------------ Thanks Nitesh Mathur ------------------------------ |
| All times are GMT +1. The time now is 06:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com