I have an excel wookbook that contains 2 different worksheets.  The worksheet1 has all the information.  Worksheet2 has cells taken from worksheet1.  I want to be able to have the 2 cells that are highlighted in the worksheet1.png to be automatically copied to the next available cells in worksheet2 when the amount is entered in the cell which in this case is -15332.00 otherwise it won't enter anything.  Hope this makes sense.  Any suggestions??

Hi experts,

I have an Excel sheet where I show the comment field on click and resize the comment field at the same time. We use this to add comments to a project overview. I would however in addition like to remove the author on top or change it to the word "Actions" for example. Is it possible to find bold text in the comment field and replace it with other text?

Best regards,
Mark

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim myCell As Range
' Turn off the comment indicator
Application.DisplayCommentIndicator = xlNoIndicator

For Each myCell In Target.Cells
    If myCell.Comment Is Nothing Then
        ' Do nothing
    Else
        myCell.Comment.Visible = True 'On cell click the comment is visable
       
        'HOW TO Replace the author with something else
       
        myCell.Comment.Shape.Fill.ForeColor.RGB = RGB(0, 255, 0)
        myCell.Comment.Shape.Width = 400
        myCell.Comment.Shape.Height = 150
        myCell.Comment.Shape.Top = myCell.Comment.Parent.Top + 15 'Increase to move the comment down
        myCell.Comment.Shape.Left = myCell.Comment.Parent.Offset(0, 1).Left - 50 'Increase to move the comment to the right
    End If
Next myCell

End Sub

Hi，
I get type mismatch error to right line below

        tm = Replace(Cells(rw, 3).Value, ".", "")
        If Trim(tm) = "" Then
            tm = ""
        Else
            tm = Right("0" & Hour(tm), 2) & Right("0" & Minute(tm), 2)
        End If

Select all Open in new window

with this values. Please help.

A bug in the attached script creates all blank output when the cell references have not data.

For example, cell BR10 is blank, so the "Numbers_3" sheet has not data. It has to do with blank cells, because when I put data in that cells I get cell data in "Numbers_3" sheet.

I would like to resolve it where I can have blank cells because if I have to put data beyond number 70 I will need another script that will delete any row containing any number above 70.


Green represents blank cells

The attached file contains data in all the "Numbers_X" sheets but after the macro is run only Numbers_2 has data and it is the only filled line.
CreateCombinationsBug_sheetsblank-c.xlsb

Hi:

If you have a SQL view in Excel and if the Excel spreadsheet is the data source for Power BI, is it possible to refresh the dataset without having to refresh the actual spreadsheet and if so how?

Thanks!

Software Engineer


John

I have an Excel add-in firing an HRESULT 0x800401A8 error, when calling the getter of Worksheet.Parent.

I would be glad if anyone could let me know what the error might be, but more importantly and more generally, I would like to know how I can understand these HResult codes?

I did the following but am still confused:

Read the Microsoft's documentation on the Structure of COM error Codes.
Checked this SO thread.
Tried my chances with Magnum DB.

Thanks!

The idea is to create a script that removes rows where there are 2 or more numbers from different "decis". A deci is defined as numbers from 1-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, and 90-99,

There should be:

1) a prompt would ask for input of "Maximum numbers allowed from different decis" or something similar. If the input is one (1) then
2) choose the sheet to be processed
3) sheet "Numbers_3" would be edited as follows:

 This process should be able to be repeated for any sheet similar to "Numbers_3"


Notice how all the green rows contain number from only 1 "deci". That is the goal.
Remove-rows-with-2-or-more-numbers-.xlsb

I want to bring data from one spreadsheet to another, if a field is 'No', then pull comments from D5 over to another sheet.  

So one sheet - D5 is 'Yes' or 'No' - if 'No' and D6 are comments.  I would like the data to appear on another sheet.  

If 'Sheet1' - D5 = 'No' then pull data from 'Sheet1' - D2.   Thanks Experts.

Hallo,
I have a list of dates in A12 -   only workdays.
How can I add 2 blanks for Sat and Sunday
Should look like this:

Thank you very much.
Best regards,
Thomas
Zeiterfassung-2020.01-Expert-Exchang.xls

Hello. Im requesting assistance with the following. I have a excel file that i want to filter according to the dropdown list selected. attached is the example file. In the "main" tab is where the table and the dropdown list will be featured. Once the table is filtered to the dropdown selection, the last column (column E on the "main" tab in the attachment) needs to be answered either with YES / NO. Once i have answered all the rows, I want excel to record the options selected in the "results" tab.

the "results" tab will have the same columns as 'main" tab.

Your assistance is greatly appreciated.
work_deck.xlsx

I have 2 seperate worksheets. I choose the range from one column to paste into another blank worksheet for analysis and to create a table. IS there an easier way then choosing the top of the column and having to scroll down to the end of my records? There are 1,000 records in some and more in others. I dont want the whole column as I am chosing a range and creating a table in my new worksheet.