Hello,

Please help to copy data from my Sheet (Sheet Name: WrkingSheet) and Paste to TablebyMonth in another sheet (Sheet Name: Diff) (Book12.zip attached here). Month name will provide in Inputbox, and acording to month provided, data of that particular month will go in the Table of that Month.

I have added the code in workbook but this is pasting data in month name sheet.

I have tried code but it is paste data into sheet with month name. (copy data using inputbox based on month) I want to paste data in same sheet but different tables. And require to overwrite data if any old/other data present in that cell with add or delete row as per entries.

Please check.

Thank You.





This question also posted here:
Copy Data by month to table using Inputbox with Add or Delete Row | MrExcel Message Board
Copy Data by month to table using Inputbox with Add or Delete Row - Excel VBA / Macros - OzGrid Free Excel/VBA Help Forum
Copy Data by month to table using Inputbox with Add or Delete Row
Copy Data by month to table using Inputbox with Add or Delete Row | Chandoo.org Excel Forums - Become Awesome in Excel

Attached Files

Book12.zip (25.2 KB, 6 views)