excel

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...

Hello everyone, In Excel, I entered two numbers in a single cell by using the Alt+Enter command to add a line break. I want to calculate the sum of these numbers, but I don't want to use VBA. I know ChatGPT can write VBA code, but I am looking for a non-VBA solution. Could someone help me with...

Hi All. I have an MS Office 365 Excel workbook which analyses data and provides charts to show results and "filterable" data. I have buttons for navigation from a dashboard. When I navigate to any sheet for the first time it has parts of the sheet greyed out. If I navigate to another sheet...

Hi Tech, Need help with VBA-generated QR Code based on values in certain cells......................... Series, Firstname, Lastname, Math Grade, Stat Grade, English Grade, Email, Tel, Notification. Thank you

I'm having an issue with a FILTER function that is just sending back a value of #N/A and the error help obviously doesn't say too much. Hoping someone here can help. My formula is =FILTER(TimetrackedLogs!$A$2:$N$200000,TimetrackedLogs!$N$2:$N$200000="my_value","No results") Column N in the...

Can somebody help me fill in the green column. Please also put what is missing the the formula and show me where to put the correct functions in row 1 too. I was using Clearbit V1 API. initially. GET https://autocomplete./companies/suggest?query= name...

I have a macro which works the way i want it to except for this part.. Set rng = ws.UsedRange.Columns(1) .Cells(r, "H") = rng.SpecialCells(xlCellTypeVisible).Count it returns y, instead of x in (x of y records found) this happens after autofiltering with vba.

Hi there I am looking for help on writing some VBA code for the following. I have an entire data tab (titled "paste 1804") I need copied into 2 different tabs with same format, content, etc..: I have Macro push button labeled "Run data Macro", on a tab labeled "Marcos" Source tab to copy...

I have a spreadsheet that is used to manage the annual budget along with monthly forecast, monthly resource costs, vacations etc. in separate sheets in the same workbook. So needless to say there are lots of formulas in these sheets and references across sheets. I am also using named ranges and...

Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...

I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the...

Hello, I am trying to copy values from Columns R, W, X and Z from the Template (red pic) into columns A, B, C, D. I need a VBA to go through these columns until there is a blank row and then paste it into A,B,C as so it creates a nice list going down. I will need this code to continue multiple...

I have to believe this has been solved before, but I could not find a previous post for my particular problem, so apologies if I missed a previous one. I'm trying to use SUMIF/SUMIFS or some variation of formula to look at two different columns of price amounts, determine for each row which of...