Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2016, 01:57 AM
cloa513 cloa513 is offline Copy a cell's contents across many cells Windows 7 32bit Copy a cell's contents across many cells Office 2007
Novice
Copy a cell's contents across many cells
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default Copy a cell's contents across many cells

I could potentially do the same overall task in Excel but it present lots of problems using Excel and it becomes more ugly.

The cell's contents are a table and I'd like it copied to many cells in the same column. I have Word 2007. How do I do that?
Reply With Quote
  #2  
Old 09-18-2016, 06:13 AM
JimP JimP is offline Copy a cell's contents across many cells Windows 10 Copy a cell's contents across many cells Office 2013
Experienced User
 
Join Date: Jun 2010
Location: Virginia Beach, VA
Posts: 742
JimP will become famous soon enough
Default

Highlight the cells you want copied by clicking the first cell and dragging your cursor to the end point, then right-click and select copy. Simple as that...
Reply With Quote
  #3  
Old 09-18-2016, 03:39 PM
cloa513 cloa513 is offline Copy a cell's contents across many cells Windows 7 32bit Copy a cell's contents across many cells Office 2007
Novice
Copy a cell's contents across many cells
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default Clarification- I meant part of a cell.

That works for a full cell's contents (if you select the whole cell) but not for part of cell's contents (I only need part of one cell to be copied). Basically the main table will a calendar and the subtable will be a schedule.
Reply With Quote
  #4  
Old 09-19-2016, 12:28 AM
macropod's Avatar
macropod macropod is online now Copy a cell's contents across many cells Windows 7 64bit Copy a cell's contents across many cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Well, you did describe what you wanted to do as copying a cell's contents, not only some of those contents. For the latter, copy the part & paste into one cell, then do as JimP suggested for the remainder.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 09-19-2016, 03:11 AM
cloa513 cloa513 is offline Copy a cell's contents across many cells Windows 7 32bit Copy a cell's contents across many cells Office 2007
Novice
Copy a cell's contents across many cells
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default Cell contents not cells

I just checked your solution and that sort of works but it doesn't because it overrides the previous cell contents. JimP's answer was really how to copy a cell into multiple cells not its actual contents (e.g. if the new cells had anything in them they would lose what they contain) and it seems it is hard to get Word 2007 to stop treating any paste object as a complete cell so it deletes any pasted into cell's previous contents. Is there a solution? A clumsy alternative would be how to convert a table so that the start text of any cell is a calendar.
Reply With Quote
  #6  
Old 09-19-2016, 05:12 AM
macropod's Avatar
macropod macropod is online now Copy a cell's contents across many cells Windows 7 64bit Copy a cell's contents across many cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You really do need to be clear about what you want to do. You're now up to the third iteration...

For what you're now describing, a macro would be needed but, even then, it's not exactly clear what your expectations are.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 09-19-2016, 01:53 PM
cloa513 cloa513 is offline Copy a cell's contents across many cells Windows 7 32bit Copy a cell's contents across many cells Office 2007
Novice
Copy a cell's contents across many cells
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default Let's start with the goal

I want to end up with a calendar with subtables that are schedules- many subtables are identical or have parts that are the same. Each cell will have its date- I'd prefer that it start with the dates in each cell of the table- lots of calendar formats in Word. Second preference is start with all subtables set up and add dates.
Reply With Quote
  #8  
Old 09-19-2016, 03:37 PM
macropod's Avatar
macropod macropod is online now Copy a cell's contents across many cells Windows 7 64bit Copy a cell's contents across many cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You might do better to use multiple cells for each date (you can delete any unwanted inter-cell borders). That way, you could do the kind of copy/paste discussed in previous posts. This would also simplify future maintenance of the table should there be any need to change the replicated data.

Otherwise, without seeing your document and a detailed explanation of what is required, it wouldn't be possible to craft a macro - which could only replicate the data as a once-off exercise - and, even then, it probably wouldn't be worthwhile (writing the macro might take longer than doing the job manually).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 09-19-2016, 07:06 PM
cloa513 cloa513 is offline Copy a cell's contents across many cells Windows 7 32bit Copy a cell's contents across many cells Office 2007
Novice
Copy a cell's contents across many cells
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default An Example Timetable

If I have to do individual cells then I might as well use Excel- it has Smart Fill down (easier to work with but not as nice to look at) and it has some the same general cell format abilities. (it is three months of timetable to see how much)
For most weeks:
Monday's (same for Wed and Friday) column has the same sub-table every day. Tuesday has the same times but different classes and teachers.
Thursday has the same times, classes and teacher for the morning.
Attached Files
File Type: docx Example Schedule.docx (13.7 KB, 10 views)
Reply With Quote
  #10  
Old 09-19-2016, 07:17 PM
macropod's Avatar
macropod macropod is online now Copy a cell's contents across many cells Windows 7 64bit Copy a cell's contents across many cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For Monday, Wednesday & Friday, you could bookmark the sub-tables for each, then insert cross-references to their bookmarks wherever you want the sub-tables replicated. Likewise for Thursday mornings (you'd need a separate sub-table for Thursday afternoons). That would leave only Tuesdays & Thursday afternoons requiring individual attention. Even then, if the times are the same, you could create one sub-table for each, which you replicate via copy/paste, then fill in only the variable details.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 09-19-2016, 09:22 PM
cloa513 cloa513 is offline Copy a cell's contents across many cells Windows 7 32bit Copy a cell's contents across many cells Office 2007
Novice
Copy a cell's contents across many cells
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default I said in general

Note I said generally, even my current timetable has some variation on that in October and I need something that is modifiable for print use- it has varied in the past like shorter times on some days and the periods all changed around. I guess I am going to need to use Excel unless the date can be a dynamic field that depends upon the row and column number in the main table then I can copy the whole cell and paste in many places.
Reply With Quote
  #12  
Old 09-19-2016, 09:32 PM
macropod's Avatar
macropod macropod is online now Copy a cell's contents across many cells Windows 7 64bit Copy a cell's contents across many cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you want dynamic dates, Excel is a far better tool. To see what would be involved in Word, check out my Microsoft Word Date Calculation Tutorial, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Calculate a Date Sequence'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 09-19-2016, 10:58 PM
cloa513 cloa513 is offline Copy a cell's contents across many cells Windows 7 32bit Copy a cell's contents across many cells Office 2007
Novice
Copy a cell's contents across many cells
 
Join Date: Dec 2009
Location: Japan
Posts: 17
cloa513 is on a distinguished road
Default

I meant only a spatially dynamic field not a chronologically dynamic field like a fixed calendar.
I checked the Windows Secrets one and doesn't work correctly today's date comes out right but not other modified forms of dates- I don't whether its because theirs is not designed for Word 2003 or that my computer is Japanese version.

I thought of another option is create calendar using template, delete columns for weekends, add columns for the schedules- fill down using JimP's instructions. Save then save as another document and then consider removing the column boundaries.

I found this for removing column boundaries.
http://www.wordbanter.com/showthread.php?t=44565 and then found the eraser tool and this solves it- it seems it always puts the date at the top and table at the bottom- is that always right? Thanks for all your replies.
Reply With Quote
  #14  
Old 09-19-2016, 11:11 PM
macropod's Avatar
macropod macropod is online now Copy a cell's contents across many cells Windows 7 64bit Copy a cell's contents across many cells Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by cloa513 View Post
I checked the Windows Secrets one and doesn't work correctly today's date comes out right but not other modified forms of dates- I don't whether its because theirs is not designed for Word 2003 or that my computer is Japanese version.
That may be because of internationalisation issues, for which a macro remedy is included, as discussed in the Introduction.

Quote:
Originally Posted by cloa513 View Post
I found this for removing column boundaries.
http://www.wordbanter.com/showthread.php?t=44565 and then found the eraser tool and this solves it- it seems it always puts the date at the top and table at the bottom- is that always right?
I would expect the tool to behave consistently - it's just a matter of choosing carefully what to erase.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy a cell's contents across many cells If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
Copy a cell's contents across many cells Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Copy a cell's contents across many cells Selection from cell with list contents autopopulates contents of another cell markharper80 Excel 3 02-16-2015 04:18 PM
Copy a cell's contents across many cells Copy table cell formatting across multiple cells / tables pakistanray Word Tables 2 10-31-2011 08:07 AM
Copy all comments & cell contents (i.e. data) to word? IanM Excel 0 07-03-2010 11:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft