Search:

Type: Posts; User: jlkirk; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    13
    Views
    761

    thanks Geek

    thanks Geek
  2. Replies
    13
    Views
    761

    Thanks Geek. I suppose I could, but that would...

    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...
  3. Replies
    13
    Views
    761

    The external links are data links to other Excel...

    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,...
  4. Replies
    13
    Views
    761

    Thanks Martin, but that's not quite what I was...

    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.
  5. Replies
    13
    Views
    761

    Converting external links to 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.

    Any ideas?

    Thanks in advance.
  6. Thread: External Links

    by jlkirk
    Replies
    1
    Views
    119

    External Links

    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?
  7. Replies
    3
    Views
    173

    Thanks guys.

    Thanks guys.
  8. Replies
    3
    Views
    173

    Comparing 2 columns of data

    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...
  9. Replies
    2
    Views
    222

    Thanks Steve.

    Thanks Steve.
  10. Replies
    2
    Views
    222

    Page x Watermark

    How do you remove the "Page x" "watermark" from a worksheet in Page Preview?
  11. Replies
    1
    Views
    132

    Solved-use Sumproduct

    Solved-use Sumproduct
  12. Replies
    1
    Views
    132

    #VALUE when referencing an unopen link

    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...
  13. Thread: Delete symbols

    by jlkirk
    Replies
    3
    Views
    206

    Thanks Charles, works great!

    Thanks Charles, works great!
  14. Thread: Delete symbols

    by jlkirk
    Replies
    3
    Views
    206

    Delete symbols

    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.
  15. Thread: Lookup (?)

    by jlkirk
    Replies
    2
    Views
    132

    Thanks Steve.

    Thanks Steve.
  16. Thread: Lookup (?)

    by jlkirk
    Replies
    2
    Views
    132

    Lookup (?)

    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...
  17. Replies
    3
    Views
    439

    Sorry, should have been "footers"

    Sorry, should have been "footers"
  18. Replies
    3
    Views
    439

    Footnote Formatting Lost

    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?
  19. Thread: Page X of Y

    by jlkirk
    Replies
    6
    Views
    533

    Thanks to all. Sorry, Steve, I was under the gun...

    Thanks to all. Sorry, Steve, I was under the gun on a deadline...
  20. Thread: Page X of Y

    by jlkirk
    Replies
    6
    Views
    533

    Thanks Jim. Yes, I know how to do it via the...

    Thanks Jim. Yes, I know how to do it via the Header/Footer route, but would prefer my way, if at all possible!
  21. Thread: Page X of Y

    by jlkirk
    Replies
    6
    Views
    533

    Page X of Y

    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...
  22. Thread: Index(?)

    by jlkirk
    Replies
    7
    Views
    327

    Index(?)

    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,...
  23. Thread: Excel 2010

    by jlkirk
    Replies
    4
    Views
    495

    Thanks Guys.

    Thanks Guys.
  24. Thread: Excel 2010

    by jlkirk
    Replies
    4
    Views
    495

    Excel 2010

    Just installed Excel 2010, and the "Developer" tab vanished. How do I get to my macros?
  25. Replies
    4
    Views
    473

    For whatever reason, it is not working for me. ...

    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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4