By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Can we make column a to be the primary column in sheet 1 and sheet 2 so to autoupdate

P: 1
Ok here is the situation, i have a worksheet with multiple sheets in it and Column A in all the sheets has Client Names and the rest of the columns have diff types of data about them depending on the sheet. so if a new client comes in I have to update Column A one by one in all the sheets to avoid messing up the rows for existing clients.

is there a way through which i can map column A to all my sheets, so that if i have to add a new row for a new client all the other sheets auto-update themselves with this new row addition.

Sep 20 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.