Hi,
I am having a workbook with a number of sheets. All The sheets have the id number as the first column . but the remainig column sdiffer in all sheets.
THe first sheet shas a column called status.
What I want to do is for each id number whose status is yes i wantto update all fields for that id number in all sheets to 77777.
hope iam clear.
regards
thiru
Last edited by atksamy; 10-23-2008 at 03:47 AM. Reason: was not clear
Hi
The simplest way to do it would be to use an "IF" statement in the first column on each sheet so that the formula used a vlookup on the id range on the first sheets and returns "77777" if the lookup returns "yes" and the id number if it doesn't.
If VBA is the only or better alternative then check each id on the first sheet and use an IF statement within the code to check wether the status is "yes". If so then use the row value or a counter to go to the correct sheet and amend the id values to "77777".
If none of that is possible or you need some help on the code then post a couple of pages of the sheet here.
A
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks