VBA Script not Pasting & Deleting Rows to Separate Tab

E

ExcelNoob486

New Member
Joined
Dec 20, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have been trying to get rows copied and pasted from my first tab "table1345" onto another tab "table13454" then delete the rows with rental status showing "Off Rent". I've tried but can't figure it out. I am also very new to scripts and have only started this week.

1703082679834.png
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

W
  • Question
VBA Script to Move a Row to a New Tab
Replies
0
Views
235
wangaa11
W
P
  • Question
Need VBA to automatically copy paste rows based on dates of current month.
2
Replies
11
Views
232
pk970
P
B
  • Question
Copying data from a year tab and pasting into month tabs
Replies
2
Views
189
B-radK
B
R
  • Question
VBA Script: Saving worksheet as CSV on MacOS
Replies
1
Views
940
temphelp
T
S
  • Question
Find exact name across multiple tabs & combine with data from the most recent tab?
Replies
0
Views
69
Sunshine8790
S

Forum statistics

Threads
1,215,081
Messages
6,123,016
Members
449,093
Latest member
ikke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top