-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
link worksheets
-
U
Pasting links between workbooks but ignoring blank cells
Is there a way to copy/paste links from one workbook/worksheet to another but ignoring blank cells in the source so that the destination does not display ####### content for the linked blank cells? This requires cumbersome, tedious and a great deal of time to "clean-up" the linked blank cells...- USAOzi
- Thread
- blank excel 2016 ignore blank cells link worksheets
- Replies: 3
- Forum: Excel Questions
-
Formula for linking worksheet needs modification for it to work
I am unable to discern where i am going wrong ! :confused: Any help given is appreciated,I started with Name manager...- sleek12
- Thread
- link worksheets maxa$3a3+1 sheet
- Replies: 0
- Forum: Excel Questions
-
J
Update source location of linked data using string in formula & values worksheet
First thread, please help! I have a massive workbook that I have linked with several other workbooks on a network drive. I have the following formula: ='M:\Financial Aid\John''s Stuff\Win-Loss\[Grids 16-17.xlsx]NEW (FR&TR)'!$D7 This allows me to pull data from that spreadsheet into my current...- john316swan
- Thread
- concatenate formula link workbooks link worksheets
- Replies: 3
- Forum: Excel Questions
-
D
How to link cell contents from one cell, and also link background color from another cell and all link to new cell?
Hi there, i am still quite new with excel. I have excel 2010. I know how to link columns between worksheets but what i want to do is link a column of contents from one worksheet (e.g. WS1) to a column in another worksheet (e.g. WS2). But also i want to link a column of varying background...- Danalexander
- Thread
- cell layers link cell formats link colors link columns link worksheets
- Replies: 1
- Forum: Excel Questions
