User Posts: Zehad Rian Jim
0
How to Calculate the Issue Price of a Bond in Excel
0

This tutorial will demonstrate how to calculate the issue price of a bond in excel. In Microsoft Excel, you can easily calculate the present value of a bond. ...

0
How to Show Coordinates in Excel Graph (2 Easy Methods)
0

This tutorial will demonstrate the steps to show coordinates in an excel graph. Undoubtedly, graphs are very useful for easily representing any collected data. ...

0
How to Use Formula for Late Attendance in Excel
0

This tutorial will demonstrate how to use a formula for late attendance in Excel. Every company or educational institution maintains a late attendance sheet. ...

0
Excel AVERAGEIF Function for Values Greater Than 0
0

This tutorial will demonstrate how to use the AVERAGEIF function greater than 0 in excel. The AVERAGEIF function returns the average of the cells of an array ...

0
How to Combine INDEX and AGGREGATE Functions in Excel
0

This tutorial will demonstrate how to use combine INDEX and AGGREGATE Functions in excel. We will use the INDEX function to find certain values from different ...

0
How to Use VLOOKUP with Multiple Criteria in Different Sheets
0

This tutorial will demonstrate how to use VLOOKUP with multiple criteria in different sheets in excel. We will use the VLOOKUP function to find certain values ...

0
How to Display References Dialog Box in Excel
0

This tutorial will demonstrate how to display the references dialog box in excel. When you are dealing with lots of VBA codes in a different worksheet in a ...

0
How to Make a Calendar in Excel Without Template (2 Examples)
0

This tutorial will demonstrate how to make a calendar in excel without a template. In our day-to-day life, we all use a deadline for certain work or projects, ...

0
How to Insert Excel VBA Radio Button Input Box (3 Easy Methods)
0

This tutorial will demonstrate how to insert an excel VBA radio button input box. Radio buttons are mainly used as options in cases where different choices are ...

0
How to Stop Excel from Changing Numbers (3 Easy Methods)
0

This tutorial will demonstrate how to stop excel from changing numbers. Sometimes if you insert a number excel auto changes it to date or another scientific ...

0
How to Make Balance Sheet Format in Excel for Individual
0

This tutorial will demonstrate how to make a balance sheet format in Excel for an individual. A balance sheet is important when it comes to a proprietorship ...

0
How to Convert Minutes to Hours and Minutes in Excel
0

This tutorial will demonstrate how to convert minutes to hours and minutes in excel. We need to convert minutes into hours and minutes for our needs. Decimal ...

0
How to Return Value If Date Is Within a Range in Excel
0

This tutorial will demonstrate how to return the value if the date is within range in excel. When delivering products or submitting important projects, it is ...

0
How to Insert Last Modified Date and Time in Excel Cell
0

This tutorial will demonstrate how to insert the last modified date and time in an excel cell. When inserting lots of data entries, it is very important to ...

0
How to Update Links in Excel (5 Easy Methods)
0

This tutorial will demonstrate how to update links in excel. Unnecessary links can create confusion and difficulty while dealing with lots of data or links. ...

Browsing All Comments By: Zehad Rian Jim
  1. Hello DESTINY,
    First, thanks for your curious question. It was amusing to solve the problem. Let me guide you to fulfill your query.

    Step 1. Assume you have a Dataset where you have the Names of the employees in one column and the types of the employees in another.
    1

    Step 2. Then insert the following code in the VBA window.

    Sub Copy_Rows_3()
    Dim r1 As Range, Row_Last As Long, sht As Worksheet
    Dim Row_Last1 As Long
    Dim src As Worksheet
    ‘Change this to the sheet with the data on
    Set src = Sheets(“Dynamic”)
    Row_Last = src.Cells(Cells.Rows.Count, “C”).End(xlUp).Row
    For Each r1 In src.Range(“C5:C13” & Row_Last)
    On Error Resume Next
    Set sht = Sheets(CStr(r1.Value))
    On Error GoTo 0
    If sht Is Nothing Then
    Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = CStr(r1.Value)
    ‘Sheets(CStr(r.Value)).Cells(1, 1) = “Total”
    Row_Last1 = Sheets(CStr(r1.Value)).Cells(Cells.Rows.Count, “B”).End(xlUp).Row
    src.Rows(r1.Row).Copy Sheets(CStr(r1.Value)).Cells(Row_Last1 + 1, 1)
    Sheets(CStr(r1.Value)).Cells(1, 2) = WorksheetFunction.Sum(Sheets(CStr(r1.Value)).Columns(3))
    Set sht = Nothing
    Else
    ‘Sheets(CStr(r.Value)).Cells(1, 1) = “Total”
    Row_Last1 = Sheets(CStr(r1.Value)).Cells(Cells.Rows.Count, “B”).End(xlUp).Row
    src.Rows(r1.Row).Copy Sheets(CStr(r1.Value)).Cells(Row_Last1 + 1, 1)
    Sheets(CStr(r1.Value)).Cells(1, 2) = WorksheetFunction.Sum(Sheets(CStr(r1.Value)).Columns(3))
    Set sht = Nothing
    End If
    Next r1
    End Sub

    N.B. if you are following our article, use the VBA code under the method “Copy Rows in Excel to Another Sheet Dynamically” and change the marked portions.

    2

    Step 3. After pressing Run, you will get the result in individual desired cells.

    3

    4

    Thanks


  2. At first, Create a dataset having Age in Column B, Fixed Amount in Column C and Principle At the Start of the period in Column D.
    Then, insert the following formula in cell D5 and use the Fill Handle option to apply it to all cells of column D.
    =B5*C5

    Finally, insert the following formula in cell E6 and use the Fill Handle option to apply it to all cells of column E to get the desired result.
    =E5*(1+0.02)+D6

    The excel file is added here according to your wish.
    Compound Interest Statement.xlsx
    Thanks and happy helping.

  3. Hello CALEY FORBES,
    Thanks for the amazing question. Let me guide you in solving this problem.

    First, I want to solve your first query. I think to solve your problem it is better to use our first method ‘Automatically Copy Rows in Excel to Another Sheet Using Filters’ method than using VBA code. The reason behind this is I think the first method will do your desired work without hesitation.

    For the second query, you have to insert the following formula in the VBA windows.

    Sub Cut_Range_To_Clipboard()
    Range(“B4:B10”).Cut ‘This will cut the source range and copy the Range “B4:B10” data into Clipboard
    ‘Now you can select any range and paste there
    Range(“J2”).Select
    ActiveSheet.Paste
    End Sub

    Note: in the Range section you can change the desired option to paste accordingly.

    I hope, your problem will be solved in this way. You can share more problems in an email at [email protected]
    Happy Excelling!!!

ExcelDemy
Logo