LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default How do I matain formats when copy and pasting data from various so

I'm somewhat of a newbie and need help!!

I need to cut and paste info from various spreadsheets into one. Each user
formats their cells a bit different and the final version requires
significant time to reformat each week.

Is there a way I can cut and paste into my master w/o losing my formulas and
formatting?

Is there a way I can provide them a template sheet w/ locked formats so they
cannot edit or reformat?

Is there an easy way to merge this data into one spreadsheet vs. cut, paste,
reformat...

I would SO appreciate the help!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RESTRICT PASTING FORMATS FARAZ QURESHI Excel Discussion (Misc queries) 1 March 26th 08 12:26 PM
Copy/Pasting Data in a Workbook MCSHMCH Excel Discussion (Misc queries) 4 September 28th 07 02:58 AM
Copy and pasting on columns but on spreadsheet with alot of data Michael Excel Discussion (Misc queries) 2 October 10th 06 01:49 PM
pasting links and formats prakash Excel Discussion (Misc queries) 2 August 28th 06 12:00 PM
Looking to copy a worksheet with all formats and formulas without coping inputed data God's Kid Excel Discussion (Misc queries) 3 October 28th 05 11:59 PM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"