Posts by royUK

Exactly what do you mean. The smaller area will copy to the same sized area within the second grid.

Attach an example workbook.

No

You need to explain more fully what you mean.

If you are looking to count then using SUMIFS or a PivotTable would be the best way, but your data is not very well laid out for any use.

Here's a PivotTable based on February's sheet.

For the best results copy and paste all data to one sheet.

Convert the data to a Table so that the PivotTable's source is dynamic -Overview of Excel Tables.

Add the PivotTable - Create a PivotTable to analyze worksheet data

This highlights my comment in your previous post

Quote

The most efficient way is to forget splitting the data and simply use AutoFilter to view the required month.

Poor designed workbooks end up requiring inefficient formulas and macros.

You should combine the data into one sheet then use a PivotTable. This will prevent the use of slow calculating formulas.

You can use multiple sources for a PivotTable or PowerPivot.

I don't think the web browser is compatible with 64 bit.

You don't need to use goto to copy data to data. Attach an example of your workbook.

The most efficient way is to forget splitting the data and simply use AutoFilter to view the required month.

Rather than using Loops to check the dates AutoFilter could be automated with VBA to split the data. If the data is likely to change the the code could clear the destination sheet then split the data. Again the most efficient way.

There's probably a much better way to do this. Attach an example of your workbook.

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

Attach an example workbook, but it is far better to keep all data on one sheet.

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

There is no general rule for merging events. In your case I think my suggested code is the best way, but read my last post.

Your code will slow down inputting to the sheet because every change will force Excel to check the sheet.

If you really need to split the data (which is a very bad idea) then don't use an event code but run code to make the split after you have finished inputting.

To be honest, the best way is to keep it all in one sheet. You can then use AutoFilter to view only the selected status.

Perhaps you want this

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim i As Long, last As Long
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Column <> 5 Then Exit Sub
    Z = Target.Row
    Select Case Target.Value
        Case "DENIED"
            Z = Target.Row
            last = Sheet2.Cells(Rows.Count, "A").End(xlUp).Row + 1
            Sheet2.Range("A" & last & ":i" & last).Value = Sheet4.Range("A" & Z & ":i" & Z).Value
            Sheet4.Rows(Z & ":" & Z).Delete Shift:=xlUp
        Case "Scheduled"
            last = Sheet3.Cells(Rows.Count, "A").End(xlUp).Row + 1
            Sheet3.Range("A" & last & ":i" & last).Value = Sheet4.Range("A" & Z & ":i" & Z).Value
            Sheet4.Rows(Z & ":" & Z).Delete Shift:=xlUp
    End Select
End Sub

I'm not sure exactly what your code is supposed to be doing, but it can probably be improved if you explain what you are doing.

That is one procedure

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

How to use code tags

Just highlight all of the code and press the <> in the post menu above button to add the code tags.

Thanks.

Where is this Procedure - Lookup?