solved

Hello all, I am a novice/intermediate Excel user with Office365. In real life, I'm modeling IRA withdrawals and I'm running into a problem that can be distilled into the mini-sheet included here. I add or subtract annual interest from the balance using FV and I make a withdrawal based on the...

I work with P&L's a lot and do a lot of current month/YTD variances to current year / prior year and budget. I've consolidated a large file from ~50MB to 20MB by reorganizing a mapping table In this file i have a Flash report for Revenue and EBITDA by divisions / service lines and Acquisitions...

Good morning everyone, I downloaded a customer manager from the internet with a vba mask to input customer data. In order to facilitate the input of customer data I created a list for one data input cell which is linked to a dynamic range in the customer data worksheet. Now I have the problem...

Hello I am looking for help with a formula . I have a list of multiple ready dates and quantities for a single part, example Part ABC 25pcs 2/21 Part ABC 13pcs 1/21 Part ABC 5pcs 1/3 Part BCD 30pcs 1/24 Part BCD 30pcs 3/2 I rolled up it to a pviot table , I am looking to create a formula where...

Hello, I have a long list of data from our online system (except from that entire data set below) that needs to be separated out. Each entry that was made in the system had compiled itself into one entry instead of individual ones. In order to correct this, I need to separate out each entry...

Hi there, I am really new, and already hopeless :) Can anybody please tell me, why my code is pasting correctly the image from clipboard into e-mail body? I am trying to code by myself, sometimes I win, sometime I don't :) I would highly appreciate if anybody could teach me where my logic gone...

I have a leaver tracker to record when people are on leave. People put an A when they are on a day off. I'm making another separate spreadsheet to assign a task but it's important to know when people are going to be off so it doesn't get conflicted. I'd like to be able to bring through the A's...

I have this macro: Sub getpathnp() Application.ScreenUpdating = False Dim wbExcel As Workbook, wbText As Workbook Dim wsExcel As Worksheet Set wbExcel = ThisWorkbook 'specify here which Excel file the text file’s content is to be pasted into Set wsExcel =...

C2=Date (8.15.22) fore example. I would like to create a button macro that opens a workbook (file path will be recorded on a "setup" worksheet, for example: Setup!A2) and save that workbook with the value of C2 & .xlsx (8.15.22.xlsx) Ultimately there will be seven of these buttons, one for each...

I have two sheets setup: One with records, and one with links. I've got the point with the code below where if I double click on the heading "Link" within the Records sheet then it directs to the Links sheet and filters them based upon the reference in the original "Link" heading. I was...

Hi all, I am trying to look up in Power BI, Sample file here I need to lookup the column "location" from the 'Lookup Table' to 'My Table' The Video ID is used to link between two tables. However the video ID has duplicates in it. Question- How can I create a new column 'Location' in My...

Hey I'm wondering what formula I can use to get these two sheets below from a master sheet. I would like to be able to type out values in either the In or the Out columns on my master sheet (3rd picture) and have them automatically be printed out in my In and my Out sheet along with their...

I have a sheet which is a mixture of SharePoint list imports, pasting from a webpage etc. During this process, some zero width spaces are littered throughout the document. Of course it's helpful that I can't see them and don't know there is even an issue until I export to my other programme...

I'm trying to figure out what's going on. I have a database of employees. Column E: Employee ID# I have a table on a 2nd sheet, Files, that is a list of documents that I can't find Employee Folders for. Column B: Employee ID I have a column, T: Unfiled docs flag, with the following formula...

I have a workbook where I enter the same data each time I have a client show up for a session. I have to fill in the same 10 values based on what they say to me each time. I like to leave their values from the last session so I can remember what they were talking about. I am wondering if there...

Hi guys, i googled and forumed many solution for progressbars. Some are way above my head (with kernel inputs, hardware keys, so on), so i try to made one for myself which easily readable and understandable. I made a simple userform with 3 label. First is just for sub title, third is for text...

Greetings, I need to print a set of user-defined sheets form a workbook and I want them in ONE print job, not individual print jobs. Reason being, I want to create a PDF file with 1-10 pages, not ten pdf files. I can gather the sheet names the user chooses and put them in a place in the...

Complete macro noob and not sure what to do. I have borrowed a macro from this forum to select a tab based on the worksheet name Sub Macro1() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Name Like "* Apple" Then ws.Select Exit For End If Next ws End...

Hi all, Need some formula help (i think) I need a RAG dashboard lookup formula, its based on a list of text. Ive tried a few things including custom number & index match but it doesnt seem to work. Any idea on how i can do this? I have this list of data: Name Testing Approvals Reviews...

Hello, I have some script below in which I am trying to extract the information listed in the red box into an Excel file using VBA. Ideally, I would really love to get everything under the <div class="kioskDockDoor blueBg" line but I'll take any help I can get. I've tried multiple variations of...