Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

automatically copy sheet with formatting

0

I want to cut data from sheet 1 to sheet 2 automatically with all added information (in future) on Sheet 1 to be seen on sheet 2. The data in row should be cut form Sheet 1 only if there is criteria met in one column. I need to copy formatting to.What should I do?

Answer
Discuss

Discussion

Hi Spelca and welcome to the Forum

You could use a VBA event macro to do that but your question doesn't give enough detail (e.g what criteria will you use and what constitutes completion of a row on Sheet 1?). Please edit your question to say (and preferably also add an Excel file using the Add Files... button).
John_Ru (rep: 6102) Jan 5, '22 at 6:58 am
Hi Spelca,

With the minimal amount of information provided, it seems like a solution should be fairly simple/easy. But as John has said, a bit more specifics and a sample file will be a big help.
WillieD24 (rep: 537) Jan 8, '22 at 5:40 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login