logo
down
shadow

EXCEL QUESTIONS

Adding an OR statement within a boolean
Adding an OR statement within a boolean
I wish this help you It is definitely possible to do what you are asking. Let me also suggest a few adjustments for optimization.This comparison appears several times in the code:
TAG : excel
Date : November 29 2020, 04:01 AM , By : ublureak
How to Compare an Entire Row to another Row in Excel and Return Value
How to Compare an Entire Row to another Row in Excel and Return Value
this will help , Perhaps something like the following:
TAG : excel
Date : November 29 2020, 04:01 AM , By : Ismail Kılınç
Restructure name in excel from (Last, First) to (First Last)
Restructure name in excel from (Last, First) to (First Last)
I think the issue was by ths following , Don't bother with a formula, use Flash Fill. If you really need a formula = =MID(A1" "A1,FIND(", ",A1)+2,LEN(A1)-1).
TAG : excel
Date : November 29 2020, 04:01 AM , By : Eric Scott Owens
Using loops to copy and paste
Using loops to copy and paste
wish help you to fix your issue You can use a collection, then input to other sheet. Sheet 2 column C has the original data.
TAG : excel
Date : November 28 2020, 04:01 AM , By : kaja vl
Delete a UserForm and add a New UserForm in Excel VBA
Delete a UserForm and add a New UserForm in Excel VBA
I think the issue was by ths following , From: http://www.cpearson.com/excel/vbe.aspx
TAG : excel
Date : November 26 2020, 04:01 AM , By : Santa Paws
Keypress about not allowing testers inputing 2 digits in a textbox in vba
Keypress about not allowing testers inputing 2 digits in a textbox in vba
it should still fix some issue I have a code that will not allow to press 0,1 and 8 up , Here's one way to accomplish what you need:
TAG : excel
Date : November 26 2020, 04:01 AM , By : Martin Prossliner
VBA listobject lookup function fast
VBA listobject lookup function fast
I hope this helps you . One of the major slow-downs in VBA is reading/writing cell values. You want to minimize the number of times you read/write to a worksheet as much as possible. As it turns out, in most cases it's much, much faster to read a ran
TAG : excel
Date : November 26 2020, 04:01 AM , By : user2186990
Excel VBA For Loop to Duplicate Data
Excel VBA For Loop to Duplicate Data
To fix this issue I'm trying to create a for loop that looks the first row in my data source (row 3) and then it pastes that in a new reference sheet, but then I want the loop to paste the same data again just below it. So row's 3 and 4 in the refere
TAG : excel
Date : November 26 2020, 04:01 AM , By : user2186958
How do I change the background image of a chart in vba?
How do I change the background image of a chart in vba?
wish helps you If myChart is Chart variable then you want the myChart.PlotArea.Format.Fill for the area of the chart that contains the actual chart, or myChart.ChartArea.Format.Fill for the whole chart area. The code below shows how to use it. I've c
TAG : excel
Date : November 25 2020, 04:01 AM , By : Abdul Rafay
VBA - Loop through files in a folder AND copy single cells as well as a range, if condition is met
VBA - Loop through files in a folder AND copy single cells as well as a range, if condition is met
it helps some times This should do it. I've turned your array back to 5 elements, and the range is transferred separately. I've added a few new variables which you might want to give more meaningful names.
TAG : excel
Date : November 25 2020, 04:01 AM , By : Muni Swamy
Screenshotting Google Maps and Pasting into Excel Document VBA
Screenshotting Google Maps and Pasting into Excel Document VBA
this will help I have a code that already searches for the latitude and longitude and pastes to my worksheet, which works perfectly. I'm looking for a way to take that latitude and longitude, load google maps, and either take a screenshot of the goog
TAG : excel
Date : November 25 2020, 04:01 AM , By : user2186562
Comments split by page break
Comments split by page break
will be helpful for those in need You could try setting the print area of the worksheet to include the area that the comments occupy.
TAG : excel
Date : November 24 2020, 04:01 AM , By : Binho
Data Manipulation / Dissecting
Data Manipulation / Dissecting
I wish this help you I am trying to dissect some text within VBA, the two text examples I am trying to change are below: , All I have used the below code to resolve my issue.
TAG : excel
Date : November 24 2020, 04:01 AM , By : Pavel
Convert multi column table to single columns with repeat pattern
Convert multi column table to single columns with repeat pattern
I wish did fix the issue. Suppose you have a column range (table) in Excel like this: , Try:
TAG : excel
Date : November 24 2020, 04:01 AM , By : Nazreen Londt Abraha
IF statement to trigger specific conditional formatting?
IF statement to trigger specific conditional formatting?
it helps some times Your conditional formatting function needs to be like so AND($B5$C5,(not(ISBLANK(B5))+not(ISBLANK(C5))>1))
TAG : excel
Date : November 24 2020, 04:01 AM , By : Vercy
Offsetting a date based on time in excel using if and function
Offsetting a date based on time in excel using if and function
wish of those help A confusing title, I know! , Try using this
TAG : excel
Date : November 24 2020, 04:01 AM , By : user2186238
Search a copied value MACRO
Search a copied value MACRO
this will help Something along these lines.Read this to learn the advantages of not using Select or Activate.
TAG : excel
Date : November 23 2020, 04:01 AM , By : SENG KRUY
Running an Excel macro from another workbook
Running an Excel macro from another workbook
should help you out I have a subroutine that opens a workbook containing a macro. I then want to run that macro. My code looks like this:
TAG : excel
Date : November 22 2020, 04:01 AM , By : Constantine Stupakev
Code to delete rows containing a search string skips some rows with the string
Code to delete rows containing a search string skips some rows with the string
Any of those help I have written some code in Excel VBA below, which deletes rows based on user input. It almost completely works but in some cases leaves one or two instances of the search string in the data. , Try this code:
TAG : excel
Date : November 22 2020, 04:01 AM , By : Dragos Mursa
Open file in vba Excel environment
Open file in vba Excel environment
wish helps you I'm going to use this code to open my file. But it seems to be the mistake in my last line (myShell.Run "path"). , Try the following fix
TAG : excel
Date : November 21 2020, 04:01 AM , By : shijohn joseph
How can i count the frequency of those of a number showing from a countif but only once?
How can i count the frequency of those of a number showing from a countif but only once?
will help you Hi I have a bunch of data and I need to know how much of each value show up and how often the frequency is only corresponding to the unique value. I used a countif to count the unique value but I wanna know the frequency of the amount o
TAG : excel
Date : November 21 2020, 04:01 AM , By : Loki
Excel - check values in multiple columns and return the sum of a third column
Excel - check values in multiple columns and return the sum of a third column
will help you I am very well aware that similar questions have been asked many times before but somehow the answers don't work for me. So I am sharing my example with you and hope for your assistance. , You can use this formula
TAG : excel
Date : November 21 2020, 04:01 AM , By : paresh sharma
VBA userform: application-defined or object-defined error
VBA userform: application-defined or object-defined error
may help you . As John said - your code as posted doesn't produce the error you're reporting. I think the problem with your code is:
TAG : excel
Date : November 21 2020, 04:01 AM , By : user2185314
Delete without warning any sheet for which the name contains the word "sheet"
Delete without warning any sheet for which the name contains the word "sheet"
should help you out You need to iterate over all the worksheets, check the name contains "Sheet" and if so, delete the worksheet in question. This should do what you need
TAG : excel
Date : November 21 2020, 04:01 AM , By : user2185296
Csv file is not aligned correctly in excel
Csv file is not aligned correctly in excel
help you fix your problem Same here when I import the given CSV as you describe on a Dutch machine. It seems Excel has a bug there. What DOES work is to use a small piece of PowerShell to convert the delimiters in the CSV to the machine's default del
TAG : excel
Date : November 21 2020, 04:01 AM , By : Pradeep Naik
Filter one column and count values in other
Filter one column and count values in other
I think the issue was by ths following , I have a database where is in column C the names of tools like: KDX15, GUA10, PKN01 and they are repeated in this column many times but they have added value each time in column D. , Use a Pivot Table … … to g
TAG : excel
Date : November 20 2020, 04:01 AM , By : user2185085
vba excel listobject HeaderRowRange
vba excel listobject HeaderRowRange
this will help D1 is already a valid range address so don't name it that if you want to refer to it with any Range object (not sure about your use here as I don't think it is valid anyway. You can use Find. Also, why do you have D1 on the end of ftsT
TAG : excel
Date : November 20 2020, 04:01 AM , By : maxclean
how to add text box/shape around each cell in the selection?
how to add text box/shape around each cell in the selection?
this will help You can use the .AddTextbox method. Loop through the cells in your selection, and use the cell's dimensional properties to set the dimensions of your textbox.
TAG : excel
Date : November 19 2020, 04:01 AM , By : Sir Rigel
Determining Last Names in excel from a range of full names in varying formats
Determining Last Names in excel from a range of full names in varying formats
To fix the issue you can do I need to create a formula that extracts lastName from each one of these formats.
TAG : excel
Date : November 18 2020, 04:01 AM , By : interactive-everythi
Read Column A, insert rows based on pattern
Read Column A, insert rows based on pattern
it fixes the issue I have data in Column A that looks like this: , Being a forward thinker, I used multiple Do loops.
TAG : excel
Date : November 18 2020, 04:01 AM , By : user2184210
If 1 or both columns has word, then enter text
If 1 or both columns has word, then enter text
Hope that helps I am trying to create a formula that states: If either or both columns R S on sheet 'Jan' have "fail" than enter a Y in column K of sheet 'Feb'. there are 4 possible outcomes: , Based on your description, perhaps the following:
TAG : excel
Date : November 16 2020, 04:01 AM , By : user2183496
SUM of VLOOKUP functions meeting criteria in Excel
SUM of VLOOKUP functions meeting criteria in Excel
this will help Due to the data structure you provided if you only want to sum the names in Group 1 that are dead then you would use:
TAG : excel
Date : November 15 2020, 04:01 AM , By : Ravi
Extract text using css selector
Extract text using css selector
may help you . To use xpath with multiple possible search values use the following syntax:
TAG : excel
Date : November 15 2020, 04:01 AM , By : Alessandro Monco
How to use Excel::Writer::XLSX to create a table where inserting a row copies a column's formula?
How to use Excel::Writer::XLSX to create a table where inserting a row copies a column's formula?
To fix the issue you can do Excel tables are so underused... it's good to see someone with an appreciation for what they have to offer, and kudos to the module author for adding table support.A couple of things... if you want a table-based formula, d
TAG : excel
Date : November 14 2020, 04:01 AM , By : Felix Roske
Change Chart Colours (bar) Based on Source Cell (using conditional formatting and VBA)
Change Chart Colours (bar) Based on Source Cell (using conditional formatting and VBA)
this one helps. Formatting applied via CF can be accessed via the DisplayFormat property:
TAG : excel
Date : November 14 2020, 04:01 AM , By : Deen
Web query throws error: import currenturl matches no exports. Did you miss a module reference?
Web query throws error: import currenturl matches no exports. Did you miss a module reference?
fixed the issue. Will look into that further I think the error message you are receiving is from Power Query.Your variable currenturl is defined in VBA but not in Power Query (the two are separate and Power Query does not have knowledge of your VBA v
TAG : excel
Date : November 14 2020, 04:01 AM , By : user2182844
VLookUp value to another worksheet
VLookUp value to another worksheet
it should still fix some issue I need to get the value of the corresponding item in Lookup table. But, I am getting N/A in my output. In worksheet1, I need to use column H as a lookup value then reference it in VLookup sheet or Table2 using ColumnC,
TAG : excel
Date : November 13 2020, 04:01 AM , By : user2182371
Writing a loop that has multiple criteria
Writing a loop that has multiple criteria
hop of those help? I would tend to use an array input for this; you can easily alter the array then but the code will still work. Something like:
TAG : excel
Date : November 12 2020, 04:01 AM , By : Srijith
Paste a copied data range in all open workbooks using a loop
Paste a copied data range in all open workbooks using a loop
Does that help You don't need to copy and paste, you can transfer the value directly, but you need to specify the origin (unless your code accesses the clipboard).
TAG : excel
Date : November 12 2020, 04:01 AM , By : user2182305
Use Excel-VBA to colour a range y if value is certain number is placed AND colour range x if value is certain number is
Use Excel-VBA to colour a range y if value is certain number is placed AND colour range x if value is certain number is
To fix the issue you can do As mentioned in the comments, you can only have one Worksheet_Change subroutine. This code should get you what you need:
TAG : excel
Date : November 12 2020, 04:01 AM , By : Prathap
Getting meta property from a URL
Getting meta property from a URL
I hope this helps you . You have several options but if you want to refer to product...; that is the value of the attribute property, so you would need an attribute = value css selector. Attribute selectors are denoted by []. Furthermore, to avoid co
TAG : excel
Date : November 11 2020, 04:01 AM , By : user2181939
Power Query - Create date from datenumber and time column
Power Query - Create date from datenumber and time column
To fix this issue You can use this to add a column which combines the relative date and time values:
TAG : excel
Date : November 10 2020, 04:01 AM , By : user2181532
Colour a cell if a certain number is entered
Colour a cell if a certain number is entered
this one helps. You can use the following macro. It must the placed in the respective worksheet (not the workbook and not in a module). Moreover, you can define a range to observe by defining rngObserve). I guess you don't want to check the whole wor
TAG : excel
Date : November 10 2020, 04:01 AM , By : SUNDER SHARMA
vba target.count=1 error when selecting all
vba target.count=1 error when selecting all
this will help tldr; You're trying to retrieve too large a number into the Range.Count property.The Range.Count property was written to return a long integer resolved to the total number of individual cells within the range object.
TAG : excel
Date : November 09 2020, 04:01 AM , By : dzogchungpa
Excel selecting special condition
Excel selecting special condition
it fixes the issue This code will select any text that doesn't have an extension on the end. So paths like C:\Reports\Point\Germany\Berlin\.pdf and C:\Reports\Point\Germany\Berlin\20.05 have an extension, while C:\Reports\Point\Germany\Berlin.2005\20
TAG : excel
Date : November 09 2020, 04:01 AM , By : user2181077
Searching through list of random files in directory and renaming files based on Cell Value
Searching through list of random files in directory and renaming files based on Cell Value
I wish this help you Found the solution, from an excellent explanation why it didn't work in this post: Excel VBA Dir loop fails when open and close command added within loopAdded an extra sub as the YowE3K suggested and it works great now!
TAG : excel
Date : November 09 2020, 04:01 AM , By : AleGol
Avoid counting unfiltered results using COUNTIFS formula
Avoid counting unfiltered results using COUNTIFS formula
hope this fix your issue I have an excel sheet that I am working on that lists all the incidents reported in the office. There are multiple sheets, the original data sheet and others that extract that data. , This could work:
TAG : excel
Date : November 09 2020, 04:01 AM , By : Ricardo
Excel macro saving sheet as pdf to sharepoint to location dependent on input in new folder
Excel macro saving sheet as pdf to sharepoint to location dependent on input in new folder
it helps some times OK, I probably overshot the targer a bit...This code only works with drives mapped to the normal Filesystem, if you want to use a network path you can read some more on the topic here: Cannot save file to Sharepoint Online using V
TAG : excel
Date : November 08 2020, 04:01 AM , By : Carah
Power Query - replacing text in a new column
Power Query - replacing text in a new column
Does that help I am new to Power Query in Excel and my question is: , You can use try otherwise to deal with both data types:
TAG : excel
Date : November 08 2020, 04:01 AM , By : Jayr
Check availability of folder/files
Check availability of folder/files
I hope this helps you . I'd advise using the file scripting object to avoid the volatility where you can come up against issues if looping the function:
TAG : excel
Date : November 08 2020, 04:01 AM , By : Eli
Souble Loop sheets and cells
Souble Loop sheets and cells
will help you please see below code. It works well but when I am trying to add extra loop over all sheets it gives me an mismatch error 13
TAG : excel
Date : November 08 2020, 04:01 AM , By : Vij Vijay
getting compiler error (invalid identifier)
getting compiler error (invalid identifier)
This might help you As said above, in my following code I get an compiler error telling me there is an invalid identifier. I don't really see the problem, basically it is a very easy code. The problem should be in the lines using the backcolor-Functi
TAG : excel
Date : November 08 2020, 04:01 AM , By : James Dulin
Excel Formula - Match substrings of List to List
Excel Formula - Match substrings of List to List
it should still fix some issue I have two Lists in an excel spreadsheet.
TAG : excel
Date : November 07 2020, 04:01 AM , By : user2180468
Trigger same macro with different command button with Button properties
Trigger same macro with different command button with Button properties
it helps some times Form Controls In a normal module add a procedure with no arguments:
TAG : excel
Date : November 07 2020, 04:01 AM , By : Christina Crews
Laravel Export Excel doesn't return an excel file
Laravel Export Excel doesn't return an excel file
hop of those help? Solved.. This is because a redundant route between the resource root which is return a datatable and my export route.
TAG : excel
Date : November 07 2020, 04:01 AM , By : user2180291
Put timestamp when a checkbox is ticked or unticked
Put timestamp when a checkbox is ticked or unticked
this will help You seem to be confusing Worksheet_Calculate with Worksheet_Change and using Intersect as if one of the arguments was Target (which Worksheet_Calculate does not have).Intersect(cbX1, Range("A1:F1")) is always not nothing because you ar
TAG : excel
Date : November 05 2020, 04:01 AM , By : user2179781
Index was out of range must be less than or negative
Index was out of range must be less than or negative
will help you This problem are solved already, I just solved this by saving the Excel from old to new data inside of excel. I don't know if this solve to the others.
TAG : excel
Date : November 05 2020, 04:01 AM , By : Ahgigu
VBA Saving delay after data entry
VBA Saving delay after data entry
I wish did fix the issue. One possibility is to leverage the Workbook.SheetChange event and Application.OnTime. You'll also need a Public variable, ScheduledTime in the example below.Every time any (non-chart) sheet is changed (e.g. via data entry):
TAG : excel
Date : November 05 2020, 04:01 AM , By : unwiredguru
Sort cells that have the same date but different time
Sort cells that have the same date but different time
help you fix your problem Simply insert a new pivot table, select "Trading interval" as a rows field and demand-(solar+wind) as values. In your new pivot table right-click on the Trading interval field and select "Group" and "Days".
TAG : excel
Date : November 05 2020, 04:01 AM , By : Steffen Eppler
VBA - Delete all rows that do not contain at least 1 highlighted cell
VBA - Delete all rows that do not contain at least 1 highlighted cell
Hope this helps Looking for VBA code to delete all rows that do not contain at least 1 highlighted cell (interior color used: REDINDEX). , you can do it like this:
TAG : excel
Date : November 05 2020, 04:01 AM , By : user2179597

shadow
Privacy Policy - Terms - Contact Us © bighow.org