Home

In need of help

%3CLINGO-SUB%20id%3D%22lingo-sub-360166%22%20slang%3D%22en-US%22%3EIn%20need%20of%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360166%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20know%20if%20there%20is%20a%20way%20to%20have%20excel%20identify%20a%20cell%20that%20has%20been%20highlighted%20on%20one%20tab%20and%20have%20it%20pull%20the%20number%20from%20the%20cell%20to%20the%20%3CSTRONG%3Eleft%3C%2FSTRONG%3Eof%20the%20highlighted%20cell%20onto%20a%20separate%20summary%20tab.%20The%20highlighting%20is%20done%20mostly%20by%20conditional%20formatting%20so%20it%20will%20always%20change.%20I%20am%20thinking%20this%20may%20need%20to%20be%20done%20in%20VBA%20but%20I%20have%20never%20done%20anything%20in%20it%20before%20and%20am%20not%20sure%20where%20to%20begin.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-360166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ineedhelp
Occasional Contributor

Hello,

 

I need to know if there is a way to have excel identify a cell that has been highlighted on one tab and have it pull the number from the cell to the left of the highlighted cell onto a separate summary tab. The highlighting is done mostly by conditional formatting so it will always change. I am thinking this may need to be done in VBA but I have never done anything in it before and am not sure where to begin.

 

Any help is greatly appreciated.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies