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

CemHyur · #5 11-15-2022, 03:41 AM

Ok... Got it...means I Have to refresh data whenever new data will be added.

Quote:

Originally Posted by p45cal

it might stop it expanding to the right if you want to add more columns to it

There is no more Column Excel 3 Main Columns (Des., Date & Value) and 4 Comment Columns (Blank, Diff in Value, Remark, Blank). Except this there is no any other columns.

Data will updated (Added) Every month in Raw Sheet, only Changes (Delete Old and Start with New Data) will come in New Year.

And Also I have formula below that table that Total Value Less Diff Value, So this will stay as it is or I have to Add when refresh data?

Sorry for trouble, I know that pivot is something in excel but never use it. So i have lots of question about this.

Thank You.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table Merge _ Auto Delete Blank Lines (without Data)	Alex1s85	Mail Merge	7	05-04-2020 05:12 AM
Copy Data from different areas in a worksheet into a Table	Josh1012	Excel Programming	2	09-20-2018 01:51 AM
copy data table from pdf to excel	DIMI	Excel	1	07-10-2018 11:40 PM
Delete table if cell has data	So New2 This	Word VBA	1	05-06-2013 09:00 PM
Copy/Paste/Delete Table & Section etc.	flds	Word VBA	40	07-16-2011 07:34 AM