Type: Posts; User: jlkirk; Keyword(s):
Thanks Geek. I suppose I could, but that would take quite a while given > 50 links. I would think there would be some VBA guru out there that may have an answer...
The external links are data links to other Excel files;
I would like to print them to a new worksheet in the file that has the links embedded;
Update to all of their values = instead of a link,...
Thanks Martin, but that's not quite what I was looking for. I would like to list all of the links on a new spreadsheet, and then convert all of their links to their values.
I have a file with > 50 external links .. What I would like to do is print all of these external links on a worksheet, and update them all to their values.
Thanks in advance.
I have a file that is linked to >50 external links. What I would like is a macro that would convert all of thos links to their values in the file I have open. Any ideas?
Rows a1-a143, I have a master list of contract numbers. In rows g149-g179 I have another list of other contract numbers, some that may or may not be on the master list. What I would like to do in...
How do you remove the "Page x" "watermark" from a worksheet in Page Preview?
I have a file that contains "Sumif" formulas that link to an unopened file. Whenever I open the file that contains the "Sumif" formulas first, without having opened the "source" file (i.e., the file...
Thanks Charles, works great!
I converted a pdf document to Word, and throughout the document, the program inserted a small "o", superscript, before each word. Any way I can get rid of these?
Thanks in advance.
I have a master list of contract numbers in column A (>500). In column B, I have listed the names that correspond to the contracts in column A. In column C, I have a list of the contracts utilized...
Sorry, should have been "footers"
I saved a document with several footnotes into a .docx, then .docm format. When I reopened it, the footnotes appeared as part of the body text, and not in headers. Any ideas?
Thanks to all. Sorry, Steve, I was under the gun on a deadline...
Thanks Jim. Yes, I know how to do it via the Header/Footer route, but would prefer my way, if at all possible!
I have a worksheet that is made up of 5 pages. In the cell located at Row 3, Column M, Page 1 I currently have the text "Page 1 of ___", and have Excel repeating Rows 1-5 of Page 1 on each...
Column A, Rows 1-10, Worksheet 1 are the letters A-J. Column A, Rows 1-10, Worksheet 2 are the letters A-J, Column B, Rows 1-10, names of clients. What I would like to do on Worksheet 1, column C,...
Just installed Excel 2010, and the "Developer" tab vanished. How do I get to my macros?
For whatever reason, it is not working for me. For example, whenever I modify, say Heading 1, to Times New Roman old, 12 pt., 1/4 inch indent with a 1/2 inch hanging first line, when I try and use...