copied

Hi please can you help I have a command button1 with s list for example: shop, car, home. If home is selected then what I type into the text box I want this copied into sheet2 A2:A5. If car is selected I want the text in the textbox copied into sheet2 B2:B5 hope this makes sense please can you...

Greetings, I recently updated my excel software to 2019...long overdue...anywho, when I copied my workbook files I transferred a workbook named Personal.xlsb from a different machine running excel 2003. The personal workbook was included in the files that I transferred, but was of a different...

I have the formula below I was needing a little help with. I have another cell C2 that I would like for it to look at also. If there is something in it then have formula look at it before F3. The formula below is copied down about 30 rows. C2 is by itself. =IF(ISBLANK(E3),"",F3&" Rev "&E3)

Afternoon. In a workbook i have 12 worksheets. This code is in each worksheet "right click view code/paste" Private Sub Worksheet_Activate() For i = 28 To 4 Step -1 If Cells(i - 1, "A") <> "" Then Cells(i, "A").Select Exit For End If Next End Sub...

I have been searching most of this morning looking for a solution. I have not seen anything like what I am wanting to do. I have a Bill Of Materials with a part number, Description, Cost, and QTY. Some of those rows do not list an item, so I don't want those copied. Just the cells that have a...

Hey hey everyone, I wonder if anyone can help. I have a range (about 11 columns and potentially thousands of rows) which I've copied a formula which could give a result of "" into then copied and pasted as values. Simple enough. But what I need to do now is delete the "blank" cells and replace...

Dear Sir, I need VB code to work following way; I will link it with a button, when we click it, it should open following path; User select an excel file, the folder has many excel workbooks.xlsb with different names All workbooks do have sheet named "Layout" so when user select any of...

Hi good morning, please can you help me I have the code below where I am copying date from a sheet into an email but I want it to wrap text as all information isn't shown when copied over. Please can you help? Private Sub CommandButton8_Click() Range("F8").Value = Range("F8").Value + 1...

Hi there, Using the instructions at the link below, I created alistbox that will allow a user to select from the list, and with the push of abutton, those selections go over to Listbox2. I would like to take this a step further and have theselected options from ListBox2 then be copied into...

Hi, I have copied a code from one worksheet to another as i would like to use the same but on another sheet. The code is shown below & i have changed the cell ref to B7 & onwards. My problem is that there are no names in the drop down list. I go back & check the sheet i copied it from & that...

I have been working through VBA code that copies the first sheet in a workbook from a folder to another workbook("Master"). The code copies the data correctly but upon saving I get certain cells with errors (#Ref) this is due some of the copied cells having formula. I would like the copied to...

I have a basic sheet and want to copy cell data from one worksheet to another using a button created in VBA. Sheets("SourceSheet").Range("A1").Copy Destination:=Sheets("TargetSheet").Range("D5") Sheets("SourceSheet").Range("A3").Copy Destination:=Sheets("TargetSheet").Range("D6")...

I have to create some PDF documents from a mail merge. In Excel, I have a list of individual names that copied individually into the word input box (part of a word macro). What I would like to do in Excel is to copy a cell, highlight it yellow (to show that I've copied the name to word) and...

This code was provided to me by this forum and it works perfect. I want to expand it, but I have tried lots of different mods to it unsuccessfully. The goal is to allow any number of columns to be copied over to "Hstry" worksheet, based on the valve ("4"), column H on sheet "WO" What controls...

Hello I've been struggling with a VBA solution for this and would appreciate your valuable help. I have a named table range, whose headers are on row 14. I need to filter its contents and move filtered data to another table. Number of filtered rows will always be variable, but will always...

Hi there, I have copied and pasted number, but Excel changed it to another number. How can I retrieve the old value? The original value is: 2:2124 I should have copied it as Text. When I pasted straight into excel (actually google sheets on my iPhone), this value was stored as 37:24:00...

Hello, I have a situation where I need a value from one cell to be copied to another worksheet, and repeated in the same column the same number of times as appears a dynamic range in another part of the worksheet. Example: Sheet 1 contains the dynamic range from range("D19:D" & LastRowWS1), and...

I have rtd data in the following format copied at 1 sec intervals; <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Open High Low CLOSE 90 90 90 90 94.5 94.5...

Dear All, i have 10 worksheet in a workbook which i update regularly i want a have new sheet where colA and colE are copied from 8 worksheet out of 10. Thanks in advance for your help.

Hi all! I have two different sheets and i want the new data i put into sheet1 each month to be automatically copied over to the next sheet. The main problem is that is should be only for one column (X) and that only the new data should be copied and transferred to the same range in sheet2. How...