automatically

I could use some help with this formula: =(SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B11:K11"),"<>"))) This formula is counting the amount of times a value appears in cells B11:K11. The cells A32:A34 refer to the names of different worksheets – Week 1, Week 2 and Week 3. The formula itself...

Hi there. I own shares in a Canadian index fund. Fund code is RBF556. Canadian index fund. I was just wondering if there is a way to retrieve the quote automatically from the web when the spreadsheet is open. Thank you.

Hi I have the following formula in A1 =VLOOKUP(Sheet1!$F$1,Sheet1!$B$2:$C$45,2,FALSE) I want to add to the formula to check if the answer I get is the same as in E2,F2 If the answer of A1 is the same I need it to automatically change until the value is not the same as in E2,F2 Please help...

I have a long list of stock option strikes, 130 in all. When the stock price moves up or down beyond the number of rows I can see in my display, is there a way to automatically center the display based on a specific cell (at-the-money strike)?

Hello, I've workbook with some 100 sheets. This number increases each week. In each sheet there is a table with different dates and values assigned to these dates. Each sheet has a same structure. The difference is only in the entered dates. I have to consolidate by dates to get sum of...

Is there a way to automatically copy and paste a column from one sheet to another formulaically? (not using a macro) That is to say, if I copy and paste data into sheet A, a column of my choosing automatically populates in sheet B. Thank you

I want to build a hyperlink or a macro which when clicked on will open an new Outlook email with a copy of the file and the email address automatically populated. Is this possible? Ian

Hi. I have a sheet of my runs - dates, times etc. I have an average time of all my runs, however i’d like to also have an average time of my last 10 runs, to have a recent form average. Is there a way to automatically change the cells so that when a new run is entered, that is included & the...

I would like to format a cell with JUST this year, 2019, so that it automatically changes to 2020 next year, and subsequent years. Followed by cells that I would like to list as, the next years that changes also automatically. This Year...

Friends, I am developing task based database using VBA, I also developed user form similar to Data Entry (DE), * For that I need a program to auto update of SI.No in database automatically incremental immediately after invoking the DE User form using last SI.No in the (particular row)...

https://1drv.ms/x/s!AvjBsEPEq12ngUXYnGLP8pykEIRq?e=f3gY9X How do I make this pivot table show the dates instead of grouping automatically to year and months? I tried the Alt + D + P option, but doesn't work there as well.

Hi all, I want to make the spread sheet automatically run this macro code when a number is inputted into column B what code do i need to add to it Sub Ratio_BC() Dim Lastrow As Long Application.ScreenUpdating = False Lastrow = Range("B" & Rows.Count).End(xlUp).Row Range("D2:D" &...

Hello, I have a workbook with a few hundred sheets in it. Is there an easy way to rename each sheet using the contents of cell A3 on each sheet? Also, is there a way to automatically delete columns L - Q on every sheet? thanks Jon

HiI have created a table & in column B I enter a number (i.e 3) is there a way to automatically add 2 rows below the line, so if the number was 5, it would add 4 rows below?RegardsStephen

hi​ I'm trying to get a few columns hidden with my worksheet using Power Query. I've tried hiding the columns like you would do normally in Excel, but every time I refresh the query the columns automatically unhide. What can I do to prevent the Columns from unhiding. Thanks

HiI have a list and I have just added a new name to the list. I now go to my main entry sheet and when I go to column F and click the down arrow it appears, so far so good.My question is, is there a way of automatically creating a new tab at the bottom with the new name?RegardsStephen

Hi Guys, Good day. I have a project that i need your help and it goes like this. I will be using a multiple check box and if i tick a checkbox it would automatically go to a certain sheet. Thanks for your advance help.

I have six separate sheets that follow the same structure as the table below. In each sheet, I want the first column to remain the exact same. So if I start adding/removing columns from the first sheet, I want the following five sheets to automatically duplicate. Anyone have something that...

Good afternoon, I was wondering if you could use your help on excel. I have a excel spreadsheet which automatically imports room bookings data from the Microsoft word forms. However, sometimes we get clashes with requests overlapping each other. I would like this to be highlighted...

So I have a main sheet where I enter all the data and it asks how many receipts I want printed The receipts are in another workbook. How do I update the receipt workbook with the new data entered in the main sheet automatically