Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ------------------------------ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ------------------------------ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ------------------------------ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ------------------------------ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a single cell value to repopulate multiple cells | Excel Worksheet Functions | |||
Using a single cell value to repopulate multiple cells | Excel Discussion (Misc queries) | |||
Copy column of cells to a single cell? | Excel Discussion (Misc queries) | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) |