| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 104843 | 2009-11-10 02:02:00 | EXCEL Linking Problem(new thread) | Colpol (444) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 828791 | 2009-11-10 02:02:00 | Following Sols advise I am restarting this thread, I Have a speadsheet with 5 duty rosters, each on its own Sheet. The sixth sheet is a master that includes all 5 rosters.(They are not merged just displayed one under the other). THEY DO NOT CONTAIN FIGURES ONLY NAMES, SYMBOLS AND FORMATING Is it possible to link them so that changes to any of the 5 rosters is automatically reflected in the Master in Sheet 6 Hope this makes sense |
Colpol (444) | ||
| 828792 | 2009-11-10 02:32:00 | Well mate, this ones a little different.....what you can do is just put =sheet1!A1....whatever is in that cell, should be reflected back to the cell in sheet 6.....an easier why to do it is copy the data in sheet 1 and then paste link to where you want it in sheet 6.....if the sheets in 1 thru 5 are showing data horizontally, then you can see all data at once...you get paste link from doing paste special and click the paste link button... | SolMiester (139) | ||
| 828793 | 2009-11-10 04:15:00 | Thanks for your patients Sol. Making progress. I Paste Special and paste link. Paste link only works with the "all" option but all does not copy formats, fonts or column widths. Is there a way around that? |
Colpol (444) | ||
| 828794 | 2009-11-10 04:22:00 | Right click again -> Paste Special -> Formats Right click again -> Paste Special -> Column Widths :) |
fred_fish (15241) | ||
| 828795 | 2009-11-10 04:46:00 | Right click again -> Paste Special -> Formats Right click again -> Paste Special -> Column Widths :) Thanks Fred. Getting there. Colours, column widths and fonts correct. Now all squares that do not have something in them(blank on the original) has a folder symbol that I don't want. If i try to get rid of the symbol by clearing contents, the squares loses the link. (Thank goodness for the undo) |
Colpol (444) | ||
| 1 | |||||