automatically

I have multiple worksheet and file which contain tables of a same format , I wish to collate all into a single table automatically and to be applied across all sheet. The number of data varies daily and it contains text only. Anybody here knows how to do it ?

I have an Excel sheet running on a big screen and would like to refresh the sheet every 1 min or so. The code below I can refresh manually but can I run a second macro or add to this on and refresh and save automatically? Thanks Sub Update() ' ActiveWorkbook.UpdateLink...

Good afternoon guys/girls! I am am new to this board and pretty much to excel so I reach out to all you experts for some very much needed help as I need this for my job role. I am recording training for staff at work and require a traffic light system for training dates, I require the...

Good Morning All, I am trying to format a sheet I have for the football team I run. I have a score sheet and want to automatically pull data from it using W,L D (Win, Loss, Draw) this data is in E21, so that I can automatically make a table showing the results. I have used the formula below...

So basically, in my excel , the drop down list of a certial cell (B1) changes based on the value of the preceding cell (A1), it works correctly, however when I move to the next row, if A2 is not = B2, then B1 value automatically changes, because the drop down list changes. Is there a way to make...

Hello, I would like to sort my data by the data in column A whenever I add new data to that column. I can easily sort the data alphabetically automatically, however I would like to sort this data by a custom order. The 4 different inputs allowed for this column are 1. keep/sold, 2. must win...

I created a Personal.xlsb file that has saved successfully but it doesn't open automatically when I open an Excel workbook. I tried checking under Add-Ins and Disabled Items, but there are no items listed. If I locate and open the file directly from the C:\ drive, it then gets added to the...

Hi All I have a spreadsheet for which I need it to do the following: I have populated all weekdays into a separate sheet, and then also added in the bank holidays until 2025. Now, I need it to automatically fill in the working days only into another sheet. So for example, a dropdown box in...

Hoping someone can help I understand how to make a chart title dynamic. What I want to be able to do is Have a chart title automatically update from a different cell each day I have over 100 charts and at the moment it is fine until on any given day in a month the title needs to change This...

I am trying to set up a conditional formatting rule that will automatically SUM the value I input into the conditionally formatted cell with a number from an adjacent cell. For instance, if I apply this conditionally formatted rule to M1: =SUM(K1,M1) I would like whatever number I input into...

Looking for a way to extend a formula to the next row but only if the next row contains data e.g. if C1 contains =IF(A1="","",A1+10) is there a way to automatically extend the formula to C2 if (and only if) data is entered into A2? And then on to C3, C4 etc. The idea is to set up a template...

I have a macro on Sheet1(Sheet1.OpenCreative) assigned to an object that is referencing a cell with a dynamic hyperlink. When I duplicate this sheet, i would like the macro in sheet 2 to automatically change to Sheet2.OpenCreative. Is this possible? Macro code below: Sub OpenCreative() URL =...

I have a sheet that I am entering in values for to layout power requirements. My table has a colum for Devce Name, PDU Location, Max Power (W), Max Current (A) [this is automatically calculated based on he power field divided by 120V], Breaker value [auomaticly looked up based on a defined list...

Dears, Please help me on this. I want to find duplicates in Column A with Date in B and automatically enter date in Column F with Duplicate no in Column G and Time AM/PM in Column H. And then automatically move to next cell with same date if AM/PM and if not then new Date AM/PM with duplicate...

I'm typing this formula into each cell in column named 'Count' in order to look up today's count for each fruit, but it's not quite what I need. I'd like Excel to automatically grab the data in the last populated column (which gets updated daily), then paste column 'K'. Here's what I have, but...

Hello - This is the formula that Ive got: =(COUNTIF(E21:E23,"Y")/COUNTA(E21:E23)/IFERROR(E24,"")) It works great on providing me a percentage until I add in the if error, then the % automatically go to 0. What am I doing wrong?

Good morning, I have a tracking file which automatically creates a new barcode each time a new line item is added. The barcodes are created in column 'BE' using the '3 of 9 Barcode' font. Beside each barcode in column 'BD' is a 'Print' button which I would like to be able to click and it will...

Hello all, I'm working on a database, and I have it set up to automatically pull unique values from the one column. I use these unique values to populate a dropdown menu so I can sort the entries easily. The formula I have works for most things, but occasionally I'll have a cell that needs...

I'm trying to figure out how to turn the following into a function: =IF(AND(G2<>"",F2<>""),CONCATENATE(F2,"; ",G2),CONCATENATE(F2,G2)) Rather than referencing G2 and F2 I'd like the function to automatically reference the cell two to the left and one to the left respectively. Any help is...

Hi all, Apologies if i have posted this in the wrong place! Im trying to make it simple for users of a workbook to insert an image. So far I have inserted an activeX image control and used this code (found online) so they can select an image to add to the cell- Private Sub Image1_Click() With...