Copy from differnet sheets & paste into another sheet to form new report

**lakhan** · 03-16-2017, 02:40 AM

Every month I have 3 reports of User1, 2 & 3. I want to make one concolidate report of that 3sheets (USER1, USER2 & USER3) according to DATE in Final sheet "Feb17 REPORT". Is there any possibility to make a macro that all 3 sheets data will copy & paste in final report & then sort according to DATE? "Feb17 REPORT" is the final file which I require. Please help.

**JOHN H. DAVIS** · 03-16-2017, 07:07 AM

Are all the sheets in the same workbook? Or separate?

Copy from differnet sheets & paste into another sheet to form new report

LinkBack

Thread Tools

Rate This Thread

Display

Copy from differnet sheets & paste into another sheet to form new report

Re: Copy from differnet sheets & paste into another sheet to form new report

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Paste value form one sheet into another sheet based a match of the value in both sheets

[SOLVED] Copy and paste a range form one sheet to another.

Macro to copy and paste range form one sheet to next available row in 2nd sheet

Copy/Paste special form one sheet to another into first open colum

Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep

copy from one sheet and paste into other sheets

Copy and Paste problem:macros to copy sheet form one file and paste

Bookmarks

Bookmarks

Posting Permissions