thank you

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...

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...

Good morning. I found few post related to my question but none of the solutions worked for me (Maybe I did something wrong) I have a long list (100') of webpages (https) and I need to update some of the content they may have. So, I wanted a macro that takes all addresses from column A...

Is there a way to highlight all duplicate cells while ignoring empty cells? I have my data in s12:y31 THANKS in advance!

If I add a new column A, that changes all of my other formulas. Is there a way to add a new column (every 2 days) and have it add the new column in the formula? Example. I have in M2 a formula: =COUNTIF(A$2:C$30,L2) But, when I add a new column A, the new formula will be =COUNTIF(B$2:D$30,M2)...

I have dates in w24 (start date) and w26 (end date) with the resulting math taking place in w28. Easy enough. The issue is I need to not calculate the weekends. I tried the workday function, but that isn't what I am looking for... Any ideas?

I am in need of a Macro that allows me to copy a column of 150 lines and paste only it's values in a separate worksheet in the same Workbook. Currently I have: Sub GroceryDispatchColumnCopy() Sheets("Grocery Dispatch").Select Range("E3:E150").Copy Sheets("Sheet1").Select...

Using Excel 2013 on current Windows: I need to copy an entire table ("Table1") and paste it to a range starting in "I2". I've tried ActiveSheet.ListObjects("Table1").Range.Copy ("I2"). It doesn't work. I can't paste the values only because I need to use and alter the formulas later. I've...

Hi, I am currently using the below formula to find the value in my table: {=IFERROR(INDEX($D$45:$D$404,SMALL(IF($B$19=$A$45:$A$404,ROW($A$45:$B$404)-MIN(ROW($A$45:$A$404))+1,""),ROW(A2))),"")} A dropdown list is contained in cell b19, there are others in cell b25, and b11. I need this...

I am new to using excel and was hoping someone would be able to help. I am wondering if there is a way to scan a barcode into excel and the have excel recognise it and count how many times the same barcode had been scanned. So basically have 3 columns Barcode, Product name and Quantity.

I have data that comes in at variable lengths in terms of rows and want to have the macro insert a Totals row. The problem I have though is I can't get the sum formula to start from the top and go down through the bottom. If you can help me with this, I'd greatly appreciate it! Thanks!