Moving data from one sheet to another - advancing one cell a

[Drew986]

Hello thanks very much for your service. I have an Excel question and I hope that you can help me.

I need to be able to pick up data from a specific cell in a worksheet and place it in another worksheet each day. Essentially I want to make a time series of these data points so that I need to write a macro that instructs Excel to export the data into a cell that advances by one each day.
I am unsure of how to tell themacro to drop the data in a cell that advances by one each day.


Thanks for your help

 

[Jim North]

Hello Drew986,

Welcome to the board!

It sounds like what you need to do is to create a VBA sub procedure that finds the next available row in a certain column and moves the value of one cel into that row. Search on "(xlUp)" (without the quotes) and you should find some code to get you started.