Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Jul 2002
    Location
    Winnipeg, Manitoba
    Posts
    40
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Move text in column to another spreadsheet, if row contains data

    Think this should be simple, and likely I'm over thinking, but since I don't dabble in Excel on a regular basis, thought I'd ask.

    Have a spread sheet that contains names in two columns (alongside a bunch of other columns)Column B lists voting delegates, - note: Not all rows contain data, Column C lists Presidents. I want to move the list of voting delegates to another spread sheet, but if there is no voting delegate listed, I'd like the President to be moved to the other spreadsheet as the voting delegate. Does that make sense. Just having a tough day today thinking things through.

    Any help is appreciated.

    Thanks
    E. Fred Schneider
    someone who knows just enough to get themselves into trouble
    Winnipeg, Canada
    fred.schneider@sportmanitoba.ca

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Can you post a sample file of what you have and what you want.

    Steve

  3. #3
    Lounger
    Join Date
    Jul 2002
    Location
    Winnipeg, Manitoba
    Posts
    40
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by sdckapr View Post
    Can you post a sample file of what you have and what you want.

    Steve
    Hope this helps

    Thanks
    Attached Files Attached Files
    E. Fred Schneider
    someone who knows just enough to get themselves into trouble
    Winnipeg, Canada
    fred.schneider@sportmanitoba.ca

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In D2:
    =IF(ISBLANK(B2),C2,B2)

    Copy the formula down the column. You can copy the range and paste-values to a new location if desired.

    Steve

  5. The Following User Says Thank You to sdckapr For This Useful Post:

    derfacanuck (2011-11-25)

  6. #5
    Lounger
    Join Date
    Jul 2002
    Location
    Winnipeg, Manitoba
    Posts
    40
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thanks... works perfectly and I even understand what it is doing so was able to modify to move results to another spreadsheet.

    Thanks again.
    E. Fred Schneider
    someone who knows just enough to get themselves into trouble
    Winnipeg, Canada
    fred.schneider@sportmanitoba.ca

  7. #6
    Lounger
    Join Date
    Jul 2002
    Location
    Winnipeg, Manitoba
    Posts
    40
    Thanks
    6
    Thanked 0 Times in 0 Posts

    mystifying problem of disappearing data. Any help appreciated.

    Have run into a problem with this that is mystifying. On test data, there are no problems. In the original data, when the formula is "run", the result does not include the President's name as the voting delegate as it should. The data is there in the original spreadsheet; when you use evaluate, it shows the correct name; but the result is a blank on the final spreadsheet. Voting delegate is "moved" as it is supposed to. Any suggestions from anyone on why the result ends up blank?
    Note: I've been told the data was originally imported from an access database. I'm not sure if that may have an impact.

    see attached.

    formula is in column BA
    Attached Files Attached Files
    E. Fred Schneider
    someone who knows just enough to get themselves into trouble
    Winnipeg, Canada
    fred.schneider@sportmanitoba.ca

  8. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Use:
    =IF(AD2="",J2,AD2)

    None of the cells are blank in AD, they only look blank. The contain "null strings" (zero length strings)....

    Steve

  9. The Following User Says Thank You to sdckapr For This Useful Post:

    derfacanuck (2011-12-01)

  10. #8
    Lounger
    Join Date
    Jul 2002
    Location
    Winnipeg, Manitoba
    Posts
    40
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Perfect. thanks. Is the reason they have null strings due to the fact the spreadsheet was imported from access?

    I really appreciate your help. Slowly learning my way around various office components. I'm one of those that knows just enough to get myself in trouble. I'm very appreciative of the fact that there are individuals, such as your self that are prepared to assist and help others learn. The lounge is a great resource thanks to all of its contributors, both those that answer and those that ask questions.

    Once again.

    T H A N K S
    E. Fred Schneider
    someone who knows just enough to get themselves into trouble
    Winnipeg, Canada
    fred.schneider@sportmanitoba.ca

  11. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I suspect that since it was a database and the field was set for "text" that it could not be blank and a null was entered.

    And you are very welcome, I am glad that I could help.

    Steve

Posting Permissions

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