[TABLE="width: 500"]
<tbody>[TR]
[TD]Building
[/TD]
[TD]Apt
[/TD]
[TD]Type
[/TD]
[TD]Name1
[/TD]
[TD]Name2
[/TD]
[TD]Rent
[/TD]
[TD]Util
[/TD]
[TD]Park
[/TD]
[TD]Pet
[/TD]
[TD]Total
[/TD]
[TD]M/I
[/TD]
[TD]Exp.
[/TD]
[TD]Last increase Date
[/TD]
[TD]Last Increase Amount
[/TD]
[TD]Next increase Date
[/TD]
[TD]Next increase Amount
[/TD]
[TD]New Base Rent Renew
[/TD]
[TD]New Total Rent Renew
[/TD]
[TD]Next increase Amount MTM
[/TD]
[TD]New Base Rent MTM
[/TD]
[TD]New Total Rent MTM
[/TD]
[/TR]
[TR]
[TD]Building A
[/TD]
[TD]101
[/TD]
[TD]Apt
[/TD]
[TD]John Miller
[/TD]
[TD][/TD]
[TD]1395
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]35
[/TD]
[TD]1630
[/TD]
[TD]1/13/17
[/TD]
[TD]12/31/19
[/TD]
[TD]2/1/18
[/TD]
[TD]40
[/TD]
[TD]5/1/19
[/TD]
[TD]40
[/TD]
[TD]1,435
[/TD]
[TD]1,670
[/TD]
[TD]80
[/TD]
[TD]1,475
[/TD]
[TD]1,710
[/TD]
[/TR]
</tbody>[/TABLE]
I need data from select cells above to copy automatically to another sheet (below) if the Next Increase Date is not blank.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Building
[/TD]
[TD]Apt
[/TD]
[TD]Name 1
[/TD]
[TD]Name 2
[/TD]
[TD]New Base Rent Renew
[/TD]
[TD]New Total Rent Renew
[/TD]
[TD]New Base Rent MTM
[/TD]
[TD]New Total Rent MTM
[/TD]
[/TR]
[TR]
[TD]Building A
[/TD]
[TD]101
[/TD]
[TD]John Miller
[/TD]
[TD][/TD]
[TD]$1,435
[/TD]
[TD]$1,670
[/TD]
[TD]$1,475
[/TD]
[TD]$1,710
[/TD]
[/TR]
</tbody>[/TABLE]
Rent Increase list (above)
Hello, any help will be appreciated. I have never used VBA outside of a one day class.
I have a list of tenants and need to have select information populate from the tenant list to the rent increase sheet if the next increase date (column W) is not blank in the tenant list (there is a date listed). The data from that row in the tenant list that is designated in the rent increases sheet would be auto-populated so I can use for mail merge letters in Word and make it more automated and less prone to cutting and pasting errors.
This is an abbreviated table and there are more cells that need to copy but I wanted to keep it simple hoping I can adjust as needed once I understand the method.
<tbody>[TR]
[TD]Building
[/TD]
[TD]Apt
[/TD]
[TD]Type
[/TD]
[TD]Name1
[/TD]
[TD]Name2
[/TD]
[TD]Rent
[/TD]
[TD]Util
[/TD]
[TD]Park
[/TD]
[TD]Pet
[/TD]
[TD]Total
[/TD]
[TD]M/I
[/TD]
[TD]Exp.
[/TD]
[TD]Last increase Date
[/TD]
[TD]Last Increase Amount
[/TD]
[TD]Next increase Date
[/TD]
[TD]Next increase Amount
[/TD]
[TD]New Base Rent Renew
[/TD]
[TD]New Total Rent Renew
[/TD]
[TD]Next increase Amount MTM
[/TD]
[TD]New Base Rent MTM
[/TD]
[TD]New Total Rent MTM
[/TD]
[/TR]
[TR]
[TD]Building A
[/TD]
[TD]101
[/TD]
[TD]Apt
[/TD]
[TD]John Miller
[/TD]
[TD][/TD]
[TD]1395
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]35
[/TD]
[TD]1630
[/TD]
[TD]1/13/17
[/TD]
[TD]12/31/19
[/TD]
[TD]2/1/18
[/TD]
[TD]40
[/TD]
[TD]5/1/19
[/TD]
[TD]40
[/TD]
[TD]1,435
[/TD]
[TD]1,670
[/TD]
[TD]80
[/TD]
[TD]1,475
[/TD]
[TD]1,710
[/TD]
[/TR]
</tbody>[/TABLE]
I need data from select cells above to copy automatically to another sheet (below) if the Next Increase Date is not blank.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Building
[/TD]
[TD]Apt
[/TD]
[TD]Name 1
[/TD]
[TD]Name 2
[/TD]
[TD]New Base Rent Renew
[/TD]
[TD]New Total Rent Renew
[/TD]
[TD]New Base Rent MTM
[/TD]
[TD]New Total Rent MTM
[/TD]
[/TR]
[TR]
[TD]Building A
[/TD]
[TD]101
[/TD]
[TD]John Miller
[/TD]
[TD][/TD]
[TD]$1,435
[/TD]
[TD]$1,670
[/TD]
[TD]$1,475
[/TD]
[TD]$1,710
[/TD]
[/TR]
</tbody>[/TABLE]
Rent Increase list (above)
Hello, any help will be appreciated. I have never used VBA outside of a one day class.
I have a list of tenants and need to have select information populate from the tenant list to the rent increase sheet if the next increase date (column W) is not blank in the tenant list (there is a date listed). The data from that row in the tenant list that is designated in the rent increases sheet would be auto-populated so I can use for mail merge letters in Word and make it more automated and less prone to cutting and pasting errors.
This is an abbreviated table and there are more cells that need to copy but I wanted to keep it simple hoping I can adjust as needed once I understand the method.