#vba #copypaste

'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...

how to make hyper link Button ?? when i click down in cell with show "Add New " Button (button is hyperlink) This Invoice Product name Combo box with show Hyper link button appears Out side the combo box, how to possible pleased Need this vba code , (Condition : How to fix same place in range...

Hi. I have data in multiple workbooks in a folder with the same template and I need to extract those circled data into one master workbook as below I have a code to loop thru all the workbooks in the folder but I do not know how to do the data copying/extracting. Thank you for any help!. Sub...

Hello, I have a problem work with two different type of workbook, it is a bit time consuming if I do it with a manual typing or copy pasting. Is the any Solution to copy data to a certain format with vba code. Note: the first format if Feedmaster## and the 2nd is the target (or copy to new...

Good day all, I have the following VBA code below to help show when a change was made in one of the columns in my Excel spreadsheet as well as the username however, I am finding difficulties when I am testing my VBA code. I can only retrieve the username/time stamp if I double click on each...

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...

hey Guys I am having issues with my code. Originally (see original code) I would loop through all sheets and combine data in to one. This worked great. Only 1 sheet had headers (data spill). 'Original code For i = 2 To Sheets.Count Set xRg = Sheets(1).UsedRange If i > 2 Then...

I'm trying to create a macro which will copy the unique values in Columns F and X from a worksheet (Data) to a new workbook where column C = Yes. Below is copying the entire Data sheet into the new workbook - how do I set the range (rData) to only columns F and X (and only copy a unique value)...

Ok....So, I am currently working with an excel database that links client information entries to a Word note file located in the client's digital file. What I'm trying to do is three fold; I'd like to be able to code the "notes" cell on the client's row to auto-populate the next available entry...

I am trying to use VBA coding to copy a table to another table. But I am only interested in copying row 2 to row 20 (minus Header and row 1) to another table. I understand there is a function .databodyrange, but this will copy every data in the table which is not what I am looking for.

Hi Everyone, I found this macro which allows me to only allow copy-paste values in order for data validation to work. However, this is only one cell. How can i convert to make it work for a range of cells? Private Sub Worksheet_Change(ByVal Target As Range) Dim IsDV As Boolean If...

Hey guys Im trying to copy some columns from one sheet and paste it onto another. I've come up with a code. Its supposed to copy items of 2 columns from the first worksheet which are "Profile" and "Email Address" and paste it onto the second worksheet on columns "ID"(Column 9 in Excel) and...