+ Reply to Thread
Results 1 to 42 of 42

Link Strikethrough To Matching Number On Second Sheet

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question Link Strikethrough To Matching Number On Second Sheet

    Hey people,

    I have two sheets in the attached workbook, Sheet A and Sheet B. Both sheets get job numbers assigned to them manually by the scheduler.

    This is what I'm looking to have happen:

    When any worker in Station 1 through 10 is done their part of the job number, they open the workbook, find the number in their station row on Sheet A, and double-click it to have it strikethrough. Excel then checks the cells to the right of the one that was just stroked through for any more instances of the same number, and if it finds any, nothing further happens.

    If there are no more occurrences of the same number in that station (some stations have more than one row), then Excel finds that number that was just stoked through on Column B on Sheet B; then marks an X and colours the cell red to the right of that number, in the column that corresponds with the station from Sheet A.

    Yikes, I hope that was clear. The attached workbook should help clarify. How can I do this?
    Attached Files Attached Files
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

  2. #2
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Does this make sense to anybody?

  3. #3
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    hi there, it looks something is missing here:

    Excel then checks the cells to the right of the one that was just stroked through for any more instances of the same number, and if it finds any, nothing further happens.

  4. #4
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Well, if there is another instance of that number that just got the strikethrough for that Station, then nothing should get stroked out on Sheet B. The last instance of any number for each Station is the one that needs to trigger the red X on Sheet B.

  5. #5
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    can you provide example for a particular station with explanations. I'm not sure I understand everything till the end

    Example1: Station 3, cell AH7, value 26076 - gets stroken. What else happens and why?
    Example2: Station 6, cell AH10, value 26075 OP 1 - get stroken ...
    Your example that is not covered by these two examples.

    Do we look for the whole match: 26076 = 26076 or match in part: 26076 = 26076 OP1?
    Last edited by watersev; 03-29-2012 at 05:11 PM.

  6. #6
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Alright, no problem:

    Example1: If Value 26076 in Station 3, Cell AH7 gets stroked, nothing happens on Sheet B because there is another Value of 26076 in Station 3 in Cell BR7. In fact, nothing happens until Cell CH7 in Station 3 gets stroked out, and since that is the last one, Station 3 is now finished with this number, so Cell H67 on Sheet B gets X'd. I have no idea why it is already X'd, I'm sorry about that, I just took the current setup and didn't check it through as thoroughly as I should have, due to the huge amount of numbers. This is also why I'm asking for the solution, as right now, it's too easy to have one sheet out of sync with the other.

    Example2: It doesn't matter if there is a description or something after the number, the code just needs to check for the first appearing number (if it says 26075 OP1 then it would just use the 26075) or sometimes a number with a dash and another number (like 26006-1, so if there was a 26006-1 BEGINNING, it would use the 26006-1) and look for matches from there. Even if the same number appears again with a different description after it for the same station, only the number matters, so the last one would be the one to trigger the X.

    If you have any more questions, I'll be more than happy to answer them. Thank you!

  7. #7
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    please check attachment, double-click the job to mark it completed with strokenthrough font. If nothing happens, run code "EnablEvents" and try again.
    Attached Files Attached Files

  8. #8
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    watersev, you are amazing. I am currently running tests, and so far, it seems to work very well, better than I had thought. Thank you!

    I did have one user make a suggestion, and that was whether it would be possible to have the procedure reversible in case someone stroked out the number for the wrong station, which apparently does happen from time to time. I said I would ask, so basically, if a user double-clicked the cell again, after it had already received the strikethrough on Sheet A and was X'd on Sheet B, then a message would pop up asking if they would like to change the job back to uncompleted, and if Yes, then it would un-strike as well as un-X on Sheet B, if of course it was the last occurrence of that number for that Station.

    What do you think?

  9. #9
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    please check attachment
    Attached Files Attached Files
    Last edited by watersev; 03-30-2012 at 10:56 AM.

  10. #10
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Thank you again, watersev! That is almost working perfectly..

    If I double-click the last instance of three unfinished jobs in a row in a station that has more than one row (like Stations 1, 8, 9, and 10), I get the error message saying there are uncompleted jobs to the left of it, which is great, but upon clicking OK, I now have two bugs - the first is when I go to the first job and double-click it, it X's it out on Sheet B. Un-stroking it again doesn't un-X Sheet B either. The second bug is if I go ahead and stroke out all of the three jobs, then I can go back to the first job and un-check it without error messages. I'm not sure why this is, but this doesn't happen to any of the one-row stations.

    I also notice that if I have three of the same jobs for a station that isn't all one row (like Stations 1, 8, 9, and 10), double-clicking the furthest-to-the-right number before the others are done is allowed - it shouldn't be. This only occurs if the other job numbers to the left of it aren't on the same row.

  11. #11
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    may I have job numbers giving those errors?

    I've spotted a cell with the following value: 26114 - 26119 + 26025 - 26028. It would cause a problem to deal with it.

  12. #12
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    That cell contained an entry mistake - that won't be happening. Each job will get it's own cell.

    I just created my own job numbers on Sheet B, and then entered them in Station 10 fields, and upon running those tests that I described above ran into those problems.

    I'm currently creating an updated sample, as I had a good chance to test it today. It should make things a bit easier to work with. I'll attach it shortly.
    Last edited by swordswinger710; 03-30-2012 at 03:29 PM.

  13. #13
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Okay, here's our current setup, with your latest code.

    If I double-click the last instance of three unfinished jobs in a row in a station that has more than one row (like Stations 1, 8, 9, and 10), I get the error message saying there are uncompleted jobs to the left of it, which is great, but upon clicking OK, I now have two bugs - the first is when I go to the first job and double-click it, it X's it out on Sheet B. Un-stroking it again doesn't un-X Sheet B either. The second bug is if I go ahead and stroke out all of the three jobs, then I can go back to the first job and un-check it without error messages. I'm not sure why this is, but this doesn't happen to any of the one-row stations.
    Check out the green cells on the Process Schedule (formerly called Sheet A), job number 12345.

    I also notice that if I have three of the same jobs for a station that isn't all one row (like Stations 1, 8, 9, and 10), double-clicking the furthest-to-the-right number before the others are done is allowed - it shouldn't be. This only occurs if the other job numbers to the left of it aren't on the same row.
    Check out the blue cells, job number 11111-1 for this one.

    I also found out that the cell formerly known as Station 10 is going to be called Shipped, and asked if, when a number gets stroked out there, it could enter the actual date it was stroked out into the appropriate cell under the Shipped column on the Open Orders Sheet (formerly Sheet B), and colour the whole row red. Check out job 22222 for this example. Only one instance of any number will be entered on the Shipped row on the Process Schedule sheet. I'm sorry I didn't know about this any sooner.
    Attached Files Attached Files

  14. #14
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    please check attachment

    If nothing happens on double-click, run code "EE".
    Attached Files Attached Files

  15. #15
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Thank you so much for your continued help, watersev. The green cell bugs have been fixed wonderfully. The blue cells are still giving me problems, though:

    I start by right-clicking Cell X12, choosing Format Cells, Font, and then unchecking Strikethrough. Now we can test them properly. If I double-click that same cell now, it strikes out and updates the Open Orders - which it shouldn't yet, as there are those two blue cells to the left of it. If I try to unstrike it, then I get the error message saying that there are uncompleted jobs before it.
    If I unstrike Cell X12 again, then double-click Cell R14, then upon double-clicking Cell T14, it gets stroked out on the Open Orders sheet. It shouldn't yet though, as Cell X12 is not yet stroked through.

    I'm also having issues with the Shipped jobs. I'm unable to double-click the cells in the Shipped Column (Cell AG19). That is when today's date needs to be entered in the Shipped row on the Open Orders sheet and the row coloured red. Right now, that is being done when a job is marked as completed for any station(Cell M8).
    The cells in the Shipped Column need to work in a similar manner as the cells in the other columns do, but in this case the number can't be stroked out in the Shipped column as long as there is any other unstroked instance of it anywhere on the whole Process Schedule sheet; and it should also erase today's date and uncolour the cells it coloured on the Open Orders sheet if gets unstroked.

    We could just work on fixing the blue cell bugs first, if it's simpler; but let me know what you think.

  16. #16
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    Re: error in blue cells, please check attachment
    Attached Files Attached Files

  17. #17
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    And the blue cell bug is fixed! Everything seems to be working beautifully now, thanks to you; so now there's only our Shipped issue:

    I see that you've set it up to mark today's date and colour the row once a job for a station has been completed. If the job for the station gets unchecked again, then it undoes that on the Open Orders sheet. We just need to change that to have it happen only when a number on a Shipped row on the Process Schedule gets double-clicked and stroked out. This is also important - the code needs to make sure that any number being stroked out on a Shipped line is the last un-stroked copy of that number on the entire worksheet.

    See number 22222 on your last attachment for the example - it's been stroked out in the Shipped line (and was allowed to be, since all other instances of 22222 have already been stroked out) and it marked today's date in Cell Q4 on the Open Orders sheet, and coloured the whole row red.

  18. #18
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    can you explain this part for me:

    This is also important - the code needs to make sure that any number being stroked out on a Shipped line is the last un-stroked copy of that number on the entire worksheet.
    If you make reversal action click on a stroken number in Shipped line means that it has to be the last stroken number on the sheet, right (all other instances have been already unstroken)? If it is - update Open Orders - delete date.

    If you make reversal action click on any other line we just delete X on the Open Orders sheet.

  19. #19
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Those are good points which I didn't think of. This is how it needs to work:

    Every job number in Column B on Open Orders will also be in the Shipped row on the Process Schedule. Those jobs in the Shipped row indicate the last operation of the entire job. Once a number in here is stroked out, it means the whole job is done, which is why it cannot be stroked out unless all other instances of that number are already completed/stroked out for every other station.

    If a job needs to be reversed anywhere on the Process Schedule for any reason once it's been stroked out in the Shipped row, it will need to be un-striked from the Shipped row first (which will delete the date and uncolour the row from Open Orders).

  20. #20
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    please check attachment
    Attached Files Attached Files

  21. #21
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    I'm getting a 'Variable not defined' error message when I try to double-click any cell, and this line of code is highlighted:

    Please Login or Register  to view this content.

  22. #22
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    sorry, add this to the Dim line:

    Please Login or Register  to view this content.

  23. #23
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    No problem at all, that fixes that error message. We are much closer now, I only see one remaining bug:

    If you'll open the attachment, you'll see that job 11111-1 has been completed for it's assigned stations, but not yet stroked out on the Shipped row on the Process Schedule. When I stroke it out, the Open Orders sheet gets the date and colours the whole row beautifully. But now, if I go to Cell AD16 on the Process Schedule and double-click it, it reverses to uncompleted, and the row gets un-coloured and the date deleted from the Open Orders sheet. I should not be able to do this, as Cell AG19 on the Process Schedule still claims that the entire job is complete. I need a message to inform the user that if they want to make changes to completed jobs in the stations after the Shipped job is marked as completed, they'll need to un-stroke it in the Shipped line first, and then they can reverse the station jobs.

    Does this make sense?
    Attached Files Attached Files

  24. #24
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    please check attachment
    Attached Files Attached Files

  25. #25
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    As far as I can see, that seems to be doing it! Thank you SO much! I have one last question:

    If I need to change/remove/add a name/station in Column A on the Process Schedule and it's respective name/station in Row 1 on Open Orders, what would I have to change in the code in order for that to happen? I tried, but with no success.. I'll explain:

    Let's say that Station 1 refers to user John Smith, and he wants the Process Schedule name for 'Station 1' to be 'JOHN SMITH' instead, and the name 'ST 1' on the Open Orders to be 'JSMITH'. Would I be able to change those, then update that in the code somewhere?

    Also, if we had to add or remove another station, would I be able to just pop in or delete another row in the Process Schedule sheet and do the same to the matching column in the Open Orders sheet, enter or subtract the names in the code, and away we'd go?

    I couldn't figure out exactly how your code is linking the two names together, but would this be a possibility?:

    Please Login or Register  to view this content.
    ..and then have the rest of the code reference off of that? I don't know if I'm making any sense, or of this is even an option, but I would appreciate any advice you could give me. And again, thank you so much again for all your amazing help!

  26. #26
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    you need to replace this:

    Please Login or Register  to view this content.
    with this:

    Please Login or Register  to view this content.

  27. #27
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    That works great as long as the names are linked to columns with the first letter and the last name, but as I'm implementing this amazing code to our actual workbook, I'm finding that that's not always the case. I attached our scenario so you can see how this is set up here.

    You'll notice that there was some changing of station cells and names and such.. I am sorry that I wasn't aware of these requirements until today, when I was working at transferring the code to our actual workbook.

    So this is the way we'll need it to work - the rows on the Process Schedule linked to the columns on Open Orders are the same colour, and the data under the orange cells on Open Orders will be entered manually.

    I hope this isn't too much trouble to fix. Please feel free to ask if anything is not clear. Thank you again, watersev.
    Attached Files Attached Files

  28. #28
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    the easiest way would be either to keep row and column name equal or to make them match: row 4 equals to column 4 on orders sheet, row 5 to column 5 on orders sheet

    Otherwise any new entry would require code changes in part of those names

  29. #29
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Alright, I inquired about that, and that shouldn't be a problem - you may see the attachment for the new layout. Will this be better to work with?
    Attached Files Attached Files

  30. #30
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    why do not you have full names on the Orders sheet? Put them in full, turn text vertically or whatever. Otherwise the code or the sheet has to have table for corresponding references that should be updated upon changes accordingly.

  31. #31
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    We weren't using the full names on the Open Orders sheet for pure aesthetic reasons, basically. The cells become too wide/tall to view and print properly, for example. I would definitely go that route, otherwise.

    There can be a table for the code? That would be amazing! That way, if something does get changed, I can just update the table - I think that's our best choice. Changes won't be happening very often anyways. What would be easier for you, a table in the code, or a table on a hidden sheet in the workbook?

  32. #32
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    please check attachment
    Attached Files Attached Files

  33. #33
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    This is great! I am really getting excited here.

    I'm not sure why, but now when I double-click Job 11111-1 in the Delivery Date row, it strikes out regardless that the Final Inspection row still has some unstroked 11111-1's, and the Shipped column gets marked with a red X instead of today's date - when I try to unstrike it, I get an error message. I'm thinking this is just a name change issue in the code somewhere, but I was unable to find it.

    Other than that, it is looking really, really good, and I am so thankful for all of your help!

  34. #34
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    change this line:

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    or instead you can place this before Option explicit line:
    Please Login or Register  to view this content.
    This will make A=A=a

  35. #35
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    That fixed most of what I mentioned, however, upon striking out the job in the Delivery Date row once it has been completed, today's date gets inserted into the Notes column on the Open Orders instead of in the Shipped column. What do I need to fix to correct that? Also, the row isn't being coloured red.. any ideas? Almost there!

    PS Check the attachment for job 99999-99 for an example.
    Attached Files Attached Files

  36. #36
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    change this:

    Please Login or Register  to view this content.
    to this:

    Please Login or Register  to view this content.

  37. #37
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Yes! That fixes it! I also had to replace the 'q' with 'p' further down the code for the unchecking thing to work, but now it's working beautifully! Thank you so so much, watersev! I'm now in the process of transferring the code to our current schedule here, and I have a quick question - where can I specify the colour of the font and the cells that get coloured when the job is complete? I've been looking for it, but haven't found it yet. We'd like to use a lighter red.

  38. #38
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    it's done through Conditional Format not VB

  39. #39
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Thank you, I've been working on that and have come across another little something - how do I tell the formula to only apply when 'X' or 'NA' by themselves are entered, and not when something like 'TERMINATION' or '12345-X' is entered? Because right now, some of the cells in columns A:E on Open Orders have those values, and they turn red because of that. Or would there be a way to specify that those columns wouldn't be checked for 'X' or 'NA'?

  40. #40
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    Would it wreck anything if I changed the 'Applies to' values from =$A$2:$Q$149 to =$F$1:$N$65536? That seems to fix it, but I don't want it to ruin anything later on..

  41. #41
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Link Strikethrough To Matching Number On Second Sheet

    CF formula example for A2:Q2:

    Please Login or Register  to view this content.
    Last edited by watersev; 04-13-2012 at 12:11 PM.

  42. #42
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Link Strikethrough To Matching Number On Second Sheet

    When I use that, it converts to the formula I just mentioned, so I guess that's a good thing.

    I have another formatting question for this same workbook which I'm asking here, but for now, I'm marking this thread as solved. There may be more things I might have to ask you if I'm unable to figure them out myself, now that this workbook is in use here. It's working very well watersev, thank you so so much for all you've done! I have some very happy users who are expressing their thanks to you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1