multiple

I want to Conditional format ONLY THE ONE CELL that contains the lowest value, but only in there is a "1" in the SEL column. For some reason I'm not able to get the correct syntax for the Conditional Formatting formula. In this example I'm working within a table named "data". I want the cell...

Hello, I am still fairly new to VBA programming but have been learning quickly. When looking for a way to add conditional formatting to a shape to make it change color, I came across "Private Sub Worksheet_Change(ByVal Target As Range)." While I was able to get this to work with a single shape...

I want to create a Bi-directional (two-way) Link in Excel that can link multiple rows and columns! First off, thank you to StephenCrump for the VBA for bi-directional linking multiple cells in a column! Awesome! Again, I'm very much a layman, I got help from StephenCrump on the VBA code for...

Hi all. Here's a head-scratcher for you all... I have linked to an example workbook in Google Sheets below (unfortunately I don't have Excel on my home PC). Basically I have one worksheet - "Sheet 2" - with a bunch of data. I have another worksheet in the same workbook -"Sheet 1" - that I need...

So while I know, ultimately, that I can do what I'm about to ask with a custom sort, I have a shared spreadsheet that is constantly having rows added, and deleted (I.E. they add to the bottom, but might just delete row 5), which means that I would have to redo the custom sort EVERY TIME I HAVE...

Hi all, I have a workbook Main.xlsx that references another workbook Source.xlsx using an IF(COUNTIF(....)) function in the Main.xlsx. When both workbooks are open, the formulas in the Main.xlsx workbook return values and everything works fine. But as soon as I close the Source.xlsx workbook...

hi, need macro to open and copy data from multiple txt. files (exactly i need direct 35 values(years)) to excel. I did macro for one year, but im struggling to do it for 35 years, can someone help me with solution please? Sub txt_to_excel() Dim X As Double Dim TXT As String ' Adresss Open...

Hello! This sounds so basic, but I swear I've searched for a long time and can't find exactly what I need. I have a list of (usually thousands of) contacts with multiple columns (E.g., let's simplify to: first name, last name, personal email, work email, phone) that I need to clean against...

Hi all, I have a GSheet with two tabs 'Sheet 1' and 'Raw Data'. I need to Look up an 'Opportunity Number' from Sheet One (column A) and find this in 'Raw Data Tab' (Column A) and Return Multiple 'Partners' from 'Raw Data tab' (Column B). Please see attached Mini-Sheet, I need the results in...

Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...

Hi guys! Not sure how to approach this - with lookup and aggregate, an index/match sub or something else. So In the sheet called Empty, when B2 is filled, it populates the Invoice column in D4:D with unique invoice numbers from an external order sheet. The Sales sheet has a list of orders where...

Hello The dates should repeat exactly after the red arrow sign. please help.

In the first image in column F I have name of customers, and in column K I have deposited amount (here are multiple amounts which are similar). In the 2nd image, in column E I have received amount of amount and in Column H I want to input names of customer based on the data of Column F in Image...

I have a huge list of accounting entry descriptions (all are unique and hand typed) that need to be examined to determine treatment (1 of 3 possibilities). I built a keyword finder using IFERROR(INDEX(MATCH(ISNUMBER)))) that works great. It leverages a 2 column table with keywords and their...

Hi all, I have read a lot of the forums to related about rank by multiple criteria, but I still not work for me. I would like to rank by value sales (column F) based on Shop, Category and Period. I have already input the expected rank in last column, please kindly help me to solve this...

Excel warriors, I have 38 xlsx files stored in one folder. Each file has a different count of sheets (15+)—all sheets have the same column count, same headings, but different counts of rows. I need a macro to append (consolidate) all of the sheets into one sheet in a new workbook. This...

Hi, I have anywhere from 60-100 spreadsheets generated from a reporting process in a folder. Each spreadsheet has set number of columns (A through G). Column G (Notes) is used by end-users to put notes. I am working on creating a unique list of all these notes from all the spreadsheets in the...

Hello, I am trying to create a word/phrase counter where it counts the contents of the cell (regardless of how many words are in there), and shows how many times it appears in the range. I apologize if it sounds confusing, but here is the example: Source: Genre Number Historical...

Hi everyone, I'm searching the web but I only found one code that kind of works but I need to make it more complex. Let me explain. My issue is that I have an Excel sheet with multiple worksheets, which all contain the same kind of information but are copied weekly by me. So every week, I will...

I have a list of employees and their course assignments, a list of employees and their certifications, and a list of the required certifications for each course. I am trying to run a single cell check on whether the person is appropriately certified for a assignment based on the range of...