copy & paste using vba

Hello, I have absolutely no training in VBA and have been able to piece together responses from this board previously to achieve my desired result. However, I've run into an issue that is beyond my piecemeal process. My current workbook has a master data sheet that is a register of the main...

Hello, I currently input several peices of data into a table on one tab. I extract 4 peices of this data into another table contract date crush month option month hedged basis doing a formula like (assuming contract date is column A) =if(A1<>0,A1,"") I have a macro that then copies this...

Hi All, (sorry for wordy post) A VBA newby, but I've tasted the CoolAid and I know how powerful it can be so I'm trying to improve my skills. In short, I'm trying to create a process to pull select data from a pivot table and copy it to a specific range on another sheet. The pivot table has...

I have 3 tables all in one worksheet that are linked to source data which is refreshed daily. Each table has the same column labels and I would like to stack them into a single table using vba. I currently have 2 problems: I would like to copy from the second row down in each table to the last...

I have a code where i am highlighting a cell in a worksheet (Step 1 - Manifold), clicking a commandbutton, then the value that was highlighted copies over to another worksheet (Smart Calc). It works great but the issue is that some of the cells that you highlight are merged. This means for...

Hi, Have just joined the forum here as it seems very helpful and looks like there are many experienced Excel users willing to help find solutions to 'problems'..... I am trying to develop a system to allow me select different parts from multiple sheets and then add them into a bill of material...

Hope the title's not too confusing. I'm trying to write a Macro that will take the value in B6 and copy it to a new sheet in cell A1 and copy it down the column based on the value in cell C6. Then do the dame for B7 /C7 and so on. I also need to add a set value into Column S for each line E.g...

Hello all, Thanks for helping me out with this one. ++ Dim wsCS As Worksheet Dim wsCOMBI As Worksheet Dim lastrowcs As Integer Set wsCS = ThisWorkbook.Sheets("RAW-CS") Set wsCOMBI = ThisWorkbook.Sheets("RAW-Combi") lastrowcs = wsCS.Cells(Rows.Count, 1).End(xlUp).Row wsCS.Range(Cells(2, 1)...

Dear all, I have googled for a long time but cannot find out what's wrong. Is it not possible to copy/paste when you use Range(Cell1,Cell2).copy / Range(Cell1,Cell2).paste This is my code and it doesn't work. Of course WS, lastrowgp and WS3 are dim-ed WS.Range(Cells(1, 1), Cells(lastrowgp...

Hi, I have a data table that is updated daily from an external data source. Each day, the macro overwrites the previous day's information and adds in some formatting/formualas to meet specification. This part all works very well. Where I am stuck is the data I am getting is incomplete for all...

Hi all I’ve inherited an old excel file from a colleague that I need to modify. My problem is that the file contains old XML-code and I need to convert this to VBA and I know next to nothing about neither XML nor VBA! I have one sheet (Sheet1) with data that changes each month. In cell B5...

Greetings, I've been searching and searching for a solution. I've been able some threads that address parts of what I need, but I'm such a VBA novice, I don't know how to put them all together. I'm hoping someone can help me create the code to get this done ... Excel 2003 Windows v8 --WHAT I...

Hi All, </SPAN></SPAN> I have 2 workbooks “Source” and “Destination”. “Source” contains 4 worksheets. I need to copy the data contained on each of those worksheets to “Destination”. Once the data is in “Destination”, it will be mapped to other worksheets within “Destination”. I need a...

Hi Team, Can anyone please help me out how to select top 10 visible range of cells those were filtered and copy paste the same data into different sheet. I need to update this code to updated in vba macro code. Please provide an resolution in order to fix this. NOte: Data is dynamic and it...

I have a functioning macro in a synthesis workbook that prompts the user to open a data file workbook, copy specific cells and then paste the data into the synthesis workbook, into the next available row (the macro does the copy/paste, not the user). This part works well. Where I now have a...

Can someone get me pointed in the right direction on creating vba to loop through folders and subfolders to copy/paste data from a specific cell in multi-worksheet workbooks? The cell is in the same place in all workbooks and is a named range/cell (jobnumber). The workbooks have a standard...

I have been racking my brain trying to figure out a quick way to resolve an age old issue I have. I currently have a workbook with 3 worksheets in it. The first worksheet is the reporting sheet, the second is before data, and the last is after data. On the reporting sheet, cell A1 is equal to...

Hello, this is driving me crazy and I really need some help. It must be some basic stuff I just cannot grasp. Anyway: I am using Excel 2010 on Windows 7 Typical situation of copying and pasting from one workbook to another. I do a similar procedure in another bit of the macro and it...

Hi All, I need help for the below activity. I am not well versed in Macros. Below is the scenario. 1. I have one Workbook, with two Worksheets named as; "People" & "Masterfile" In People Worksheet the Data is as below: <tbody> Column A Column B Column C Column D Column E...

hi, can somebody help me with this?? how do i get the items from this, [/URL][/IMG] to this.. [/URL][/IMG] pls teach me macro or vba code.....