sheets2

  1. A

    Lookup formulas in specific columns

    Hi Everyone I have two spreadsheets. Sheets(1) is with unknown number of columns and rows. Sheets(2) is a list of profiles and rates. I need to look up the specific rate in Sheets(2) for the specific profile in Sheets(1). In Sheets(1), there are headings for 'Profile', 'Cost' and 'Rate'...
  2. T

    Allow user to enter a new row with replicated data in a protected sheet

    Hi All, i am not the best at this coding but i do try, I have been playing around with the folllowing code which works but not the way i wish, it pastes the data into the top of the workbook instead of the bottom. Is there a way of allowing the user to click on the button and then paste the...
  3. H

    Compare Lists and Copy Duplicates

    Hi - I found a few threads on this topic, but I'm struggling. I have 2 lists, Sheets1 Column A and Sheets2 Column B. What i'd like to happen is if the item on Sheets1 appears on Sheets2, then copy the whole row (columns A:E) to Sheets3 A6. I would be running this code mutliple times so if i...
  4. E

    remove uniques between sheets

    Hello, - Sheets(1) column F from F2 to FXXX has some numbers - Sheets(2) column E from E2 to EXXX has some numbers I need to remove all rows in Sheets(2) based on those numbers (E) that are not present in Sheets(1) (F) Please Help with VBA Best Regards W.

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