Making a row duplicate in another table

%3CLINGO-SUB%20id%3D%22lingo-sub-2687301%22%20slang%3D%22en-US%22%3EMaking%20a%20row%20duplicate%20in%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2687301%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20of%20expenses%20in%20my%20bussiness's%20sheet%20and%20it's%20all%20really%20messy%20for%20me%2C%3C%2FP%3E%3CP%3EI%20want%20to%20know%20if%20it%20is%20possible%20to%20add%20a%20column%20%22catagory%22%20(for%20example%20transportation%2C%20tools%2C%20food%20etc.)%3C%2FP%3E%3CP%3EAnd%20then%20by%20the%20value%20I%20insert%20in%20that%20column%20the%20Excel%20sheet%20will%20automatically%20add%20the%20column%20in%20another%20table%20which%20represents%20the%20catagory.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20number%20of%20catagories%20is%20constant%20and%20the%20tables%20will%20be%20made%26nbsp%3B%3CSPAN%3Eprematurly%20by%20myself%20the%20ONLY%20thing%20i%20need%20the%20Excel%20sheet%20to%20do%20it%20to%20copy%20the%20values%20and%20insert%20them%20in%20another%20table%20that%20represents%20the%20catagory%20according%20to%20the%20value%20I%20insert%20in%20the%20main%20expenses%20table.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20it%20possible%20%3F%20and%20if%20YES%2C%20how%20can%20i%20do%20it%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ETHANK%20U%20FOR%20READING%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2687301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2688191%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20a%20row%20duplicate%20in%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138247%22%20target%3D%22_blank%22%3E%40KHRUI10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20definitely%20possible.%20The%20easiest%20way%20to%20show%20you%20would%20be%20if%20you%20could%20share%20a%20copy%20of%20your%20actual%20workbook%20so%20we%20could%20see%20how%20it's%20laid%20out%20and%20work%20with%20that.%20The%20truth%20is%20there%20are%20probably%20several%20ways%20to%20accomplish%20what%20you're%20describing%2C%20and%20which%20of%20those%20several%20ways%20would%20depend%20on%20the%20starting%20point.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20unless%20you%20have%20a%20lot%20of%20data%20you%20want%20to%20keep%20confidential%2C%20please%20post%20a%20copy%20of%20your%20workbook%20here%20(not%20an%20image%3B%20the%20actual%20workbook).%20If%20you%20want%20to%20keep%20the%20real%20thing%20confidential%2C%20then%20post%20a%20mock-up%20with%20made%20up%20names%20and%20details.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello everyone

 

I have a table of expenses in my bussiness's sheet and it's all really messy for me,

I want to know if it is possible to add a column "catagory" (for example transportation, tools, food etc.)

And then by the value I insert in that column the Excel sheet will automatically add the column in another table which represents the catagory. 

The number of catagories is constant and the tables will be made prematurly by myself the ONLY thing i need the Excel sheet to do it to copy the values and insert them in another table that represents the catagory according to the value I insert in the main expenses table.

Is it possible ? and if YES, how can i do it?

 

THANK U FOR READING

1 Reply

@KHRUI10 

 

It is definitely possible. The easiest way to show you would be if you could share a copy of your actual workbook so we could see how it's laid out and work with that. The truth is there are probably several ways to accomplish what you're describing, and which of those several ways would depend on the starting point.

 

So unless you have a lot of data you want to keep confidential, please post a copy of your workbook here (not an image; the actual workbook). If you want to keep the real thing confidential, then post a mock-up with made up names and details.