finding a cell in another work sheet

A

Andrew

Hi I'm new to macros. I've been trying to make a workbook that I can use at
work to track the progress of numerous projects. I have created a master
copy which will be modified for several different projects. When milestones
are reached the owner of the projects records this in the sheet in a colum
named "Done". This is compared to another column called "planned" and a
percentage can be made called "adherance to planned" This is then tracked for
each month for each ROW, (as each row will represent a new component of the
project).

In another sheet I devised a formatted repot to summaris the data. I got
this working, even made a macro to do it, But my problem is in worksheet 1,
extra lines will be added/deleted and the cell reference for the SUM of the
rows above will constantly have a different row address (same column). I
would like to up date my macro so that it copies a range of cells at the
bottom of my spreadsheet.

Any ideas would be appreciated.
 
S

Stefan B Rusynko

This is a FrontPage newsgroup
- you need to post this in an Excel newsgroup




| Hi I'm new to macros. I've been trying to make a workbook that I can use at
| work to track the progress of numerous projects. I have created a master
| copy which will be modified for several different projects. When milestones
| are reached the owner of the projects records this in the sheet in a colum
| named "Done". This is compared to another column called "planned" and a
| percentage can be made called "adherance to planned" This is then tracked for
| each month for each ROW, (as each row will represent a new component of the
| project).
|
| In another sheet I devised a formatted repot to summaris the data. I got
| this working, even made a macro to do it, But my problem is in worksheet 1,
| extra lines will be added/deleted and the cell reference for the SUM of the
| rows above will constantly have a different row address (same column). I
| would like to up date my macro so that it copies a range of cells at the
| bottom of my spreadsheet.
|
| Any ideas would be appreciated.
| --
| agibson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
finding a particular cell in another worksheet whose row number ch 1
Macro to Combine Data from Multiple Sheets with Cell References 4
conditional formatting, filtering then copying to another sheet 0
Macro help?: move row to other sheet when text is entered in cell 0
Checkbox issue - Checkbox overlapping when filter is applied 1
Conditional listbox cell populating 4
Create if partial match then copy and paste data from one cell to another 1

Top