find and add

Hello All - When I copy a Balance Sheet from a website the negative figures map over like this "(100,000" as the other parenthesis pastes to the next cell. I then have my own formatted Balance Sheet elsewhere on the worksheet and am able to use Index(Match) to pull over the initial figures I...

Hi All, I have tried various ways and still finding problems so I hope you are able to assist. I currently have a new macro which pulls a text file. In turn adds various points to a leading track. The end points may have 1/2/3/4 different end points and inn turn the leading tracks may also...

Hi, I work for a call center and I am in charge of keeping track of agents' statistics on a weekly scorecard. Because it is a call center we have high turnover meaning that my list of agent names changes frequently. I want a macro that can combine these weekly scorecards into a monthly...

Hi Team, Trying to achieve: I want to be able to run the below macro on the next available blank cell in column D. Code: Range("D6").Select ActiveCell.FormulaR1C1 = "Not Started" Range("D6").Select Application.Goto Reference:="R6C4:R6C17" Selection.FillRight...

Hi. I've tried using VLOOKUP, but I guess that didn't work because I need full values and not parts. Column A has text that I need to transcribe into Column B as a specific Category. For instance, for every time "RX" appears in column A (not standalone necessarily) I need Column B to write...

This problem may be easier to solve than describe, I hope so... anyway: I have data in 2 workbooks, call them book1.sheet1, and book2.sheet1. Book2 has very little data (at present only 4 rows, but this will be different each time the macro is run), book1 has roughly 780 rows. I need to:- 1/...

I need to find the total spent on each category in the below table example but only from the month of january. then show a userform with the data as a Quick Report. Can someone start me off.... the Date cells shown here are actually text.. not formatted cells with a full date so we can...

I apologize in advance for a newbie question (but im learning :) ) I have a worksheet with around 10,000 line items, about 2000 of them are the same or similar item, yet are all over the sheet and not in order. Is it possible to do a "Find" or a "Find / Replace" for an item say in Column E and...