Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste to different rows on different dates
I want to update sheet1 every day with row data. Each row means one day.
The data which is to be pasted in today (say row10), comes from Sheet2(say B2:H2). This data (B2:H2) gets updated during working hours, and I have final figures at the end of day. Once I have final figures, I want to paste them into Sheet1 every day, in a manner that if today's data goes to row10, tomorrow's data should go to row11, and so on. Column A in sheet1 contains date. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste to different rows on different dates
Use the following code :
Sub test() With Sheets("Sheet1") .[A65000].End(xlUp).Offset(1) = Date [Sheet2!B2:H2].Copy .[A65000].End(xlUp).Offset(, 1) End With End Sub HTH Daniel I want to update sheet1 every day with row data. Each row means one day. The data which is to be pasted in today (say row10), comes from Sheet2(say B2:H2). This data (B2:H2) gets updated during working hours, and I have final figures at the end of day. Once I have final figures, I want to paste them into Sheet1 every day, in a manner that if today's data goes to row10, tomorrow's data should go to row11, and so on. Column A in sheet1 contains date. Please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste to different rows on different dates
Works ! :-)
Thanks "hsg" wrote: I want to update sheet1 every day with row data. Each row means one day. The data which is to be pasted in today (say row10), comes from Sheet2(say B2:H2). This data (B2:H2) gets updated during working hours, and I have final figures at the end of day. Once I have final figures, I want to paste them into Sheet1 every day, in a manner that if today's data goes to row10, tomorrow's data should go to row11, and so on. Column A in sheet1 contains date. Please help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste to different rows on different dates
Is it possible to restrict use of the macro which u gave for only once in a
calender date. I mean, if I have already used it to update today's data, it should not be activated again on same date. If someone tried to do it again, can it say b poping up a message box and say, it is already done (or whatever message i would like to print on it)? "hsg" wrote: Works ! :-) Thanks "hsg" wrote: I want to update sheet1 every day with row data. Each row means one day. The data which is to be pasted in today (say row10), comes from Sheet2(say B2:H2). This data (B2:H2) gets updated during working hours, and I have final figures at the end of day. Once I have final figures, I want to paste them into Sheet1 every day, in a manner that if today's data goes to row10, tomorrow's data should go to row11, and so on. Column A in sheet1 contains date. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Copy and Paste onto Same Rows after filtering out rows. | Excel Discussion (Misc queries) | |||
copy/paste with hidden rows don't want hidden parts to paste | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |