365

hello 👋🏻 everyone Hope all is doing great and i need your help please with this maddening matter i have a cell contains a formula as follows noting j4=148,495,950.67 -IF (MOD (J4*0.00521)*10000,10)>=5, ROUND((INT ( (J4*0.00521)*1000)+1) / 1000,2), ROUND(J4*0.00521, ROUND(J4*0.00521,2)) The...

I may have already answered my own question but I have just discovered xl2bb so I will post anyway: when I say answered this only means that I won't (please correct me here) be able to achieve what I want by sorting alone so will need to think on or look for guidance/answers here. (Not sure...

I am trying to get the script/macro to move my selectee from onboarding table to completed table. 437&438-Onboarding table column y= "Move to Completed" is a drop down and is blank until "YES" is selected from the drop down. (that is the only option) Station Selectee Effective Date Position...

Prior to office 365, Excel started relatively quickly. With 365 version, it takes a long time to start and also close. Tried with disabled hardware acceleration but it made no difference. Why does this happen and how can it be made quicker.

Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...

I apologize because I do not want to waste your time, but I need help formatting my search for an answer I know is already posted, but I'm not finding useful results. When I open my workbook, it tells me there is an issue and asks if I'd like to recover as much information as possible. I do...

Hello guys I have value in M5:U5 25 10 10 20 18 12 10 5 19 Now i want to get the combination of value which sum will be 30 Some values may not have any combination, those values will go to the last row, value like 20 & 19 Like as below: 25 5 10 10 10...

Hello dear experts, I am writing to you today to ask for your help in reviewing my code. I have been working on this code for a while now, and I am finally ready. However, I would like to get your feedback on it. I am especially interested in your feedback on the following: The overall...

Hello dear, After trying a lot with the helps of many of you, I have the below code, with this code now I am able to complete the pre-packing list within very short time. I'm setting up dynamic range three times in the code, because it changing after completing the segment. Everything is fine...

I can't use xlbb add-in since my company disabled add-ins. I have a list of companies that I need to clean up the duplicates. Some company names are very similar or have a comma or period in the name or some other extra value. How can I remove them easily. I think the best way would be if the...

With help from Peltier.com I've put together a sub which shades under two excel scatter plots using freeform shapes and filling the shapes. The sub then copies the chart and the 2 associated shapes to be used in a word document. I would the sub to delete the shapes and leave the chart so that...

Hello! I have a process that I have to do each month that requires me to e-mail multiple different people with different attachments on each e-mail, however the subject line and body of the e-mail is always the same. I am planning on sharing this with other users who don't know much about...

My Dear Learned Friends. Can any help be forthcoming with 2 problems I have. The first is that when the workbook is opened, no worksheet Tabs are visible. I have checked in the advanced section of the application, and tabs is selected. problem 2 follows The following code runs fine on "365" but...

Hi All, I've been using this fantastic forum for previous VBA issues I've had, seeing other peoples posts and using the brilliant answers people have provided, however It seems Im going to need the extra help on this one! I have a workbook that I use as a report for Aged Debtors, with a query...

Currently I am using Microsoft Office 365 at work, version 2102 (Build 12801.21278) Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows When using a Pivot table in 365, if I attempt to double click a cell to show the records behind...

Hello, I need some help with coding in Excel VBA. I have a file with 2 worksheets, and I have to code a macro in VBA, but I do not know how this works... In WS 1 there is data being added by some formulas that extract data from WS 2. I have to operate in WS1. In column F there is added, what...

I have a workbook with two sheets. On the "Likes" sheet, I have a list of URLs (and other things that are not relevant here). The second sheet, "Apr-4.13.22", has topic titles and their URLs. I want to pull the topic titles from "Apr-4.13.22" into the "Likes" sheet. The formula I attempted to...

Hi and thank you in advance for any help provided. I would like to create a formula that auto moves a row to the bottom of the page based on a specific "word" trigger or "colour" trigger in Column A, without having to manually sort. Does anyone know how to do that? Thank you in advance

Greetings, I have a macro workbook that was created in Excel 2016, however VBA was added to it in Excel 365. It works fine when opened using MS 365 however the users that will need the from/wb have 2016. When opened in 2016 I am receiving a !VALUE error in the cells that should be calculating...

I need big-time help here! I have altered the formula so many times and have gotten completely confused and still, get an error "The function in the formula causes the result to change each time the spreadsheet is calculated. The final evaluation step will match the result in the cell, but the...