modify

I have office 365, and despise the power query... i use macros to modify existing SQL queries and update data in many spreadsheets. Unfortunately power query uses a more advanced SQL format which is completely different than I'm use to. And i'm struggling to find how to modify an existing...

I need to modify this code but I am a bit lost because I want to delete Cells (Z:AA) if the Value in Column AA = "NEW" I have values down column Z starting in Z1. I have a formula in Column AA that tells me if the value in Z is something new or not. I want to reduce the list in column Z down...

Hello I have now searched all over the net but can't find any good solutions. Is it possible to modify something specific in a txt file? I have the following file, where I would like to multiply the red numbers by -1. I have many of these files and they all have the same "build up". My...

ActiveSheet.Range("A5:I50").Select With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlThin End With My range of data changes as I add or remove information from my table. Is there a way to modify this or add a few lines so...

Hello! I attached an excel file with more tables, all of them including a lot of cells that contain the ROUND function. Giving some different values resulted from calculations, I need to modify all cells with this function. As fully as possible I’d like to change the structure of syntax, by...

I am creating a new log book for our company and I want to have the 'calibration due date' modify automatically depending on two indicators (can't think of a better term). So I want A3 to change it's date depending on: A1's text (Gauge,Fork lift....) A2's date (calibration date) My hope is...

Hello, I have a worksheet with multiple pivot tables, and I have 3 report filters: Level 1, Level 2, and Level 3. Everytime I modify each of these 3 filters to get my data. Is there a VBA code where I can modify each of those 3 filters based on cell values for them respectively? Any help on...

Hello, I need a macro to somehow modify the row range (rows only, not the columns) of the formula =SUMIF('Takeoff Sheet'!E1:E30,"Incidentals",'Takeoff Sheet'!F1:F30) to match the range of cells I currently have selected. I have this formula stored in a named cell "_0_a_a_Incidentals" so it will...

Hello all. I can get the modify sintaxe correctly to AppliesToRange as below but I can't get to ModifyFormula1. Sub CFTest ActiveCell.FormatConditions(1).ModifyAppliesToRange Range("$L$2:$L$115") 'this works properly ActiveCell.FormatConditions(1).ModifyFormula1 "=$I2=1" 'this...

Hello, I am trying to modify the code below to copy only visible cells and paste it in the specific destination on another sheet. How would I modify the code below such that if I apply a filter to Sheet1, the data pasted into Sheet2 will be only the visible Cells? Thanks in advance for all the...

Hi all I have a DDE-Sample.xls file which I downloaded from the Forex Factory website and found it ran well for me collecting the current selected last prices every second. I would like to modify the data collection rate to 4 hourly or at least less frequently if that were possible. Does...

i have some text boxes which i want to lock it in my sheet user should not have access to modify it?

Hello everyone, I have a minor issue that I tried to look up on google. I have a out of memory error when trying to access my macro, I read that I might have too many useless lines in my macro but the problem is I cannot access at all the macro hence I cannot modify the code. Can anyone...

I want to have a prompt box to pop up when closing a workbook to enter a password that sets the password to modify the workbook. I can get it to work if there is no password set, but once the password is already set it will not allow me to change it. Is this possible? Thanks in advance. Sub...

Hi there, I have a listbox which is displaying data from a table in my spreadsheet. I'd like to be able to select a row and then select a command button to remove this row from the sheet (thus too removing it from the listbox). In addition, I need to have the data in each collum, of the...

Hello............ my problem is with Msgbox......... Below two codes 1 for searching the data (it is working smoothly.......but i want it gives following message) and 2. is for Modify the data 1. if textbox1 is blank and i hit commandbutton5 it gives a message (msgbox"Please enter an...

I am trying to modify every other row in a spreadsheet. I used to just have baseline schedule highlighted on each row with the following formula: =AND(D$4<=LookUpValues!$H2, D$4>=LookUpValues!$D2) But now I have added a row in between called actual where I am putting my actual schedule and I...

Hi There used to be a way to modify custom buttons and I wondered if this was still possible? I've added some macros to my quick access toolbar and also the ribbon. Renaming and assigning a symbol is easy enough, except none of the available symbols quite fit what the macros are for. Can the...

I have a spread sheet that uses a user form, currently have to open the sheet, decide if you want to create or modify the part number, then when updated you have to hit enter 7 times to run the macros. I would like to be able to populate the part number column and when I click on it opens up...

Hi if I want cell B1 to be like A1 then I type in B1 = A1, that would copy the content of A1 in B1. Can I modify that formula so B1 will have the content and the formatting of A1 as well? Thank you.