Copy Data by month to table using Inputbox with Add or Delete Row

[CemHyur]

Hello Folks,

I neel little help to copy data from my Sheet(WrkingSheet) and Paste to TablebyMonth in another sheet (Diff) (didn't get attach option, so attached mini-sheet). 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.

Please check.

I am new here so please help me if anywhere I am mistaking.


Below is WorkingData Sheet...

Book12.xlsm
	A	B	C	D	E	F	G	H	I
1
2
3		Date	Des.	Value
4		01/04/2022	ABC	11000
5		01/05/2022	DEF	12000
6		03/06/2022	GHI	14000
7		08/07/2022	JKL	15000
8		08/06/2022	MNO	16200
9		15/07/2022	PQR	5100
10		12/05/2022	STU	2100
11		04/05/2022	VWX	64201
12		09/04/2022	YZA	54621
13		25/04/2022	BCD	15000
14		24/05/2022	EFG	30001
15
16
17
18
19
20		Working Sheet
21
22
WrkingSheet

Below is Diff Sheet...

Book12.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2				Date	Des.	Value		Diff Value	Remark
3
4				April								Table Name: Diff_April
5	DATA REQUIRE IN TABLE
6	AS LIKE RequireLikeThis
7	SHEET
8
9					TOTAL	0
10
11				May								Table Name: Diff_May
12
13
14
15
16
17
18					TOTAL	0
19
20				June								Table Name: Diff_June
21
22
23
24
25					TOTAL	0
26
27
28				AND SO ON
29
Diff

Cell Formulas
Range	Formula
G9,G25	G9	=SUM(G5:G8)
G18	G18	=SUM(G12:G17)

Require to paste data like this...

Book12.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2				Date	Des.	Value		Diff Value	Remark
3
4				April								Table Name: Diff_April
5	DATA REQUIRE IN TABLE			01/04/2022	ABC	11000
6	AS LIKE THIS BY MONTH			09/04/2022	YZA	54621
7				25/04/2022	BCD	15000
8	WITH ADD OR DELETE
9	ROW IF REQUIRE				TOTAL	80621
10
11				May								Table Name: Diff_May
12				01/05/2022	DEF	12000
13				04/05/2022	VWX	64201
14				12/05/2022	STU	2100
15				24/05/2022	EFG	30001
16
17
18					TOTAL	108302
19
20				June								Table Name: Diff_June
21				03/06/2022	GHI	14000
22				08/06/2022	MNO	16200
23
24
25					TOTAL	30200
26
27
28				AND SO ON
29
RequireLikeThis

Cell Formulas
Range	Formula
G9,G25	G9	=SUM(G5:G8)
G18	G18	=SUM(G12:G17)

 

[CemHyur]

Update:
I have tried this code but this is paste data into sheet with month name. (copy data by inputbox based on month)

I want to paste data in same sheet but different table. And require to replace data if any old/other data present in that cell with add or delete row as per entry.

Thank You.

 

[Joe4]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Copy Data by month to table using Inputbox with Add or Delete Row - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[CemHyur]

My Apologies. I have posted there for answers.

Also Thank you for guiding me.

Next time sure, I'll paste link too.


This Question also posted at:

Copy Data by month to table using Inputbox with Add or Delete Row - OzGrid Free Excel/VBA Help Forum

Hello Folks, I need little help to copy data from my Sheet(WrkingSheet) and Paste to TablebyMonth in another sheet (Diff) (Book12.zip attached here). Month name will provide in Inputbox, and acording to month provided, data of that particular month will…

forum.ozgrid.com

 

[CemHyur]

[Update]

Hello Friends,

Didn't get answer till now, so I have post this question in other forums also for looking the answer.

Here are the links:

Copy Data by month to table using Inputbox with Add or Delete Row - OzGrid Free Excel/VBA Help Forum

Hello Folks, I need little help to copy data from my Sheet(WrkingSheet) and Paste to TablebyMonth in another sheet (Diff) (Book12.zip attached here). Month name will provide in Inputbox, and acording to month provided, data of that particular month will…

forum.ozgrid.com

Copy Data by month to table using Inputbox with Add or Delete Row

Hello, Please help me 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...

www.excelforum.com

Microsoft Office Forums - View Single Post - Copy Data by month to table using Inputbox with Add or Delete Row

Discussion forum on Microsoft office software such as Word, Excel, Outlook, PowerPoint and Project.

www.msofficeforums.com

Copy Data by month to table using Inputbox with Add or Delete Row

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...

chandoo.org