Need Help With A lot !!!

[Nicole]

I need help with my spreadsheet, i've been asked to create a
spreadsheet that will be updated quite frequently, macros are required
to run all of these tasks but i don't know how to get the tasks to
work the way they're needed... my first task is to sort certain
columns, but they're always being updated (new rows get added)... can
anyone tell me how i include the new data each time when i sort (i
need this to be automatic).

My second task is to create a graph using certain data, but i get the
same problem i don't know how to include new data automatically when i
select the fields i need the new ones aren't included.

The third task is protecting the sheet, yet again the same problem how
do i include the new data that i want protected.

im not sure if what i just said is easy to understand, this is
basically how my spreadsheet is set out....in row 9 i have headings..
row 10 is where a new row gets added to insert more data so if anyone
can help me let me know please, i'd really appreciate any help.

Thanks, nicole

 

[BrianB]

You seem to be on a steep learning curve ! I don't think that you will
get a lot of assistance from this sort of approach - most of us are
professionals who make a living out of Excel and so will write your
application for you - for a fee.

1. You need to get yourself organised. The first step with any
application is to do the job manually, so all your worksheets are set
up and you get the routines right. Collect all the workbooks etc. into
a single folder on disk.

2. The next step is to set the macro recorder and record your actions.
We all still do this at times, however experienced. Saves a lot of
time, and sets the running order for the routine. Starting from a
"blank sheet" is often very difficult - as you have now discovered.

3. Now, when you need help, you can post *specific* questions on the
message board (only one subject per posting) and include (copy/paste)
your code where necessary. Say what you are trying to achieve, and
what you get instead. Also make sure that the Subject of your message
is appropriate. If the answer you get is not appropriate you may need
to post again, many of us do not read messages that already contain
answers.

Good Luck & Regards
BrianB
======================================