Forum Discussion

Copper Contributor

Jun 01, 2021

Solved

VBA copying specific columns in new sheet

Hi all, I need some help. I am trying to create an easy code on how to copy a specific column from one sheet to the other if a condition is meet. If column F ="Yes" in sheet "request then I want col...

excel

Macros and VBA

NikolinoDE
Jun 01, 2021
infinity94
Here a quick mixed solution :))
With a hide macro

Nikolino
IF_with_out_VBA.xlsm22 KB

infinity94

Copper Contributor

Jun 01, 2021

thank you for this, but this leaves a lot of blank rows which I want to avoid. This is just a sample but when you have 2000 rows this wouldn't be looking great

NikolinoDE

Gold Contributor

Jun 01, 2021

infinity94

Here a quick mixed solution :))

With a hide macro

Nikolino

IF_with_out_VBA.xlsm22 KB

infinity94
Copper Contributor
Jun 04, 2021
thank you!
- NikolinoDE
  Gold Contributor
  Jun 04, 2021
  Your welcome
  
  Hope you have come to a satisfactory solution.
  
  Wish you a nice day / night with lots of health, joy and love.
  
  Nikolino
  I know I don't know anything (Socrates)
  
  *If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.