Help: Changing Data on one sheet to reflect changes on another.

[ventujep]

Goodmorning all! I am new here, and I am tremendously glad to join this community. However, like many of you, I have a bit of a problem with Excel.

My goal is to have changes done to one sheet reflect on to another to make things much more easy to do. Below is a picture of what I am dealing with. ( I covered some personal information)

pic of excel.jpg I want to be able to plug in something or delete it and have it reflect to all other sheets. Can anyone help me. I wouldnt mind giving you the file however i would want to protect all personal information before I do so.

Also I would like to be able to plug in some information and have it export itself based on a specific infromation. For example, I would want all Newark,NJ contacts to be place in the Newark list automatically.

Thank you so much guys!

[Richard Buttrey]

Hi, and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Please don't upload pictures. None of us are inclined to recreate your data when you have a workbook available - see guidelines in the Rules area of this forum.

However are you sure you have designed this in the right way? The fact that you find yourself asking questions like how can I replicate this, or how can I export it might suggest not. Tell us what your ultimate goal is, not the steps you think you need to take to get there and no doubt we can advise further. But first upload the workbook - anonymised as mentioned.

[ventujep]

Thanks for the quick Reply. Sorry for the problems above.

However, just to be clear, I am not the creator of this file. It was passed down to me, with the purpose of making it easier to insert and delete Data.

I have not designed this worksheet at all. It only has raw data, meaning that it has no formulas at all.

I would like to be able to plug in data and have it automatically plug itself into the other sheet. However the way the sheets are divided is by Commodity Class, Vendors Name, and Newark Vendors Only(dont mind the 1X Mail List).
So in the first two worksheets (Commodity Class and Vendors name) I would want to be able to plug in data in one worksheet and have it reflect on the other worksheet, and if the location of one of the data is in Newark, than I would like for it to automatically be pushed to the Newarks Vendors Only worksheet.

I am providing a anonymous version of this file which include no location, or phone numbers.

P.S I am sorry if i'm not explaining well. I am only 18, and I am not computer savvy.
I also had to delete alot of data to accomodoate the size limit.
Annonymous Copy Bidder List.xlsx

[Richard Buttrey]

Hi,

You're telling us what you want to be able to do with the sheet as it currently designed and laid out.

I suggest that there will be a much better way to do this if you can tell us your ultimate goal. i.e. What do you want the workbook to tell you AT THE END OF THE DAY? On the face of it there seems little point on having data copied from one sheet to another if you can filter the main data sheet to show you precisely what you want. Don't be restricted by the way the current system has been set up.

[ventujep]

@Richard- Yes I do understand and completely agree with you. The system as it is, is really inefficient, however I must have two data sheets with the same entries because this is the way they want me to have it.

You must understand that I work for City Hall and many of the workers here in the city are far too old to understand how to filter, so they wish to have two of the same sheets, except having one filtered by Commodities Class, and the other one by Vendors Name.

Now, to answer your question, what I want the workbook to do is to simplify the steps necessary to plug in new data, without having to copy and paste manually. Also, most importantly, I want to be able to delete, and edit specific information without the need to repeat it multiple times. In many cases, we have multiple phone numbers and address for the same vendor because workers forget to plug them into the other sheets, causing major confusion and lost of money. Mind you, we have thousands and thousands of vendors from all over the country. It is very important that all information is correct and updated in the most efficient way.

I want the workbook to tell me all the information in three sheets, one filtered by Commodity Class, the other by Vendors name, and the third sheet should tell me all the vendors name located in Newark,NJ. Although I disagree with having two identical sheets, it is required to have it.

I am very sorry, I just can't explain myself very well.