Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding new data to an excel worksheet
i have a worksheet which contains weekly data for some purchases. eash week i
get a spreadsheet with this weeks transactions. I would like to add the new data to the exsisting data automatically. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding new data to an excel worksheet
Yes, it is possible with Excel VBA Programming.
*** Please do rate *** "HSUK" wrote: i have a worksheet which contains weekly data for some purchases. eash week i get a spreadsheet with this weeks transactions. I would like to add the new data to the exsisting data automatically. Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding new data to an excel worksheet
Thanks, where do i start with the VBA Programming?
"Naveen" wrote: Yes, it is possible with Excel VBA Programming. *** Please do rate *** "HSUK" wrote: i have a worksheet which contains weekly data for some purchases. eash week i get a spreadsheet with this weeks transactions. I would like to add the new data to the exsisting data automatically. Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding new data to an excel worksheet
I don't know your exact requirement, but it is possible,
for instance, piece of code, which is shown below will copy from one location to another location, automatically, ========================================= Sub Naveen() lstrow = Cells.SpecialCells(xlLastCell).Row Rows("1:" & lstrow).Copy Rows(lstrow + 1).Insert Shift:=xlDown End Sub ========================================= Please post your exact requirement. *** Please do rate *** "HSUK" wrote: i have a worksheet which contains weekly data for some purchases. eash week i get a spreadsheet with this weeks transactions. I would like to add the new data to the exsisting data automatically. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel |