Money in Excel need help

%3CLINGO-SUB%20id%3D%22lingo-sub-2349724%22%20slang%3D%22en-US%22%3EMoney%20in%20Excel%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2349724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20a%20%22newby%22%20so%20my%20apologies%20if%20this%20sounds%20too%20basic.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20linked%20my%20bank%20account%2C%20I%20change%20an%20entry%20under%20the%20category%2C%20how%20can%20I%20ensure%20all%20prior%20entries%20that%20match%20will%20change%20as%20well%3F%20For%20example%2C%20a%20transaction%20from%20Home%20Depot%20was%20entered%20as%20%22shopping%22.%20I'm%20a%20masonry%20contractor%20so%20I%20changed%20the%20category%20to%20%22materials%22.%20It%20changed%20it%20to%20that%20single%20entry%2C%20but%20I'd%20like%20it%20to%20reflect%20in%20all%20past%20entries%20as%20well.%3C%2FP%3E%3CP%3EHope%20someone%20helps%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2349724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am a "newby" so my apologies if this sounds too basic. 

I linked my bank account, I change an entry under the category, how can I ensure all prior entries that match will change as well? For example, a transaction from Home Depot was entered as "shopping". I'm a masonry contractor so I changed the category to "materials". It changed it to that single entry, but I'd like it to reflect in all past entries as well.

Hope someone helps:)

1 Reply
Anyone? LOL