copy paste

I'm a new Excel Macro user and need all I can get. From multiple workbooks (source) (with same format), i need to copy multiple non contiguous cells ( say A2:A5, B1, C3, D8:D10) and paste them horizontally on another workbook (destination) starting at cell A6. Then need to do the same for the...

Hi guys!!! Need help in optimizing a code I put together to do the following: 1. Cycle through all the *.dat files in the folder where the main file is located. 2. The *.dat file is opened. 3. Occupied cells in Column A are copied. 4. Data is pasted in the main file. 5. *.dat file is closed...

Hi all, I have a code that logs into a web site and navigates to a certain page, the code works great up to this point, i want the code to select all and copy to be pasted into a worksheet later. The problem is that the code wont select all the webpage unless i click the page as im stepping...

Hi there Can someone please help me with some VBA code. I have a Business Objects report exporting cumulative daily sales by month to Excel (Export sheet). Unfortunately when a new month starts the cumulative daily sales is reset to zero. I want to be able track the end total for each...

I am currently using the following code to Copy a sheet so that it ends up directly after the 1st sheet in the workbook. Sheets("Needs Assessment").Copy after:=Sheets(1) ActiveSheet.Name = "Initial Assessment - " & Format(Range("L81"), "mm-dd-yyyy") How can I modify the above code to only...

How do I take one worksheet lets call it "Test1" copy it and paste it into the same workbook with a new name "Test1 - (todays date)"?

I have 80 columns of raw data with static headers that are produced out of an ERP system, however the report run is not consistent in placing the data in consistent column letters. I am looking for a solution to auto-copy the raw data into a formatted worksheet that can identify the data based...

never mind. I posted a wrong question that I couldn't find how to delete

April 21, 2010<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Dear Experts,<o:p></o:p> There’s a couple of questions I posted [link below] which I’m not sure I got a n answer for. I would appreciate all the help you can give me on this ones.<o:p></o:p>...

Hi Gurus.. I have a textbox where I want user to only type in manually and not copy any text from somewhere and paste it into the textbox. How do I disable the paste option when the cursor is in a textbox. This is what I tried and the reason it failed: Private Sub txtPassword_Enter()...

I have data in Excel in 3 columns. Column A has Date Column B has Time Column C has Stock Price <o:p> </o:p> I am trying to copy the stock price for a certain time interval each day for different dates and paste them to column F. <o:p> </o:p> eg. I would like to copy stock...

I have the following code which takes a source range (containing text and numbers) and cycles through it copying and pasting into the next column and moving the values down one row each time, the values that drop off the bottom are placed at the top of the newly pasted range ie aaa1 aaa2 aaa3...

I am trying to copy and paste only the 1 values in column B to paste onto column A. How can I do this without completely pasting over column A? Thank you! Example of what I see on my Excel sheet below ---A B 1--1 blank 2--5 1 3--0 1 4--0 blank 5--5 1 6--1 1 7--5 blank

Well the good news is that I got the macro written correctly. Bad news is that it is too long. So here goes my question: How can I get this shorter? Background is that I'm working on an excel workbook to solve Soduko puzzels. I wanted to push my excel skills and see how I could use excel to...