VBA Code Help: Copy and Paste Select Cells If a condition is met

J

JRocket1207

New Member
Joined
Mar 31, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I have the following formatted Excel worksheet. The formatting we want to keep because it is consistent with what the employees that are entering the data in are used to. What I would like to do is take the Range A5:I14 and copy only the cells that meet the condition that column G = "c" to another worksheet, starting at cell A5. I will repeat the code for the bottom section but pasting to a different cell. The last part that I would like to do is copy the range K5:L28 if there is data in the cells and paste that into another sheet starting at U5 but only where there is no data already. Can anybody help with this?
1585698591732.png
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
You must log in or register to reply here.

Similar threads

C
  • Question
Macro that changes cell after each copy and paste
2
Replies
11
Views
406
PeteWright
PeteWright
P
  • Question
Need VBA to automatically copy paste rows based on dates of current month.
2
Replies
11
Views
230
pk970
P
T
  • Solved
Making the contents of the active cell the search term, and search using that term, copy paste row, next
Replies
2
Views
181
Travis Kunnen
T
S
  • Question
VBA Code - Create Log sheet (Errorlog) in case VBA Macro condition is not met
Replies
1
Views
134
Tupe77
T
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
245
Insurance Dave
I

Forum statistics

Threads
1,215,065
Messages
6,122,944
Members
449,095
Latest member
nmaske

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