Hey Team,
I'm trying to reference multiple different rate sheets for my estimating sheets. To start simple, all I want to do is have a table on my estimating spreadsheet that shows either the info from Administration 01 on rate sheet 1 or Engineering 01 on rate sheet 2 based on maybe the info...
Hello dear excel-lers,
I have a workbook that helps me to record people's phone attendance on weekly basis.
Each sheet is a list with names and timeslots. Users then are expected to choose from a drop-down menu 1 of 3 options (1-office, 2-home office, 3-formation).
There is also a formula that...
I have a worksheet that only receive updates from other sheet with filter formula, no manual entry at all occurs in this sheet and I need a code to add the current date Now() in cell "C3" as soon as the sheet receive any update from the source sheet ..
I have a code but it insert the date based...
Hello,
I am trying to unzip a file for folder based on Cell Range. For Example Cell Range A1: have my file name (xyztestfile.zip). I am new to VbA and need help
Hello,
I have an Excel spreadsheet that has a list/table of trained employees. when I click on the employees surnames it opens a hyperlink to an individual training completion email file. The email files a stored in a folder on a shared company drive.
What I would like to do is create a number...
I have a workbook that I need to select rows that have cells numbered in one worksheet, import them into another worksheet, sort them based on a value in one column,
The first worksheet can be 150 rows long and would look like the table below (with data in columns C through O too)...
Hello everybody,
I have a list of multiple client names mixed latin letters and cyrillic letters. In the first column I have the client name, in the second columns I have the amounts.
I'm trying to calculate the sum of amounts only for cyrillic named clients.
Any good idea is highly...
I simply need to change the font of a row after the table last row + 2rows for cells from ("A: M") but I don't know how to write that in VBA code ... I have a code to Addnewrow and I wrote the last section in the below code but unfortunately wrong
any sugesstion please
Sub Addnewrow()
Dim...
In my line of work, virtually every company uses some combination and variation of VBA tools that essentially links Excel & Word documents to produce ±100 page report deliverables. Most of this is done through VBA tools either made by 3rd party technology solution providers, and some are...
Hey Everyone,
I am in Word VBA trying to populate a table that sources from an Excel file. The Excel file has hardcoded numbers and no formulas at all. There are several worksheets and currently, there is only one Named Ranged, which is StartRow. StartRow is workbook scoped and highlights the...
I am trying to make 2 separate Employee Schedules, One has a list of every employees name and the shift location and time for each day of the week. The other is a daily schedule that shows which shift they are working and time for that specific day.
For each day I used the formula...
I have a code to copy data bewteen two different workbooks while the source file is closed and it's working perfectly but with one problem which is when the source file is closed with active filters in the table i get a problem in the data copied to the destination file
So, what I need is to...
Hello,
I need help writing a macro for a spreadsheet. I would like the macro to time out a spreadsheet after ten minutes of activity. I would also like a pop up window to ask they user if they are still working, and if they do not respond to the pop up to automatically save and close the...
In excel by pressing Ctrl-O, I can see the open dialog with two tabs "recent" and "pinned". if I right click on any item in them, I can see "open" and "open a copy", but no open readonly. To open read-only I have to click browse and navigate to the right folder, locate the file and there is the...
Dear All,
I need your help!
I have column A in which I have months and column B which has status, it will have "Y" or will be blank. I want a formula in D6, where based on "Y" in column B, it combines the month name.
1) If the range is consecutive then the formula should give result as the...
I would like to try some VBA code that remembers where the cursor was (row number) but go to the required column, and I have no idea where to even start.
I currently have a hyperlink that allows me to go to the today's date column, but always goes to the top of the page, instead of the row the...
Is it possible to make a macro automatically execute (run macro) every time a new email arrives? Can something like: Private Sub Application_Startup / Triggered() be added to the code? Or at least add a macro command to click the blue button = (run macro) every time a new email arrives or to...
Hello!
I'm trying to get a VBA code to work where Excel detects if a date value is present in column M in Sheet1 and, if so, copies the entire row to the next blank row in Sheet2. Then Excel should delete that row from Sheet 1.
Column M will be dates in short format (mm/dd/yyyy). I need the...
Hello, just very interested how to do it , tried everything i knew. Got the next lesson:
Set the name of cell B15 to 'criterion1' and the name of cell B18 to 'new'.
Assign a validation (input check) to the cell named 'criterion1', which allows you to select one birth month from the list.
Write...
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.