I need a macro that will search an excel spreadsheet for a specific text. If the text is found than I need it to store a value from a neighboring cell then procede to search the rest of the sheet and in the end sum all the values found and display the results in a specific cell.
abchigley 0 Newbie Poster
debasisdas 580 Posting Genius Featured Poster
Can you kindly post what have you done so far.
abchigley 0 Newbie Poster
So far I have been getting by with just a ton of if/then statements at the far end of my spread sheet. The spreadsheet is an organization chart with cell groups representing people within the company and in one specific cell, their position. In another cell, also specific to the represented person, is the amount of weeks they will be on the job. The amount of weeks for common to a position (manager, laborer, etc) need to be totalled. I have no code experience and am presently going through whatever free tutorials I can find online, but any help is appreciated.
cguan_77 8 Nearly a Posting Virtuoso
post what you've done, just take out important data replace with any data to simulate what you're trying to achieve..
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.