vba to copy an entire row or a range and paste values to next available row

**bouncer84** · 07-21-2012, 04:17 PM

once again a newbie alert. I am having some serious difficulties in copying an entire row (which is constantly updating) into a new row each time. The purpose of that is to record some stocks value with the current time and to generate them instantly into a table and to automatically updating scatter chart.
I am currently using this module:

Please Login or Register  to view this content.

but the problem with this one is when the copy is done into a table (to automatically generate into a chart) the time value (which is done in cell B2 by the =now() function) is copied not into the same row in which the stock date is generated in the table.

well a long story short, I need help to adjust that module into one that will copy the full row (or a certain range, lets say A1:A10) and not the specified values separately like its done now. Help will be much appreciated.

**fredlo2010** · 07-21-2012, 04:31 PM

Can you post a sample of your workbook?

You can try .resize to achieve what you want. Also it would be good to use the rows counts as variable. I cannot see how without the copy, maybe an expert can. Whats the column with the longest data?

Thanks I hope that helps

**bouncer84** · 07-22-2012, 01:56 AM

well i attached the file. basicly cell A1 is now function because I want the time stemp each time i copy the values of this row (for the chart and record). All i need is your help in setting the most simple macro that based on time trigger to run constantly (every amount of seconds defined by me) and copy the first row with the updating data each time to a new row so it will be available in the data table.

**patel45** · 07-22-2012, 02:46 AM

It's impossible to check your file, we need Distribution.xlsx

**bouncer84** · 07-22-2012, 04:56 AM

Basiclly the distribution file is not important because its only an online feed that I take my data from. It could as well be a refrence to a cell located in a diffrent worksheet.
The help I ask for is by copying the first row and paste only the values of it into a new row each time to feed my table.