Excel VBA Course

(35% Sale Ends Jan. 26)

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 (35% Discount)

automatically copy sheet with formatting


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?



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: 2867) 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: 120) 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