copy/paste using vba

I want to copy the contents of cell A5 to the bottom of a list that begins at D10 of the same sheet and goes down that column as new values are added to the list. For example, if the list now extends to D18, I'd like the value currently in A5 to be pasted to cell D19. At a subsequent time I'll...

Hey all, I'm new to VBA coding and not quite sure where to start with this project nor do I know if it is 100% doable. Below is a image for an overview of what my data looks like: Imgur: The most awesome images on the Internet What I'm trying to accomplish: A table in the "Monthly Cals"...

Hi there! I have a large worksheet that gets pulled monthly that I need to break out into separate worksheets and then further into individual client workbooks. I have created a macro that adds an identifier (Job#) in Column A. Ideally, this code would blast each row associated with an...

I have successfully adapated Michael M's code (found here, Post #4) to meet my needs (thanks much, Michael!). However, rather than add the pasted data to the end of the data, I wish to overwrite the previously pasted data (paste data at A5 everytime the macro is run). I suspect it has to do...

Hi there!! I have a “soft copy” of an 80-page report that was downloaded from an older mainframe system. The soft copy was in a .txt format, and I imported it into Excel using fixed-width delimiters for the columns. Since the report is 80-pages, it translates to almost 2,000 rows of data in...

Good Morning - I am new to the forums and spent much of the past two days reading through threads to try and accomplish this but with little success. With little familiarity with VBA (I had to use the Macro recorder to just get this done) - I would like this code which runs correctly for the...

Hi all. here is what I have. I am guessing that not specifically calling out the sheet where the ranges are is my issue here. I am trying to copy a range in workbook "A" and paste it in workbook "BUTTON" without activating it. Windows("BUTTON.xlsm").Range("joey") =...

I get emailed a spreadsheet every other day with sample data information on it. I have taken one spreadsheet and typed our specifications beside the values and wrote if/then statements to evaluate accept/reject. Is there a way I can save the two columns of info (spec & if/then) and paste them...

Hi, I'm new at the forum. I'm having trouble to get the right command to copy content from a website and paste it in Excel using VBA. I already tried the "Data -> import data from Web", but it only work in some cases. There are websites that doesn't allow this command. So, I already know how...