6,253 questions
2
votes
3
answers
194
views
Insert and Paste Values to a protected sheet
This Excel VBA code is supposed to copy the entries from Sheet "Entry" then Insert & Paste only Values in Sheet "List".
Sheet List has a password to prevent editing.
Sub ...
- 39
Advice
1
vote
3
replies
126
views
COUNTIFS - Excel Date Matching
Simply, I have two values to lookup
1st is a name as "A"
1st is a date that I should look for its month given as "9/1/2025"
Apparently, I used these values as conditions in a ...
- 39
2
votes
1
answer
241
views
How do we remake program. The program return error overflow error 6
How do we remake this program?
File input.xlsm result.xlsm is larger than 600 000 records.
Sub Insertdata()
' Define constants.
Const SRC_FILE_PATH As String = _
"\\s-fa\...
0
votes
2
answers
136
views
Worksheet_SelectionChange Causes Clip Board to Clear
I have the code below - Essentially, if the user inputs a 1, 2, or 3 in cell N16, different sheets will show and hide themselves. This all works fine except that the clipboard gets cleared when any ...
1
vote
1
answer
151
views
Excel - Complex IF Question - Not sure if possible in excel
I have the below matrix where the Y axis consists of 'Vol' + 'Sub' and the X axis consists of 'Sub', with a rating corresponding to the level of each e.g. if Vol + Sub is 10.1% and Sub only is 4.3% ...
- 79
1
vote
1
answer
107
views
How to write a formula to display a message in column when checking if text in multiple cells AND dates in two columns match & overlap
To explain, I am creating an employee contract placement tracker in excel for desktop.
I have the following columns - Nurse Name, Overlap, Region, Site, ID, Start Date, End Date, Submitted Date, ...
- 11
0
votes
2
answers
93
views
why there is a difference between excel multiplication with formula and raw value multiplication [closed]
This is my Excel data:
In cell I21, I am using multiplication formula like Round(G21 * H21, 0) and the result is 94185.
But the cell J21 contains raw multiplication like Round(17.18 * 5480.96, 0) and ...
- 11.7k
0
votes
3
answers
203
views
want to split data depends on multiple columns
I want to split data on basis of A & B-column, if next row is same from A-column then look into B-column. if next row is same from B then copy F, G H-column till value from B is unchanged. Its ...
0
votes
0
answers
47
views
Day date one time caption [duplicate]
Dears , i want to move the current value of date to AA7 cell but one time when i press macro button.
I wrote this code , but it make the cell read live date , i just want to move the value of Today() ...
2
votes
1
answer
95
views
Excel Lookup - Find and Compare two Columns and insert data into a third
I have three columns in Excel (not of equal length)
Col B
Col C
Col D
C contains reference numbers and D contains an ID for the reference number in D, they are matched/paired on the same row.
C
D
1234
...
- 136
0
votes
1
answer
78
views
Determine the presence two lines within a subset of a query in Power Query
My goal is to query a folder of files (unique identifiers of files contained within col1 and col2) and create an index of which files contain a line with I in column I/R and A1 or A2 in column Info (...
- 17
0
votes
2
answers
146
views
Custom error bars in Bar Chart with VBA Excel
I am writing an Excel Macro that should create a bar graph with custom error bars (Standard error of mean, calculated on the sheet). But I got stuck with including the values.
This is what I want to ...
- 1
-1
votes
1
answer
83
views
Find the number and update the value in second match cell
I have a typical requirement. I came across multiple sources but somehow i dont get the answer for my query.
My requirement is, i have 3 columns with item, color, type. Item column contains name of ...
1
vote
1
answer
165
views
Trying to use a VB Macro to lookup a value in another Excel file and use that value to rename a file
Background: I have an Excel File and I want to rename it using the macro.
So the idea is it:
takes a value in column G of file 1.
It opens File 2 and looks for the corresponding value in column A.
It ...
- 21
0
votes
0
answers
73
views
Unable to understand RPC_E_SERVERFAULT Error
I have a PowerShell Script that cycles through multiple Excel Workbooks, runs a few VBA routines, and then closes.
Unfortunately, I get the following error :
Exception calling "Run" with &...
- 71
0
votes
0
answers
46
views
vlookup Formula will not return a value
In cell A5, I am trying to reference the 1st 3 numbers of a cell A1 to vlookup a value in a table in columns C:D. When I run the code separately, it works great. Once the vlookup and the left ...
1
vote
0
answers
18
views
excel data entry overwrite first save problem
I want my entry data to be save continuously to last save cell
this code overwrites the first save
this is the code for my save written in vba module(macro)
Sub Transfer()
Dim objList As ListObject ' ...
0
votes
1
answer
101
views
Why does VBA code work in Onedrive File but not Sharepoint file?
I have a module that's purpose is to refresh multiple queries using the same source in sequence so they don't try to refresh on top of each other and error out, and so that the refresh automatically ...
- 17
0
votes
0
answers
24
views
How do I sum value column only on maximum row for each ID group [duplicate]
Here I have 2 groups of ID (234 and 567).
each ID can occur several times and each time has its own value.
How do I sum the value for each ID group, but the result only appear on the row of latest/...
- 85
0
votes
1
answer
83
views
AutoFilter returning to 1st Range when trying to apply filter to different Range
`I have a looping command that is trying to delete entire rows when there is a blank cell in a column. The cell appears to be blank but has something in it that is failing my ISBLANK formula. Left ...
1
vote
5
answers
232
views
In Excel string, how to extract the first consecutive 9 alpha numeric characters
For the string, "Johnny#-ANF14112-26406TAG8-Bob: Frank Johnny#" I am trying to extract "26406TAG8". The challenge is that the delimiter is not always a "-". It may be a ...
-1
votes
1
answer
60
views
Excel Sumproduct to ignore non numerical value
Why is my formula not working? The result that i'm having is #VALUE!
I tried changing the (C5:513<>"-") to (Isnumber(C5:513)) but it still did not work.
I am open for better formula on ...
- 95
1
vote
0
answers
142
views
Power Query keeps failing refreshes
I have a macro that refreshes a series of power query connections (different queries of the same source, need to process the data in a very different way) but I have had persistent issues with some of ...
- 17
0
votes
0
answers
61
views
Excel formula with link to URL adresse an specific cell value
Hi #Excel specialists
I have a problem I'm trying to solve but I can not fix it myself.
I have a workbook we can call WORKBOOK 1 where I want to get a value from another workbook on Sharepoint to show ...
1
vote
1
answer
67
views
Get Attributes listed in the "Details" Tab with VBA
I am trying to get a list of attributes list in the "details" tab of a File:
I have this VBA but it only looks in the current folder. I want to be able to start at the parent folder and ...
- 11
1
vote
1
answer
173
views
extract text from a web page code vba excel
I have this example code where a method is used to extract text from a web page. In the complete code, these pages are then used to extract a whole series of data very quickly. The complete code has ...
- 11
0
votes
2
answers
105
views
vba AutoFilter Cells with blank background color but have data
how to AutoFilter Cells with blank background color but have data?
What value do I need to pass in colorIndex to get the following results ?
enter image description here
Sub FilterByColor()
Dim ...
0
votes
2
answers
105
views
Application.Match not recognizing matches
Have this long convoluted program, called when a cell in the relevant column on a given sheet is changed, for the purpose of identifying cases where there are duplicates in the WO value (column D) and ...
- 17
2
votes
3
answers
58
views
VBA move row based on multiple columns
I'm trying to move a row based on date to another sheet.
The code works and the row moves correctly, but only when all the fields are filled in with a date.
I also want to move the row when one or ...
- 41
0
votes
0
answers
96
views
exceljs filters on header disappears and date is not triggering change in other cells
\hello all.
I have an excel file with two pages, one has the summary of the records page(the second sheet), in the summary sheet there is the J1 cell, manually I can change the date from that cell ...
- 428
1
vote
3
answers
97
views
Find particular word in excel and fetch values
Below are my Excel rows. I want to get values after nCR. Kidnly provide functions for the same.
"\r\nAS|01|9999999\r\nCR|1234560||result"
"\r\nAS|01|9999999\r\nCR|7601231||Baba"
&...
- 533
0
votes
1
answer
92
views
Excel formula: find if ANY word in a multi-worded cell matches ANY word in a list of words in a column
See the screenshot below. I'd like a formula that tells me if any words in an A cell (say, A2) matches ANY of the words in the entire Column B (printing, vintage, etc.). Most, if not all, of the ...
0
votes
0
answers
41
views
How to obtain Excel data in the desired form or format? [duplicate]
I was working on the data provided in Excel given in the following pattern.
Now I want to convert the data into the following pattern:
This is just the sample part. I have 50 company names and ...
- 101
0
votes
6
answers
145
views
Excel separate a line of text
I have lots of rows in excel in the following format. These are image file names separated by a "|".
Based on the raw file sample, it should be separated into 3 unique first string, in this ...
- 134
0
votes
0
answers
102
views
How to keep rows with the same value in a column together when sorting
I'm coding a larger project that will automatically sort a table ("Table2") by the values in different columns, but I want to create an exception where rows with the same value in column D ...
0
votes
1
answer
69
views
What code can I use to skip the blanks in my cell?
I am new at this but so I need help! I have created a spreadsheet that I intend to export as a .txt file for uploading to my payroll software. The code is working great but I can't figure out how to ...
0
votes
1
answer
34
views
Update connections in Excel 2010 via VBA, one connection at a time
Good morning!
I have a spreadsheet, created on 365 but some users who would need to use it have Excel 2010
I have some connections that need to be updated separately, I cannot use Refreshall.
On the ...
0
votes
2
answers
143
views
Office Scripts Rows not Copy Pasting Correctly
Goal is to find any rows in a table "PO" on sheet that's value is "Cancelled," "Ordered," or "Voided" in column A, copy the row, then paste it onto the end of ...
2
votes
2
answers
132
views
Keep a cell value on Excel 2010
I have two Excel books, source-book.xlsx and destination-book.xlsx. On the first I have B4 cell with a drop down menu (January to March) and C4 cell to input a value.
On the destination-book I have ...
- 427
0
votes
2
answers
229
views
How do I compare the names on two sheets and count upon many parameters?
I have a referral tracking spreadsheet that constantly is getting new names added to it. We have a 3rd party that we reach out to for assistance when needed. I want to track the amount of times we ...
0
votes
1
answer
76
views
EXCEL: Combine multiple cell string into a single cell using Macro VBA
I would like to combine multiple vertical cell in excell assuming from A1:A9 as shown below:
FROM:
{'BAKWLC001': '10.144.250.240'}
{'BEWLC002': '10.250.32.249'}
{'CTALRwlc01': '10.52.188....
0
votes
1
answer
106
views
Dependent dropdown list in Excel ,Data Validation and VBA
When I try to paste a long code into the data validation source, I am unable to do so. To solve this problem, I created a function in VBA, but after calling it in the data validation source, I keep ...
- 59
0
votes
3
answers
109
views
Looking across a row to display the column heading
My department covers several different wards of a hospital
Our current rota is arranged so that the first column is the date, the heading of subsequent columns are consultant names - the cells are ...
1
vote
3
answers
274
views
Generate a random list based on a main list (consisting two columns)
I want to generate a random list from a main list based on two columns as shown in this pictures. The generated list values can be repeated and duplicated. the names and designation values are linked ...
- 79
0
votes
1
answer
55
views
Add Same Items In ListBox
I have been searching for solutions on the internet for sometime but to no avail. I want to write a procedure that will run through the columns of a listbox and sum up all values that have similar ...
- 39
0
votes
1
answer
102
views
DAY function Returned Wrong Answer
I'm trying to find a correct formula for this. I want to find the date if we add the month by 4. The answer should be September 30, 2024, but why the output is October 01, 2024? what should I add to ...
0
votes
1
answer
24
views
Could not remove duplicates from the excel, duplicates removing from only one column but not from the other column
I am trying to remove duplicates from a dataset in excel which has 700k rows with 10 columns. I am trying to remove duplicates from the first row which has ID. Rest of the columns has data associated ...
0
votes
1
answer
70
views
Excel Data Extraction
I need help with Excel to display data based on drop-down selections. I have a table with "Name" and "Gender." How can I set it up so when I select "Male" or "Female&...
- 11
1
vote
4
answers
122
views
Excel formula to qualify groups of matching rows off variables in individual rows
I've got an Excel workbook with ~3 million total line items where I've been asked to find how many transactions (which can be made up of several of these line items and are designated/grouped by a ...
- 11
0
votes
1
answer
106
views
Vlookup for items in a comma separated list
I have a table with different values associated with different name.
Column A
Column B
height 1
2
width 1
5
height 2
8
width 2
9
In another sheet, I have a table with multiple values separated by ...
