please

  1. D

    Referencing Cells from a Separate Work Book, but NOT Cell Position

    Hi Everyone! What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is. I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...
  2. D

    Overriding Conditional Formatting Color with Manual Entries of a different color

    Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...
  3. P

    VBA Cut a row based off of the data in a cell and paste it into a table on another sheet.

    Hey! Hoping for some help once again. I have a table that tracks my rentals: Job Number: Job Name: Equipment rented: Employee: Company Rented from: Rental Start Date: Length of rental Estimated Due Date: Date Returned: Returned By: Total cost of the rental: Rental Complete Scissor...
  4. P

    VBA open excel workbooks (without them popping up), and then copying one line item to a master sheet.

    Good Afternoon, Hoping for some help here, I clearly don't know what I am doing. Here is the goal: To update my master spread sheet. I am trying to implement a new project tracker, this will be an excel sheet, named exactly the same thing, for EVERY job. It has a table in it on a hidden...
  5. P

    VBA Open Excel Sheet in email attachment daily

    Hey! There seem to be quite a few topics on this, but I don't know why I cant get it working, I don't seem to understand something. https://www.mrexcel.com/board/threads/open-only-excel-files-from-outlook-folder.1194964/#post-5829313...
  6. P

    Send an email when a cell says something specific

    Hey! This forum has been a huge help thus far, and I am coming here again with a potentially tough one. Here's what I would like to do: When a cell says the word "Active" or "Service Active" it sends my coworker an email letting them know to add it to quick books. Here is what it looks...
  7. S

    How to get the best of 3 choices according to the highest number?

    Can i check how do i get the final choices from this table to the second table? Employee Name Attendance Percentage Choice1 Choice2 Choice3 Alan 75.09333333 Project 1 Project 3 Project 4 John 73.37 Project 1 Project 4 Project 2 Alan 73.15 Project 3 Project 5 Project 6 Chris...
  8. A

    Transfering rows to one sheet from multiple sheets under condition.

    Hi! I'm not that good at doing macros but, if you are, that should be a child game! All I want is to have the datas from my inventory sheets to be copied into the corresponding sheets "To Order" or "In Stock" depending on the values enter in the other sheets,. If the numbers in column To...

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