notice

I have the following in which i want to populate a notice using more than one formula, sorry my knowledge does not stretch to more than one formula :( I hope I have explained easy enough as below Any help would be much appreciated. Thank you <tbody> A B C D E F G H I J K L M N O Date...

There are headers in the top row for all columns. There are no gaps between columns. Columns A, B and C are frozen. I put autofilter on and it's fine. Then sometimes after I have been merrily using the spreadsheet for a while I notice that columns A and B are not in the filter. This is...

Hi All, I have a sheet that keeps track of tenants and their status. Data is kept on multiple sheets. I would like to have a pop-up come up requesting a date when the status of an entry in is changed to "notice" in table named tblTenants and the date is populated on in table tblUnits for the...

So I added this code below to my other codes that initiate. It all worked well until this one was added. What I do is have a button on a sheet that will launch Userform1 on the first workbook. Then a second workbook will open and extract data as appropriate, but on this one sheet I am getting...

I have a macro that performs the following function: Range("L2").Formula = "=VLOOKUP(C2,'152083'!B:C,2,FALSE)"Range("L2", "K" & Cells(Rows.Count, 1).End(xlUp).Row).FillDown Range("L:L").Copy Range("L:L").PasteSpecial xlPasteValues Application.CutCopyMode = False The problem, row 1 has a...

Hello all, this is my first post. Sorry if I violate any norms or post a question previously answered. I have multiple worksheets in a workbook that contains tenant information for apartment buildings. On those worksheets, I note a status for each tenant (occupied, vacant, or notice). I would...

Hello, I am trying to make a formula that lets me know when an employee needs to have time off (by law there is a maximum amount of hours they can work in an eight week work period). There are different values for different shifts: Day: 9 hours Evening: 9 hours Night: 7,5 hours Free: 0 hours...

Hi, I just got excel 2016, and notice the difference in movement when a cell is highlighted. How do I change this back to the original? Just curious are there any major differences I should notice? Thanks!

I recently discovered the absence of the normal notification sound when opening an excel file that requires update links to be administered. This is the one which says in the notice the following: This workbook contains links to one or more external sources that could be unsafe. If you trust the...

Has anyone used Alpha Advantage APIs with excel for importing live stock prices? Yahpoo seem to have dumped their API with no notice and saw this mentioned in a thread as an alternative.

The E4 SUMPRODUCT total shows 46 upon being entered. Can someone tell me mathematically how Excel got there since the arrays are different dimensions? Notice I changed the , to a * sign. Thanks.