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...
auto
automation
cells
dates
help
inserting new rows
linking cells
linking dates
linking work books
new row
please
reference
reference books
reference cell
referencing
referencing a cell
referencing a date
referencing another work book
referencing cell from different work book
referencing date from different work book
thank you
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...
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...
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...
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...
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...
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...
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 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.