All Questions
Tagged with excel excel-2007
2,821
questions
0
votes
0
answers
31
views
Copying Text from a textbox to a cell in excel through vba
The below is the code for copying the text from a textbox and paste its contents into a given cell while maintaining the proper formatting, but the thing is that it takes a lot of time to run.
I need ...
0
votes
2
answers
42
views
Hiding empty cells in Excel chart
I would like to set up a graphic that is fixed to a cell range. The values there change depending on the data input. If a cell is empty, the axis labelling is still displayed in the graphic. How can I ...
1
vote
3
answers
147
views
How to get the first and last cell with values in a row for every row in a table in Excel?
So I wanted to solve a question, which was to compture YoY (Year over Year) growth rate for some specific conditions company, I was given this dataset above and I know the formula of YoY Growth rate. ...
0
votes
3
answers
61
views
want to decrease number of rows by putting size of same item into column to decrease sheet size
I have excel sheet of more than 1000 item name in which single item contain different sizes (which making sheet long) I want to separate sizes from name and want to put them on top row so that same ...
0
votes
1
answer
32
views
How to copy excel cell content to a string with vba
I want to save an Excel sheet as a file using vba code. That I have achieved.
Sheets("html").Select
Dim Path As String
Dim FileNumber As Integer
Dim k As Integer
...
0
votes
0
answers
41
views
Addressing problem after automatic table update
Friends, I have a file that when opened, connects to a site and the table in the first sheet is automatically updated (once a day).
In the columns after this table, I wrote formulas that perform ...
1
vote
3
answers
57
views
Find the Maximum and Minimum values from a range set by cells containg specific value by VBA Array function
I need to extract data from Input sheet to another sheet as shown below
Input sheet:
I have added the image of the source file from which i want to extract the data
And I have hidden someww columns ...
1
vote
3
answers
86
views
Trying to Find the Maximum and Minimum values from a range set by cells containg specific value
I need to extract data from Input sheet to another sheet as shown below
Input sheet:
ColumnF
ColumnV
2
120
2
100
2
130
2
150
-1
70
-1
200
-1
150
-1
60
To new sheet to extract from Input
...
1
vote
1
answer
56
views
Auto moving a copied row to the first row set that is empty
I have created an Excel document that has multiple sheets. The first sheet is where all the information is processed, and then I added a formula that transfers the row of information to another sheet ...
0
votes
0
answers
45
views
How to sort data in text format in Excel
I have data in Excel and my data contain below format:
Year | WeekNo
2024 | Week 1
2024 | Week 2
2024 | Week 3
.
.
.
2024 | Week 11
2024 | Week 12
2024 | Week 13
.
.
so on.
When I applied ...
0
votes
0
answers
87
views
Check excel file is protected (with and without password)
I need to open an excel, and if it doesn't open, I need to determine if it's because of any of these cases:
-- Excel is protected
-- Excel is password protected
-- Excel is corrupt.
I have to use a ...
0
votes
1
answer
236
views
Is there a formula to Count Unique values with Criteria and between two dates
I need help to count all UNIQUE each Serial # of each Phase # between two dates.
Raw data changes every day. I know there is a way to formulate this but I can't do it.
I tried Cleaning the raw data ...
0
votes
0
answers
76
views
How to determine the count of Worksheet Tabs that is visible in the Sheet Tab on Excel?
In Excel, how can I determine which worksheet tabs are currently in view across the bottom of the window (Sheet Tab)? i'm looking for a object property to show if this sheet tab is in view or it is ...
0
votes
1
answer
59
views
Is there a formula to multiply two column only if both of them not null?
beginner here.
So I have to find a value with calculation like this: Sum of Column C * Sum of Column B / Sum of Column B. But the problem is both of Column B and C have to be not null. I use excel ...
0
votes
1
answer
70
views
How to change a cell value in worksheet change event in vba [duplicate]
Actually using the following code is impossible, because we are doing a change in Worksheet_Change
Private Sub Worksheet_Change(ByVal Target As Range) Target.Value = "test" End Sub
It will ...