VBA to resize table after paste in new daily data

captainxcel

New Member
Joined
Jul 28, 2017
Messages
17
Hi Everyone and Happy New Year.

I paste my trading positions from a csv file into an Excel table on a daily basis, with each position in a row and tickler, price, and shares in the columns. That table then feeds various other sheets, tables, formulae, etc. A macro to do this manual pasting process is being created by me right now.

So far, my macro successfully opens the csv file (using a * wildcard as the filename changes daily with a new date), successfully copies the date, successfully switches back to the Excel file from the csv file. Now I just need to paste the data into the table fully overwriting the previous day's data and resize the table if necessary. Resizing the table is only necessary if the number of rows < the number of rows from the previous day.

Any ideas?

Thanks in advance.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,126,932
Messages
5,621,676
Members
415,849
Latest member
PhoenixRising2015

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top