Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update one sheet with VBA from another sheet
Does anyone know how to update (replace contents of )a range with the content of another sheets. In fact: A have a sheet with in column A range 20 till 30 a range of names. The name of the sheet differs every week according to the weeknumber. In another sheet i have the new names en while opening this recent sheet i want it to lookup the most recent weeksheet and open it and replace the contents with the most recent one. Has anyone an idea how to do this. Thanks in advance René Kerstgens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update an excel sheet dynamically from another excel sheet? | Excel Discussion (Misc queries) | |||
Update a autofilter sheet from another sheet | Excel Discussion (Misc queries) | |||
Update from different sheet | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
update sheet on the web | Excel Discussion (Misc queries) |