Consulting

Results 1 to 3 of 3

Thread: Solved: Updating Cell Info

  1. #1

    Solved: Updating Cell Info

    Hi

    I need to update the information in a cell. The workbook has 61 sheets and I need to change a figure in a cell in a row named Card Printer Ribbons to 67.14. My problem is that the cell is either I32 or I33, although the tiltle of the row remains the same. Is there a way of doing this without having to change each row by hand?

    To recap:

    The cells that need changing to 67.14 are either I32 or I33
    The title of the row is called Card Printer Ribbons
    There are 61 sheets

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Did you make a copy and then select all the sheets and use find/replace?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    Thanks for that Lucas, did not think of that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •