+ Reply to Thread
Results 1 to 8 of 8

One spreadsheet requiring 3 different outcomes

  1. #1
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    One spreadsheet requiring 3 different outcomes

    Hi Guy & gals,

    I have 3 different spread sheets (all need to be independent of each other) that have data that needs to be cut & pasted in different columns and or modified please see the attachments as I have shown the original and the desired result

    if you have any difficulty interpreting them just let me know

    Thanks
    Robin
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: One spreadsheet requiring 3 different outcomes

    Hi,

    Re the #1 file is the End Result the only detail required or do you really want the intermediate sheets which appear to be working sheets?

    You can probably get to the End result with functions on the Original File sheet only and avoid the macros and intermediate sheets.
    However We'd need to understand why for instance SKU115540 only results in a string with the two sub elements when there are three ...401/402/403 ditto with SKU 020699 where there are 7 sube elements but you only show 6.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: One spreadsheet requiring 3 different outcomes

    Hi Richard,

    the SKU ?????? some have upto 12 images I only need to copy 6 but if they are less than 6 all to be copied (eg: 1 only 1 copied/ 2 only 2 copied / 12 only 6 copied)

    Thanks for your reply
    Robin

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: One spreadsheet requiring 3 different outcomes

    Hi,

    That doesn't address the SKU115540 where there are 3 rows on the original data sheet but only two elements in the end result single cell string.

  5. #5
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: One spreadsheet requiring 3 different outcomes

    Bump it up

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: One spreadsheet requiring 3 different outcomes

    Quote Originally Posted by RobinPrice View Post
    Bump it up
    ........????

  7. #7
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    Re: One spreadsheet requiring 3 different outcomes

    How do I delete this thread as I have put some thought into it as per your recommendations & it looks good

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: One spreadsheet requiring 3 different outcomes

    Hi,

    In the interests of the forum and the benefits of others, if you have worked out a solution you should mention the solution here and then mark the thread as SOLVED. We don't as a matter of course delete threads just because you have a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Desperately requiring help with my excel spreadsheet
    By jase03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2014, 08:01 PM
  2. Web Query requiring manipulation
    By batjl9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2014, 05:25 AM
  3. Formula requiring three actions
    By rraymond in forum Excel General
    Replies: 7
    Last Post: 05-27-2011, 04:50 PM
  4. requiring a field
    By cherrynich in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2006, 05:04 PM
  5. Formula requiring two different criterias
    By MJMP in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-01-2005, 07:06 PM

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