# solved

1. ### Easy Formula - Pros Please help :)

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...
2. ### Text to Columns formula or code

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...
3. ### Paste Clipboard into Lotus Notes E-mail body

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...
4. ### Return row from other spreadsheet but allow override

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...
5. ### Import .txt macro runs from Excel but not when executed from an external vbscript.

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 =...
6. ### VBA to open specified workbook and "Save As" a cell value .xlsx

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...
7. ### Filter results of separate sheet based on another cell text

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...
8. ### Look up value with lowest rank

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...
9. ### Referencing Values from columns on Master sheet and skipping blank values

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...
10. ### Being driven made by Zero Width Space throughout sheet.

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...
11. ### Hidden difference between copied cell and entered text when data & formatting is the same

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...
12. ### Conditional Formatting based on WHEN I enter data

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...
13. ### VBA userform progress bar for cycles (just sharing my code)

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...
14. ### Filling an array with sheet names - VBA

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...
15. ### VBA Macro Select Worksheet If Name Contains String

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...
16. ### Lookup then RAG status

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...
17. ### Web Scraping with Excel VBA

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...
18. ### Exporting to CSV, messed up date format.

Using this: Private Sub Create_CSV() Dim content As String Dim Rng As Range Set Rng = Range("A12:AS30") Dim Path As String Dim FileName1 As String Dim FileName2 As String Dim FileName3 As String Dim sWB As Workbook, _ sWS As Worksheet Dim dWB As Workbook, _ dWS As...
19. ### AutoFill in Selection Range Method

Sub demo() Dim myRange As Range Set myRange = Selection myRange.Cells(1, 10).Select ActiveCell.FormulaR1C1 = "=test" & "(RC[-9])" Selection.AutoFill Destination:=Range("RC[-9]:RC" & Range("Selection" & Rows.count).End(xlUp).Row), Type:=xlFillDefault End Sub A B C D E F G H I J Text1...
20. ### FormulaLocal vs Formula2Local issue

Hi folks! I'm just trying to write a formula in a cell. if I use Formula2Local I got a '1004' Runtime error. Worksheets("SK").Cells(ACT_row, Col_VAL).Formula2Local = Aggr_costi if I use FormulaLocal everything run smoothly Worksheets("SK").Cells(ACT_row, Col_VAL).FormulaLocal = Aggr_costi The...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back