Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel 2003 - a couple of simple questions.....

Mar 23, 2010 7:15AM PDT

well the questions are simple, don't know about the answers!

1. I have a worksheet in a workbook that is protected to stop users inserting values. However I want to have a macro to insert a row in this worksheet - is this possible?

and totally unrelated....

2. I have a list of names and other related info in a worksheet. I auto filter this list to get a subset of names. In another worksheet I already have this subset of names, in the same order, together with other data. I want to be able to copy this other data to the filtered list on the first worksheet so that the relevant info goes with the right person.

Hope this makes sense and greatful for any replies.

Dave

Discussion is locked

- Collapse -
(NT) Sorted problem 1 out now, thanks
Mar 23, 2010 8:02AM PDT
- Collapse -
(NT) Add columns with VLOOKUP-function.
Mar 24, 2010 1:48AM PDT
- Collapse -
Thanks...
Mar 24, 2010 4:08AM PDT

a possibility but rather messy in this instance because the second set of data does not always come from the same source.

- Collapse -
In that case,
Mar 24, 2010 7:49AM PDT

I've never used VLOOKUP, but it can still be done in your case.

Just create a new column somewhere, it can be hidden if you like, and use that to grab all of the data you need into one easily managed column. Then use VLOOKUP on that column. It's an oft-used method of tidying up data.

Mark