copy & past

Does anyone know how to create a VBA code that copies all the numbers greater than 10 from a list, and pastes the numbers to the cell B3? The list starts from A3 to xlDown in A column, and there are various numbers in the list. Please somebody help me out with that...

Hello everybordy, I am new on VBA and I am tryng to copy specifc values from Sheet2 to Sheet1, but i don't know how to concatenate this values and how to copy the right values. My code copies but it's not working as i was expecting. Here is my code. Sub copyvalues() 'Declaration of...

Hey guys! I have a situation that I am trying to figure out how to do it...as I never dealt with writing macro for multiple sheets before. I have a Template Sheet and want to copy several cells (for example, cell B5 and C5) from another "Usable Data" Sheet into the Template and save it as...

Hi, I need a little help, I have a main excel file and i am copying 250 cells from a webpage. There are total 5 headers. Address - Lat - Long - East - North When i have around 3000 cells copied to main sheet. I have the headers 12 times in it. That means All these 5 headers " Address - Lat -...

Hi there, first time posting a problem on here so please be kind.... I am having a problem copying data from one file to another in Excel. This issue is unique to the destination file as when I create a new Excel document the problem does not present itself. I'm loathed to start from scratch...

Hi! I love this place! I'm running Excel 2007. I will be copying (or cutting) and pasting a row of cells into another worksheet that has accumulated over time. I'd like the cells I'm copying/cutting to automatically "adopt" the formatting of the cells already present. Basically, the cells in...

I am new to macros/VBA and I am trying to get a solution for mundane copy and paste from and to different worksheets in an excel file. This is to streamline making estimates and Invoices for an electrical contracting company. In the excel file (see link) I want to have a button in the Materials...

Hi Guys, I am trying do the following can someone help pls... Select F20:AA29, copy and paste as value Next Select range (F20+11:AA29+11) i.e. F31:AA40, copy and paste as value Next Select range (F31+11:AA40+11) - F42:AA51 and so on until last blank cell in the column A. I hope this...

Hi All, I'm looking for macro code to copy paste the data into different sheet. I would receive different files every time with same format but heading will not be in same column (but all columns will be there but not in order every time). My concern is how to copy the data which has unique...

Hi, I have a macro in one of my excel files that basically selects a list of cells from another page in the workbook and pastes those into the active cell. (it is a list of locations and nominal values) for example I would run this macro and paste it into say cell H30 tand it would fill in down...

Hi All, I have one typical task which need to complete by using macro. I have around 100's of excel files (note each file has only one sheet but names differs from file to file). I want to copy the each file sheet and paste it in master sheet and it should get paste one by one as like for...

Hi All, I need below requirement in order to complete my one macro. Let me explain in details with an example. I have data with lots of columns assume A to F. I would like to sort with total (Decending order) and if 'Zero' comes in any top 10 cells and then that row should not reflect for...

I have the following code Public Sub Copyworksheet() Dim wb As Workbook Set wb = Workbooks.Open("\\My file path in here", UpdateLinks:=True) wb.Worksheets("People").Copy before:=ThisWorkbook.Worksheets(3) wb.Close savechanges:=True Set wb = Nothing End Sub Which opens the specified workbook...

All, I am really a newbie in Visual Basic and looking for a code to do the following: I have a massive sheet in which the first column is the ID number of a product. The ID number can be a 'parent' ID, but also a 'child' or 'grand child' ID, which refer to sub products of the parent product...

So I'm trying to create a spreadsheet for my summer budget as I am college student that isn't making a lot of money over the summer. I seem to have everything correct except two rows. These two rows rely on an input that I plan to update. Rows 10 and 11 deal with how much I am paying myself for...

MrEXCEL Members, In need of your help, I have a workbook that we created for to produce codes for a unix server for bulk loading. the issue is, when we enter the information in to the cells that need information entered, and copy the populated cell data, paste it into notepad, it puts " on the...

I can not seem to be able to copy & insert/past. I also can not seem to copy a set of rows with formatting & formulas, then when I paste to a another row, it drops the formats & formulas. When I attempt the paste special, it only gives me the option to paste text. The only option I know of...

Hello, I have cells on four sheets that need data entry validations. I have entered the data validations, but this does not prevent copy/paste of the invalid entries. I have code that is testing validations, but I was wondering if there is a way to call the data validations to be run from a...

hi everyone, can someone please show what is the right vba syntax to copy the name of a sheet in order to past it in a cell? Thank a lot