associated data

  1. I

    How to Match a column with another sheet's column and copy paste the Entire Row&Column after the end of the columns of primary sheet?

    I have been trying to achieve this for a while. Thank you in advance for your help. This will be a script that will be based on 2 excel files: fileA and fileB (if you can't do this with different excel or sheets then consider having all date in one sheet but in different columns, obviously) use...
  2. I

    How to associate and mass edit all fields between 2 columns?

    Hello, I have been trying for a while to achieve this without any success: 1. https://www.dropbox.com/s/95crj0t58swk610/Screenshot%202015-05-28%2022.27.17.png?dl=0 in this scenario take data in B column and add them all into the field B138 with ";" separation. (example: Loop;Open Loop;Padded...
  3. E

    VBA to find the associated cell to another one which is in a different worksheet

    Dear all, I have something tricky to do in VBA and since I just started on this malarkey, I am a bit lost. My actual macro calculates what is called "Min.DR". This is calculated based on trends in sheet "QLT_SS_Input" (steady state cases). The min DR is then copied into the output tables...
    • Ealglez
    • Thread
    • associated data associative array find & return worksheet change
    • Replies: 0
    • Forum: Excel Questions
  4. W

    Rolling 26 Week (6 Month) Compensatory Time Tracker with dates and associated information that roll off based on =today() function

    I am trying to put together a Comp Time tracker for use around our office for people to track their comp time individually for salaried workers that work over 40 hours. In cell A1 is =today() so that each time the spreadsheet is opened it displays today's date. There are 4 column headings...
    • will7789
    • Thread
    • associated data rolling date rolling weeks self expiring data today function
    • Replies: 0
    • Forum: Excel Questions
  5. M

    Search for duplicates in 2 columns, return associated data

    Hello All, The best way I can think to describe this is through an example: In the example below I'd like to search for instances of entries from the first colum (Item Needed) in the second column (Item Ordered). If a match is found I'd like to have the "Item Ordered" and associated "Quantity"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top