Hello,
I currently input several peices of data into a table on one tab.
I extract 4 peices of this data into another table
contract date
crush month
option month
hedged basis
doing a formula like (assuming contract date is column A) =if(A1<>0,A1,"")
I have a macro that then copies this table and pastes it below. This information is entered daily, and we wanta cumulative tab to keep a running record.
The issue I'm having is that different amounts of data are input each day. Some days there may be ten lines some there may be 4. However the table is copied and pasted as 15 lines every day, although many return simply the "".
When the next day runs and pasts, there is a gap in the data, as I use Selection.End(xlUp) in the paste command.
Does anyone have any idea how I might get there to be no gap in the data? is there a way to paste over these "blank" cells?
I hope I was clear in my description.
Thanks for your help.
I currently input several peices of data into a table on one tab.
I extract 4 peices of this data into another table
contract date
crush month
option month
hedged basis
doing a formula like (assuming contract date is column A) =if(A1<>0,A1,"")
I have a macro that then copies this table and pastes it below. This information is entered daily, and we wanta cumulative tab to keep a running record.
The issue I'm having is that different amounts of data are input each day. Some days there may be ten lines some there may be 4. However the table is copied and pasted as 15 lines every day, although many return simply the "".
When the next day runs and pasts, there is a gap in the data, as I use Selection.End(xlUp) in the paste command.
Does anyone have any idea how I might get there to be no gap in the data? is there a way to paste over these "blank" cells?
I hope I was clear in my description.
Thanks for your help.
