Create an external URL link so my excel workbook opens on a specific sheet.
Hi, I have a Wiki site which currently uses URLS from individual excel sharepoint files for individuals on my team to open a workbook to record data. I am condensing these 10 files into one big workbook with separate tabs for each individual but I still want my team to have separate links on the Wiki site which will open the excel file on the individual's assigned tab. I've searched through previous suggestions on this which haven't worked for me. I'm running a 64-bit version of Excel on MS Office LTSC Professional Plus 2021. Thanks.
Chart doesn't update its range when recalculate happen when the file open
Reproducible Steps: Set formula =SEQUENCE(SECOND(NOW())), and create a chart. It is a dynamic array, so the chart's range should update when the array change Close and open the file. The array change when open, but the chart stands the range before
Automating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you!Consolidate data from multiple tabs using a dynamic formula
I have an online file (not using the desktop version) with multiple tabs named ddmmaa. future tabs will be added with random dates. on each tab i want to get the ranges C30:C80, AB30:AB80 and AG30:AG80 and create a new table with 3 columns. my initial approach was using this formula: =TEXTJOIN("|"; TRUE; INDIRECT("'" & TEXT(DAY(INDIRECT("$A$1")) + ROW(B1) - ROW($B$1); "00") & TEXT(MONTH(INDIRECT("$A$1")) + COLUMN(B1) - COLUMN($B$1); "00") & TEXT(RIGHT(YEAR(INDIRECT("$A$1")) + ROW(B1) - ROW($B$1); 2); "00") & "'!C" & 30 + ROW(B1) - ROW($B$1)); INDIRECT("'" & TEXT(DAY(INDIRECT("$A$1")) + ROW(B1) - ROW($B$1); "00") & TEXT(MONTH(INDIRECT("$A$1")) + COLUMN(B1) - COLUMN($B$1); "00") & TEXT(RIGHT(YEAR(INDIRECT("$A$1")) + ROW(B1) - ROW($B$1); 2); "00") & "'!AB" & 30 + ROW(B1) - ROW($B$1)); INDIRECT("'" & TEXT(DAY(INDIRECT("$A$1")) + ROW(B1) - ROW($B$1); "00") & TEXT(MONTH(INDIRECT("$A$1")) + COLUMN(B1) - COLUMN($B$1); "00") & TEXT(RIGHT(YEAR(INDIRECT("$A$1")) + ROW(B1) - ROW($B$1); 2); "00") & "'!AG" & 30 + ROW(B1) - ROW($B$1)) ) As you can see, on A1 i add a date with format dd/mm/aa and the formula gets on the tab with same date the data from each row and merge it using TEXTJOIN. this works great when I drag the formula horizontally... but if i have another date on A2 and drag the formula down, it does not work; if I remove $ it stops working horizontally. I appreciate any input.
Can't sign into Flow/Power Automate in Excel
Hi, I'm trying to help a colleague build a flow/power automate system in an excel sheet using the Flow automation add-in that is found in the Data Tab on the ribbon. First problem: in the desktop version of excel the Flow automation button appears on the data tab for the user, but when the user tries to sign in via the box that pops up nothing happens after their details have been correctly entered. Second problem: When the user opens excel online in their browser (Edge in this case) the flow automation button that should be appearing in the data tab is missing. Does anyone know of a way to make the flow button appear in excel online? (image is from my browser where the app is appearing as it should) In the past when I have had trouble signing into PA in Excel desktop, I have opened up excel online, signed into flow there which has kicked PA in excel desktop to signing in as well. Since my colleague is missing the flow button on the excel online ribbon I'm stuck on how to help them further. This user does have access rights to PA and has no trouble signing in to to see their flows.Help me with Formulas pls!
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I manually create separate sheets for each party and record their transactions, which is time-consuming. See this is my master sheet and I make stocks like this That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list. likewise i have to maintain 100+ party details, so anyone can help me reagarding this? I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with: Using VLOOKUP to fetch transactions from the main sheet to individual party sheets. Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet. Any guidance or examples on how to achieve this would be greatly appreciated. Thank you! hereby attaching excel file too https://filetransfer.io/data-package/beXdVs3F#linkCounting Overdue Dates between two columns
Hello all, Platform: Microsoft 365 web I have been trying to create a formula for the following: On a "dashboard" I am tracking several data points from my workbook. I need my dashboard to track if one date is bigger than another date on one of the sheets. If Column J says "Name" and column AO is bigger than column AN, it should get counted on my dashbaord. I've tried countifs and sum formulas with nested ifs, but none seem to be working. Can anyone lend a hand? If it helps, for context, my company contracts with outside agencies and has specific report due dates. I am trying to track the agencies and if the reports are coming in on time or are late. The late ones should be tallied on the dashboard for easy reference. agency name: Column J Due date: Column AN Received Date: Column AO Tally totalled on a seperate "Dashboard" sheet. Thanks for any help sent my way!
