VBA Help with Copying Entire row from one sheet to another based on cell value

aaronf15

New Member
Joined
Oct 2, 2018
Messages
4
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Mobile
I am looking to copy an entire row from one tab to the other based on what is in column A. In addition, I would like to sort the rows copied by what is in Column A (in this order...MIDS, DAYS, SWINGS). I would also like to have a definitive break row better the results. I have attached screen shots of what I currently have as well as what I'd like. This is meant to be a long range shift and appointment tracker for my unit. the Calendar is the long rang of all appointments and vacation and the schedule is the sheet we use to post for the week. I am currently using a hlookup to pull the data from one tab to the other but have not thought of a way to have a distinctive break between the shifts (Mids, Days, Swings). I'm fairly new to VBA so any help is appreciated.

https://ibb.co/m69u9K
https://ibb.co/e3wrpK
https://ibb.co/cuw5ie
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

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