Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy whole table into one cell
You can't copy a table into a cell. Best you could do is convert to text,
and use a non-proportional fonf (fixed-width, like courier for example) and pad field values with spaces so everything lines up. You'd have to use a non-proportional font in your Word doc as well for it to look half-decent. Most likely there's better approaches: the best one would depend on what you need to do with the reports once they're generated. If you're just printing, it might be easier to lay it out in XL. Tim "Nit_Wit_400" wrote in message ... Office Excel 2003 on Windows XP I'm trying to create a report-maker with excel... ugh! Anyways, there is a template that users are filling out saying whether something is defected or not... that's not important, the important part is, that I'm having VBA go though the table (using a button after it is filled out) and deleting the rows that aren't defected... in other words, if there are blank cells in column C (for example), the whole row in which that blank cell is located is deleted. I'll never have more than 40 rows and 5 columns in the table so I don't think I'll exceed Excel's maximum character limit per cell. What I want to do next is put that whole table in a new sheet in the first blank cell in row 2 so that I can make them mergable into a Word document (which will have all 256 possible merge fields in place). As you've probably guessed, I'm going to be doing this multiple times per report. I guess the most basic question to ask here is: How do I copy a whole table and paste it into one cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Pivot Table: Can I copy link cell across ? | Excel Discussion (Misc queries) | |||
copy same cell from different ascending sheet into a table? | Excel Worksheet Functions | |||
Pivot Table formula cell copy | Excel Discussion (Misc queries) | |||
How can I copy a table from a cell value? | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) |