How to link data and it's formats bewteen worksheets

I am using Office v.X for mac. I have a workbook that that has master
worksheet with A1:AK4 column headings and A5:AK265 has data with
different formats (date,text,number etc.) I want to create new
worksheet as a diiferent catagories with linking data from the master
worksheet. So when i edit the master worksheet it edits the other
worksheet simultaneous. For example rows 5,15,70,100 belongs to
catagory1 being worksheet2 and rows 10,50,200 being another catagory as
another worksheet and so on. Different rows will make up 6 catagories
in turns 6 worksheets.
I have tried using paste link but i loose formating and in blank cells
it introduces zeros.
How can I copy/link data from master worksheet to the catagory
worksheet? I also want to copy the formating of the cells/rows. Is
there any formulas or macros to do these?
Any help is greatly appreciated.
Thanks

-Shah

0
phools (4)
4/10/2006 9:32:26 PM
excel 39879 articles. 2 followers. Follow

0 Replies
361 Views

Similar Articles

[PageSpeed] 21

Reply:

Similar Artilces:

Mail format
If I attempt to send HTML mail, recipients outside our corporation receive the message in rich text format. Other doesn't have that problem. What settings should I check? ...

Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...

How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...

Avery label format to landscape.
I would like to change the format for Avery label # 5164 from portrait to landscape but the option is grayed out. Create a text box that will fit, rotate it clockwise 90�, create your label, rotate it counterclockwise (or anti-clockwise) 90�. Ta dum -- JoAnn Paules MVP Microsoft [Publisher] "wpgmb" <wpgmb@discussions.microsoft.com> wrote in message news:14388E9C-EF0E-42FE-B54F-F1786D72851E@microsoft.com... >I would like to change the format for Avery label # 5164 from portrait to > landscape but the option is grayed out. ...

Formatting Text in a Forwarded Email Message
Odd problem in Outlook on one of our pc's. We are using Outlook 2002 SP3. When attempting to forward a message, I sometimes change a few of the words in the body of the message. I place the cursor within the word I wish to change. As soon as I type one letter, any letter, the letter shows up two font sizes bigger (from 12 to 14), and with a space on each side of the inserted letter. What seems to make this more puzzling is that when I attempt the same task on our other pc, everything functions as it should; no change in font size and no extra spaces. Any help in eli...

Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...

custom format
I need to custom format my Y axis the only on the top number of the scale to appear with the $ sign and the rest of the numbers #,###. Thanks You could use one of the axis label tricks that Jon Peltier explains here: http://www.peltiertech.com/Excel/Charts/ArbitraryAxis.html John Knoke wrote: > I need to custom format my Y axis the only on the top number of the scale to > appear with the $ sign and the rest of the numbers #,###. Thanks > > -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html A simpler solution is to change the ...

Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <Matthews@discussions.microsoft.com> wrote in message news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com... > GP Ver 6.0. Recently I...

My format toolbar dissappeared and won't come back... Outlook 2003
I don't mean, grayed out. I mean not there. HTML, Rich text, doesn't matter. Any ideas? Is it turned off or actually deleted? Did you try resetting toolbars? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newslette...

Managing multiple worksheets 03-24-10
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I regularly create files with 50+ worksheets with interlinked references - mostly historical and projected financial statements. Is there anyway possible to group files in a folder in the tab bar at the bottom of the sheet for ease of navigation? For example, can I group together all worksheets for 2009, 2010 etc in separate folders that can be expanded or contracted for ease of navigation? <br><br>Thank you On 3/24/10 12:16 PM, dad4peanuts@officeformac.com wrote: > Version: 2008 Operating System: M...

Book1
C:\Program Files\Microsoft Office\Office10\XLStart\Book1.xl -- mdalb ----------------------------------------------------------------------- mdalby's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=705 View this thread: http://www.excelforum.com/showthread.php?threadid=26311 The template should be named Book.xlt, not Book1.xlt. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "mdalby" <mdalby.1d31an@excelforum-nospam.com> wrote in message news:mdalby.1d31an@excelforum-nospam.com... > >...

Worksheet protection problem
I am using Excel 2000, wanting to protect certain cells, but allow user to filter using autofilter, etc. and how would I do this? Thanks, Jayne Private Sub Workbook_Open() Worksheets("Sheet1").EnableAutoFilter = True Worksheets("Sheet1").Protect UserInterfaceOnly:=True End Sub Right click on the Excel icon next to File in the menubar choose view code paste the code Alt-Q to go back to Excel This runs every time the workbook opens. It protects the worksheet and allows users to use the AutoFilter dropdown lists. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002...

cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...

Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...

website links in IE8
Links stopped working on websites. They worked yesterday, but not today, Although those links will work on a different computer. Hi, Tools>Internet Options - Security tab, click "Reset all zones to default" PS. Its a good idea to leave your IE Security zone settings at their 'default'/'factory' settings instead of changing them in the hope of getting some web features working on individual sites. Adjust security for web sites by either adding them to the Restricted or the Trusted Sites Zone. Regards. "fjs69xr7" <fjs69xr7@discussio...

Link Error
Hi! All, I have added the "afxcmn.h" to get the "CImageList" type to do some graphical interface enhancements. The Programs compile fine, but I run itnot Problems during Linking.. I know this is not the Forum, but if something is obvious , please do point it to me. this is how I added it to my 'StdAfx.h' #ifndef _AFX_NO_AFXCMN_SUPPORT #include "afxcmn.h" #include "afxcview.h" #endif #include <windows.h> #include <stdio.h> #include <atlbase.h> #include <commctrl.h> #include <richedit.h> #include <t...

Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...

Link Errors __endthreadex and __beginthreadex
I've started to teach myself Windows Programing with Visual C++ 6.0 with SP6. I'm using "MFC Programing from the GROUND UP" second ed. Copy his examples into a new proj. with new workspace set for an empty win32 application. They compile with no errors but I have Link Errors on "unresolved external symbol __endthreadex" and unresolved external symbol __endthreadex" and __beginthreadex. What am I missing? Thanks for any help forthcoming. you forget to enable support of MFC dll in your project, Enable it from following location Project|setting or pres...

Linking text to style for auto update
I want to auto update figure/table number in text to that in Figure/Table style numbers Use Insert > Cross Reference to put the numbers into the text; they don't update every time the numbering changes, but only when you tell them to (Ctrl-A, F9) or when you print or switch to Print Preview. On Dec 18, 4:05=A0pm, Taurus <Tau...@discussions.microsoft.com> wrote: > I want to auto update figure/table number in text to that in Figure/Table > style numbers ...

Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...

Count invalid data entries
I am using the following macro to identify invalid data entries in cells with data validation applied. Sub CheckOrder() ' Application.CommandBars("Formula Auditing").Visible = True ActiveSheet.CircleInvalid Sheets("Configuration").CircleInvalid Sheets("Parts_TakeOff").CircleInvalid MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) & " Configuration and Parts_TakeOff Sheets") End Sub Is there a way to count the number of invalid data entries (red circles) and write the number to a particular ce...

Can't link a graphic?
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC Email Client: pop I've been told on this forums several times that one cannot have a graphic with live link in your email signature. <br> Still, I've recently received a few email with small buttons that link to facebook and myspace in Entourage. How are these folks achieving this? thanks. kevs12@officeformac.com wrote: > Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power > PC Email Client: pop I've been told on this forums several times that > one cannot ha...

Changing Worksheets
Is anyone aware a keyboard shortcut that will allow you to 'move' from one worksheet to another within the wame workbook. I'm looking for something similar to the ALT+TAB used to to 'move' from a active window to a different window. Hi CTRL+PGUP CTRL+PGDOWN -- Regards Frank Kabel Frankfurt, Germany Adam Eichenberger wrote: > Is anyone aware a keyboard shortcut that will allow you > to 'move' from one worksheet to another within the wame > workbook. > > I'm looking for something similar to the ALT+TAB used to > to 'move' from a...

forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view. All the tables, queries, and macros are there. When I open up the database to add data, all the forms are there and can be used. The data is stored. So, it seems that the forms are still there, but just cannot be seen in design view. The database, when I open it up in design view, says Access 2000 file object even though I am using Access 2003 - could that be the problem? Thanks! You cannot open an entire database in Design View. Try opening it normally, selecting a form, and choosing Design View from the V...

can't move chart to new worksheet
I am creating a an embedded chart and then move it to another worksheet that would contain all my charts. After I create the chart I want to move it to another sheet. here is my code: ActiveSheet.ChartObjects("chart1").Activate ActiveChart.ChartArea.Select ActiveWindow.Visible = False ActiveWindow.WindowState = xlNormal ActiveWindow.WindowState = xlMaximized Sheets("charts").Select Range("A1").Select ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)", Link:=False _ , DisplayAsIcon:=False It gives me an...