I have the following code in an Excel VBA module that looks up the ProjID named cell on the worksheet, selects columns needed for output from dbo_Proj_Dash Acce
Is it possible to get this output in R? =INDIRECT((CONCATENATE(V4, AH4)),TRUE)
In Excel, I have index levels (1, 1.1, 1.2, 1.2.1, 2, etc.) and corresponding folder name. I want a function to be take each level and concatenate corresponding
I was trying to achieve this on Excel, which markers all cells containing "A" a red/green background with a gradient pattern. I achieved this in the past but no
I wish to generate the Most common, Highest and Lowest values from the following data: I have also added an additional column to handle text comments. M Code s
It was known that UserInterfaceOnly:=True setting was not saved with the workbook. So every time a Wb was opened, the Worksheet.Protect method had to be used wi
please dont hurt me for this question... I know it is not the ideal way to handle mass data- but I need to try... I got a folder with 10 csv Files which are alw
I looked through a few posts but it didn't help. My code merges same emails into one email and also consolidates a table. Works if I were to send to all. Sub Se
I have zero experience in VBA coding, but I currently have a functioning code I copied somewhere online that successfully extracts certain details from each ema
This code is part of a class module. Private pImg As Image 'For example, pImg = U_Cursor.Img Public Property Let ItemID(ID As Byte) pImg.Picture = LoadPic
I'm trying automate data entry using Selenium Basic for Excel VBA. I've been able to log in to the website via locating the necessary element selectors on the l
I have a code which is doing following: Prompt to choose external workbook Copying all the data from that wb Pasting exactly 1:1 in main wb Close and Save fr
I need to get the max of only the first dimension of the array. WorksheetFunction.Max(shifts_array) returns the maximum of all dimensions but I only need it of
I have the data as below: I would like to have an output as below: I can use VBA to solve this, but Appreciate to any suggestion solve by Power Query. Could y
I need to write some VBA code which could give me the result in the "Sorted Numbering" column in the below picture: The logic for the sorting is that filter th
Excel noob here. Lets say I have a sheet. . A B C D 1 Adam 3 No No 2 Betty 13 Yes No 3 Chris 12 No Yes 4 Dave 0 Yes Yes 5 Emma 1 No I want to conditionally h
I want to specify a word plus a date in a cell. Sub CurrentTestCell() With Range("i2") .Value = ("Test") And Date .NumberFormat = "mmmm yyyy" End
I am trying to compare two cells in a table: The column "MR" is calculated using the formula =ABS([@Value]-A1) to determine the moving range
I am trying to scrape data from https://www.doordash.com/food-delivery/chicago-il-restaurants/ The idea is to scrape all the data regarding the different resta
I am writing a program in the Worksheet_SelectionChange event to better understand the worksheet events, how it is fired and such. My program takes the string i