Hello Everyone,
I explained my problem in the files attached.
thanks a lot.

Hey,

I am having trouble getting a macro to do what I want.

In column A i have a list of the sheet names in the workbook

I need a macro that will take the text from the cell and convert it to a hyperlink to its corresponding sheet

for example in cell A1 there is the text "SP5M"
there is also a sheet named "SP5M"
I want a macro to take the text from the cell that I have selected, tack on the "!A1" so it becomes an address for the sheet and create a hyperlink that displays just the original name...

if that makes sense?

It looks like a problem I'm having actually begins where I'm building an array of time values.

I'm getting the value of an active cell and putting it into a slot in an array and I see that it does not maintain it's time format and actually becomes a decimal. How can I control this from happening?

I pull a report into Excel that is dozens of columns by thousands of rows; this becomes my main worksheet(Some of the columns contain text, some contain numbers and some contain dates.) I then create worksheets titled for each month of the year. Then I must search two columns in this main worksheet for all the dates that contain the current month and year. This information can be in either of the two columns or both. Once located, I must copy the entire row for each date found in that row into a second worksheet.

Hello,
Could you please give some advise: Monthly, I have to copy some cells from excel to another document. In this copy process I want to know what cells I copied by marking them with a specific format (to avoid tangle). Is there any possibility to make something like: If cell copied to clipboard (or if Ctrl+C applied on that cell), then the cell gets such format (fill color chage)?

Thank you for your support.

Hi smart people,

I need a help with rows copy to another sheet useing VBA. I have attached file with task. And I do not know how to solve a problem with coloring. Please try to help, thanx a lot.

I am working on a project whose requirement steps are as follows:

Hello Excel Experts,

I have been looking for the macro since last week but with no luck till yet.

Would appreicate the efforts if you please get me out of the problem that i am facing,

I have created excel template (used it for coding list).

What i am looking for is that:

In Column B we need to put serial numbers (sequential numbers) in activecell based on the value specified in a two cells say (A1 = start serial from : 5) & (A2 = End serial number: 25)

how to code sumifs for sum range in different workbook??

I have a cell that looks like the following: Q4 23 plainfield
what I need to do is have the cell highlight green if the 2 in 23 is a 2. if it is a different number it will have a different color.

I was using the following formula to find the number, but i'm not getting the result i need. =right(left(A2,4),1)

Any help would be much appreciated!

Thank you,

Tyler

Hallo,

I need help for the following:

When I give a formula that is smaller than 1 it calculates incorrect.

For example €8180 : 0,0759 = EXCEL GIVES THIS NUBMER: € 107.000,00 BUT IT SHOULD BE € 10695

What am I doing wrong?

Sub TESTa()
Dim i As Long
Dim t As Single
t = Timer

Application.ScreenUpdating = False
For i = 1 To 100000000
ActiveCell.FormulaR1C1 = i
Next
MsgBox Timer - t & "seconds"
End Sub

this is a VBA that counts from 1 to 100000000. but really slowly... im not sure how many seconds this takes but tried with 10,000,000 and this took about 4 mins.

is there any way of making this happen in 30 seconds or so?

Hi Everyone,

I am trying to write a macro to open and import data from another Excel file. The thing is, I already have the path and filename in a cell that I would like to open and import data from. The file the I am importing data from is a daily download file with dates in the title (for example, Report as of 20130716.csv) I don't want to have to open this file everyday and copy and paste it into another file.

Can someone help me?
Thanks

Robert

Hi,

I am providing the link which has sample data

https://www.dropbox.com/sh/tovdou4mt5hgrfe/KD878psFt2

The total score the candidate can score is 30
cutoff scr is 25

1. I wanted to create three buckets

bucket 22, bucket >=24 and bucket 25

2. How do I create "Biggest contributor" performed by the candidate in all the parameters?

3. Which parameter a candidate has just missed with the cutoff score.?

4. Can you also help me with the charts and graphs to show the improvement areas in all the parameters?

Please advise

Thakur

I have an Excel workbook with 2 sheets
I need a formula that will do this;
SHEET 1 E73 = SHEET 2 C62 IF SHEET 1 A3 = AUGUST

I unfortunately know almost nothing about VBA, so I'm really depending on you guys for help.

Sir. in my excel first sheet i have 4 coloumbs with filder option..in second excel sheet have same colounm name and same filder option ...third sheet also same colounm name with filder..what my question is in my first sheet in one colounm name FORM ..if i do filder it will come C ,F,S...I HAVE TO FILDER C FORM IN FIRST SHEET AND SECOND SHEET AND THIRD SHEET ..ALL THE C FORM PUT INTO ONE NEW SHEET ...IF I DO FILDER IN NEW SHEET ALL THE CONTENTS WILL COME CONTIOUSLY..I WANT SHEET NAME (SHEET 1,SHEET2 OR SHEET 3 ) IN NEW SHEET BEFORE CONTENTS DISPLAY..PLS EXPLAIN ME CLEARLY...

I have values (digits) in square A1:E10
Some of the cell have value, some are empty.
It depends of other function to insert those values in that A1:E10 box.
Now I would like to transfer all available values from that A1:E10 box
to the cells of one single column for sample G1:G50.
How it can be done if possible?

Great News for excel users they lost or forgotten excel file password………………………
Now PDS helps you to recover excel file password because PDS has launched EXCEL password recovery software which helps you to recover excel file password then you can easily unlock excel file password. This Excel password recovery software to recover excel file password on such versions of MS excel file password -2010/2007/2003/2002/2000/97/

Excel Password Recovery Software works with two types of attacks.............
Dictionary Attack - This theatrical method easily deduct alphabetic values in short time

can any one help with the code of call sql stored procedure from vba macro

Hi Everyone,

I want to find average of cells

Ag4

Ag4,AG13

Ag4,AG13,Ag22

and so on...
(in incremental of 9)

Thanks in Advance

I have a spreadsheet of clients with the time and date of an initial enquiry. I need to be able to identify those clients who have made a second query within:
1. 1 day (or 24 hours) of their first call, and
2. 2 days (or 48 hours) of their first call, and
3. 5 days (or 120 hours) of their first call.
Ideally, any clients falling into any ofthese categories could be placed on one of three columns.
Any help really appreciated
Vin1602

I would like to automating some operation with macro, and here is a problem with the head.
At the beginning I’ve attached files that are done as a model - to represent how the macro works.
1) 5 variable with limit
or second file 2) variable_s_f - a slightly different approach to the macro code (more advanced)
Here I received a comment to second file model (comments are also attached directly to the code)
“Based on your subsequent procedures ...
I'd make a list of sheets with the proper Name.
On the basis of the number of sheets of Num - names identified shift.

Hi there! I am new to vba and I need to create an application that can extract a text string from a text file. The text string lies between 2 other text strings that repetitively occur in the text file. I am attaching the file below:

Hello,

I am really looking solution for this. I have contents in which I need to add
at the end of each line in excel and I don't know how to do it. Here is the example

PRODUCTION AND DEMAND

Anesthetic Drugs Sales Volume
Anesthetic Drugs Sales by Classification in 2008
Anesthetic Drugs Import
Anesthetic Drugs Export
Anesthetic Drugs Market Share by Classification in 2008

I want it to be look like this

PRODUCTION AND DEMAND < br>

Anesthetic Drugs Sales Volume< br>
Anesthetic Drugs Sales by Classification in 2008< br>
Anesthetic Drugs Import< br>

Hi
I want to display the text from cells in sheet 'Occupation data' in another sheet

I am using this formula =+'Occupation data'!A2 which works OK

However, when I delete row 2 in the 'Occupation data' sheet, the new data in Occupation data'!A2 is not displayed and the formula shows =+'Occupation data'!#REF!

Is there a method/formula that will retain the reference to Occupation data'!A2 after rows are deleted or added
Cheers

Hi, I'm getting a 'Mismatch' error at the bolded line in the following code:

Sub highlightTable()

Dim cell As Range
Dim counter As Integer

Set cell = Range("E6:G6")

counter = 0

Do While IsEmpty(cell.Offset(0, -1)) = False

    If cell.Offset(counter, 0).Value - cell.Offset(counter, -1).Value <= 0.002083334 Then
        If cell.Offset(counter, 0) - cell.Offset(counter, -1).Value >= 0 Then
        If cell.Offset(counter, 0) - cell.Offset(counter, -1).Value <> Empty Then
              
            With cell.Offset(counter, 0).Interior
            .Pattern = xlSolid
            .PatternColorIndex = xlAutomatic
            .Color = 13408767
            .TintAndShade = 0
            .PatternTintAndShade = 0
            End With
            counter = counter + 1
        Else
            counter = counter + 1
           
        End If
        End If
       
       
    ElseIf cell.Offset(counter, 0).Value - cell.Offset(counter, -1).Value <= 0.003472223 Then
        If cell.Offset(counter, 0) - cell.Offset(counter, -1).Value >= 0.0027777777 Then
        With cell.Offset(counter, 0).Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 39423
        .TintAndShade = 0
        .PatternTintAndShade = 0
        End With
        counter = counter + 1
        End If
       
    ElseIf cell.Offset(counter, 0).Value - cell.Offset(counter, -1).Value <= 0.01041666667 Then
        If cell.Offset(counter, 0) - cell.Offset(counter, -1).Value >= 0.004166666666 Then
        With cell.Offset(counter, 0).Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 65280
        .TintAndShade = 0
        .PatternTintAndShade = 0
        End With
        counter = counter + 1
        End If
       
    ElseIf cell.Offset(counter, 0).Value - cell.Offset(counter, -1).Value <= 0.01180555556 Then
        If cell.Offset(counter, 0) - cell.Offset(counter, -1).Value >= 0.011111111111 Then
        With cell.Offset(counter, 0).Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 39423
        .TintAndShade = 0
        .PatternTintAndShade = 0
        End With
        counter = counter + 1
        End If
       
     ElseIf cell.Offset(counter, 0).Value - cell.Offset(counter, -1).Value >= 0.0125 Then
        With cell.Offset(counter, 0).Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 13408767
        .TintAndShade = 0
        .PatternTintAndShade = 0
        End With
        counter = counter + 1
       
   

    Else
        End
   
    End If
Loop

End Sub
 

Hi everyone,

I am new to this forum and very very bad in excel calculations and formulas. I have hit a road block right now. The issue is I have this excel sheet where I have Column X and Column Y. The data in the column X is Codes which is repeated 4 times over. Column Y consists of Counts.
What I want to find out is for each code what is the corresponding lowest Count value which is greater than zero.

The excel workbook is attached.

Hi there,

Hi everybody,

I have a task which needs automation with use of macro and I have written code to do it; however, my code could not do the task successfully. Therefore, I need your help now.

I attached a sample file, including 3 sheets: “start_1”, “start_2” and “result”. “start_1” and “start_2” are identical. I need to format tables in these two sheets “start” so that they look like exactly the “result” sheet.

In detail, here are tasks which need automating:
- Add 1 blank row at top (I have done it)
- Freeze title rows (I have done it)