Home

How to move specific cells in a row to a specific sheet based on cell value.

%3CLINGO-SUB%20id%3D%22lingo-sub-623764%22%20slang%3D%22en-US%22%3EHow%20to%20move%20specific%20cells%20in%20a%20row%20to%20a%20specific%20sheet%20based%20on%20cell%20value.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623764%22%20slang%3D%22en-US%22%3ESo%2C%20I%20have%20a%20workbook%20with%20every%20letter%20of%20the%20alphabet%20as%20a%20sheet.%20My%20goal%20is%20have%201%20sheet%20where%20all%20the%20data%20is%20typed%20into%20and%20(hopefully%20via%20a%20module%20or%20macro)%20have%20excel%20send%20said%20data%20to%20the%20proper%20sheets.%20The%20way%20it%20should%20decide%20what%20goes%20where%20is%20by%20first%20letter%20of%20name.%3CBR%20%2F%3EAlso%2C%20i%20want%20to%20add%20another%20sheet%20that%20cherry%20picks%20specific%20data%20to%20move.%20For%20example%2C%20sheet%20'A'%20receives%20the%20full%20row%20of%20data%20regarding%20people%20who's%20last%20name%20starts%20with%20A%2C%20but%20sheet%20'Report'%20receives%20only%20the%20person's%20name%2C%20date%20of%20birth%2C%20and%20phone%20number.%3CBR%20%2F%3EAny%20help%20or%20guidance%20would%20be%20greatly%20appreciated.%20Thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-623764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Dumorte
Occasional Visitor
So, I have a workbook with every letter of the alphabet as a sheet. My goal is have 1 sheet where all the data is typed into and (hopefully via a module or macro) have excel send said data to the proper sheets. The way it should decide what goes where is by first letter of name.
Also, i want to add another sheet that cherry picks specific data to move. For example, sheet 'A' receives the full row of data regarding people who's last name starts with A, but sheet 'Report' receives only the person's name, date of birth, and phone number.
Any help or guidance would be greatly appreciated. Thank you.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies