Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy column and header names from existing spreadsheet to new spre
I need help coping all column and header info brought over from one
spreadsheet to another with out copying and pasting everything. Is this possible and how do you do it? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy column and header names from existing spreadsheet to new spre
which info you want to put in new sheet and which you want to skip, please explain in detail alongwith the format of your data. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=561613 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy column and header names from existing spreadsheet to new spre
Like starguy, I'm a little uncertain of exactly what you are trying to do.
Are you working within a single Excel workbook, or between 2 or more of them? No matter, give this a try: Choose the existing sheet that has things set up the way you want (you can even choose several sheets at once, search Help for Group) then from the menu bar, choose Edit | Move or Copy Sheet and check the [Make Copy] option. Then, just pick where to put them, in the same book, or in another that is also open, or even into a brand new book and click OK and you're done. You can then go to the copied sheets and delete any information you don't want on them to start fresh. The [Make Copy] option makes a copy, leaving the originals right where they were, if you don't choose that option then the sheets are literally moved (like a Cut operation). If you copy them into the same workbook they will get a little indicator added to their names. For example, a sheet named 'Sheet1' copied into the same book will be given the name 'Sheet1 (1)' the first time it's copied, 'Sheet1 (2)' the second time, etc. The original sheet will not have its name changed. If this isn't what you were looking for, let us know and we'll try to help again. "lbierer" wrote: I need help coping all column and header info brought over from one spreadsheet to another with out copying and pasting everything. Is this possible and how do you do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match, Copy, Merge, Delete and Repeat... MVP's this one's for you. | Excel Discussion (Misc queries) | |||
Replace all non blanks in a column with column header | Excel Discussion (Misc queries) | |||
Match Header...Copy Column | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
How to set a custom header as a row from the spreadsheet? | Excel Discussion (Misc queries) |