specific cell

  1. M

    Search through files in folder and return rows containing specific text and also workbook name

    Hi All, I have a folder containing .xlsx files. "C:\Masterfolder" I would like to build a macro that opens each file and searches column B the cells for text containing "SA2" and return the row back to one workbook I also need the work book name. For example Workbook1name SA2 Row data SA2...
  2. L

    How to open Excel 2013 on a specific sheet and cell.

    Hello, I'm very new when it comes to excel and the macro coding for it through VBA. I would like a basic macro that will allow the document I use to take me directly to a specific cell on a specific sheet each time I open it. Even if I save the document on a different sheet and cell. The sheet...
  3. A

    I need to insert the current date into a specific cell using vba... Please see contents for more details.

    Good Afternoon All, I have Excel 2013, Windows 7 Professional... I currently have the code below, and would like to change the line just above "End Sub" that contains "ActiveWorkbook.Sheets("Sheet1").range("D3") = dateString" so that it puts in the current date into that cell. I just started...
  4. M

    Copy specific cells from row dependant on cell entry

    Hi there, I've got a bit of headache with my current spreadsheet. I have built a sheet using VBA where the final outcome is a table. This can go from row 1 to anywhere, (normally no more than 60). What I would like to do now is be able to enter 1,2,3,4 etc into column A and initiate a macro to...
  5. B

    How to Automatically open a specific cell from MS Sharepoint?

    I’ve made an Excel with 2 sheets. Let’s say sheet “A” and sheet “B”. I’m in sheet “A” and when a user clicks on a specific cell I want to be able to navigate to another specific cell in sheet “B”. I’ve made this using hyperlinks and “Place in This document option” from Excel It worked fine...
  6. D

    Conditional Formatting highlighting a specific cell in a Row.

    Hi guys, Im stuck at what to do? I have a work sheet in which I have to base a response from L4 to highlight the appropriate cell C4. Such as shown in the image attached. Can any help. thanks

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