Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replacing data on a non focused worksheet with calculated data from the same sheet
I have a sheet (15min) and I have the last row filled with numbers ( col
k-q) What I need to do, is to : first, I need to copy the top row, l-q to a new row at the bottom. I am doing that with the following: With Sheets("15min").Range("A2:G2") 'this needs to be updated with calculating data .Parent.Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Resize(1, 7).Value = .Value End With Then, I need to: fill the C of the last row with the L of the lastrow minus L from the second to last row fill the D of the last row with the M of the lastrow minus M from the second to last row fill the E of the last row with the N of the lastrow minus N from the second to last row etc... I need this to happen when I am working on another sheet in a form, so I can not change the focus. What would be the best way of doing this? Thanks, Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Imported Data Not Replacing Existing Data - Excel 2007 | Excel Discussion (Misc queries) | |||
Closing the current focused sheet | Excel Discussion (Misc queries) | |||
Replacing data | Excel Discussion (Misc queries) | |||
summary data sheet from worksheet to worksheet | Excel Worksheet Functions | |||
replacing data | Excel Discussion (Misc queries) |