worksheet

  1. A

    CopyPaste copying headers

    I have the below code copying data from multiple worksheets on to a master worksheet without the header row. It works fine if data is entered however if no data is entered on a sheet it copies the header row. How can I change it so that the header row is always ignored even if it is the only...
  2. S

    Copy rows from one tab, to start on a specific row in another tab

    Trying to copy rows from spreadsheet named "Items", where if Column E = Yes, then those columns will copy over to spreadsheet named "Print or Email This" & paste starting in row 13 column A. The code below is isn't working for me. Sub CopyYes() Dim c As Range Dim j As Integer Dim...
  3. E

    Automatically Move row from 1 worksheet to another when a cell value changes in first worksheet

    :)Hi All. This is my first post I am hoping a kind person can help me ... I have 2 worksheets in a workbook. Worksheet 1 "Prospects' - lists client records for potential clients. Worksheet 2 "Income" - an Excel table lists client records for actual clients. In the Prospects worksheet, I...
  4. S

    Macro to filter data base on combobox value

    Hello, Would it be possible to have your help to change the below macro so it filters the data I have in worksheet "Data" in worksheet "DataFilter" based on combobox5 "Open", "Closed", "All". These three criteria are in column M in row 27 i my worksheet data. Private Sub...
  5. S

    Macro to filter data base on combobox value

    Hello, Would it be possible to have your help to change the below macro so it filters the data I have in worksheet "Data" in worksheet "DataFilter" based on combobox5 "Open", "Closed", "All". These three criteria are in column M in row 27 i my worksheet data. Private Sub...
  6. G

    Auto Fill Cells with Specific Date from a Different Worksheet

    Hello, I recently took over a position at my work and I am working with a file that was not originally mine. I have warranty registration cards that we receive from our dealers once the item is sold to the end user. When the end user reports a failure they are supposed to submit a credit form...
  7. H

    YTD Data from Monthly Input

    I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it. Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...
  8. H

    TYD Data from Monthly Data Input

    I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it. Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...
  9. E

    VBA code converting cell to Table

    I used this same code in another worksheet but with different ranges without issue. Now when I run the same code it causes the first cell under QTY to become a table. Any idea what would cause this? I did find if I rem out " srcWS.Range("AD4:AD52").AutoFilter Field:=1, Criteria1:="<>" "...
  10. I

    Part of my code has stopped working

    Morning, I have a worksheet called INV that when i select the drop down arrow in cell G13 i see a list of customers names. These names are on another worksheet called DATABASE of which is in the same workbook. Selecting a name then copies certain cell values from the customers entered info on...
  11. Y

    Copy image in userform to a worksheet

    Hi, Would it be possible to have your help to get a code that allows to copy an image loaded in a user form to worksheet 4 in cells A12:N12 and M12:BL12? I have the below code but I do not know how to make it work for the range of cells where I need to insert the pictures. I would appreciate...
  12. Trevor3007

    email & attachment

    good evening, can someone help me with some VB to send to a certain email (ie me@me.com) and attach the worksheet (sheet1) Thank you all for your time and assistance. KR trevor3007
  13. I

    Return to top of page icon always in users view on worksheet

    Hi, I have a long list in column E which is say 1000 + results down the page. I am in need of a Return to top of page code BUT a floating type if possible. I mean the Return to top icon which will hold the code must be in view on the worksheet whether i am on row 55, 239 or 850 then i can...
  14. I

    Search box code doesnt select correct cell on worksheet

    Morning, I have taken this code from another worksheet & made the edits for it to work on my new sheet. I type in the search box say AB & all the results with AB are shown in the listbox. I select the item i require. My problem is that the item i selected isnt selected on my worksheet in...
  15. G

    formatting name in new worskeet VBA

    I have a macro which doesn all that I need except with the new worksheet name. the name is relevant to a figure in the cell E9. The number in E9 is formatted as a four digit number so if 21 was typed in the cell reads 0021. Unfortunately when the new worksheet is created using this number it...
  16. L

    I need help with a pick them worksheet

    HERE IS FILE https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=eQrtdJ HERE PICTURES https://1drv.ms/u/s!AnJwxxiz0Ezpg8oVBr3hJUzW5V6eeQ?e=Scigt5
  17. G

    INDIRECT function doesnt work

    Hi, I have a column B which contains numbers. These numbers correspond to worksheets in the workbook. I need to create a macro so that when activated will open the relevent worksheet in column B. I have hundreds and would take a long time to set a hyperlink to each one when the worksheet is...
  18. I

    Open userform when worksheet opens advice

    Afternoon, I would like the userform to open when i open the workbook. At present i have the following which works fine when i navigate worksheet to worksheet but need some advice please for it to run when i open the workbook. Private Sub Worksheet_Activate() If Range("A2") = "" Then...
  19. I

    Can you check & advise on my userform code please

    Morning, The code im using is shown below. I have used a code from another userform where it had two comboboxes & now wish to use it on a worksheet where there is only one combobox. Some info for you. Worksheet called SUMMARY SHEET Year for combobox is on worksheet called LIST which is in the...
  20. JackDanIce

    Object unexpectedly changed in VBA project window - how to change back?

    Hi, Working on a spreadsheet containing VBA, last night, closed it and it contained 1 Workbook object (ThisWorkbook) and several Worksheet objects) Today, in the Project window, two worksheet objects have changed icons and showing as Workbook objects?! This is causing an issue with a save...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top