We are assuming you have Activities, Duration etc in Excel spreadsheet.
We always do this.
Copy the whole column of 30,000+ durations;
Switch to Project;
Click top cell in duration column;
Paste;

--
Regards
PY & Associates
"the dude" wrote in message
...
Cut and paste would be easiest, but incredibly time consuming. As i
said, (ideally) the responsible parties will update a template
containing tasks relevant to them. The macro will then locate those
tasks dispersed throughout the 30,000+ lines and update accordingly.
Because this could/probably will be done numerous times throughout the
duration of the project, it would be much more efficient to have a
macro take care of the searching and locating, then copying/pasting
automatically.

I've been pointed to references by others and will post them here
after i've had a chance to do some research, but if anybody out there
has any ideas please let me know.

Thanks again.

On Dec 8, 8:45 am, "KC Cheung" wrote:
Why we cannot use simple cut and paste please?

--
Regards
PY & wrote in message

...