edit

Hi, I want to add a table at column AP I have noticed that the table before "AO" is the incorrect range. Table17 Is shown as =INFO!$AO$2:$AP$5 It should be =INFO!$AO$2:$AO$5 So how can i edit this range please as at present any alteration in column AP also then adds it to the column AO Thanks

I have a workbook with radial buttons which I need to edit and point to another cell value Presently the button is labeled 208 and looks up CC column values of 208 and sorts the table accordingly I need a new button which will do this for 308? any suggestions?

I am wanting to edit the link in an Excel document, moving the link from one sharepoint doc to another (actually I just re-named the existing file). Using Edit Links - Change Source, the sharepoint site does not show as an option , and if I search it I get " You can't open this location using...

I looked and could not find how to edit an existing post, in hopes of making it read better, but cannot find that option. If you could point out where this button is or how to close out the post so I can retry would be appreciated. Much thanks.

I have a spreadsheet with dates in R3:CE3 . I was looking to have this auto lock the cells from edit anything two days prior to today's date. Columns A:Q are protected when I protect the sheet. R:CE are the only columns you can edit. Hopefully someone can help me out on this. Appreciate the help.

Hi!, I want to have a macro that would allow me to change the formula (A1-B1) to +if(abs(A1-B1)<0.000000001,0,A1-B1) to multiple cells in a range. Thanks!

I have a number of spreadsheets with many macros, one in particular with nearly 400. Whilst the sheet and the macros work fine, when I edit macros I note that the later ones are "saved" in separate modules. My tidy mind says that it would be neater and easier to search and edit if they were all...

Hi, I have set various ranges to be protected so only specific users can edit the ranges. Should they not be set to allow, they will be requested to enter a password. This all appears fine, however even without the sheet protected, and me having allow rights, the cursor will not enter the ranges...

Good Morning I have a number of Text Boxes All with the same name "Time1". I need to edit each of these boxes using VBA to remove the first character which is a Minus. Your help will be much appreciated. Regards Kev

Hi, I've started getting this error when trying to edit a query or create a new query in Power Query Editor. It was fine yesterday and is happening on any spreadsheet (ruling out a specific corrupted file). I don't know how to diagnose and solve this. I have saved the details of the error if...

How can I delete one of my posts? I don't see an edit button so not clear how to either edit or delete. Thanks!

I go to data and edit links.It appears there are link to another workbook.If I try to break link. The link does not disappear.I try Ctrl + F in the workbook and search for the link, but no search result.How is it possible to delete a link or how is it possible to find where in the workbook it...

I have this which is evaluating cells to see if they match; Presently they produce either TRUE or FALSE - but can it be tweaked to produce either VALID or NOT VALID? I've tried this but it produces '#VALUE!'...

Hi, I found the below code to add the current date to an adjacent column when an edit is made. Note that this code is meant to apply to the worksheet, which might complicate my bonus question. I'd like to modify it to do the following: 1. Add the date to Column L of the edit row regardless of...

Hi All, very new to VB. I want to be able to edit data from list box. I can get the data to transfer the list box into the text boxes. I then want to be able to edit the text box and move it back into excel. I have stumbling through the below code, but it does not seem to do anything. Any...

I have data in sheet4 (contains 8 columns), I need to populate my list box using criteria from my textbox1 After populating my listbox I will select the cell or data that I need to edit (From the Listbox) and save it on my worksheet. SAMPLE DATA <tbody> A B C D E F G H 1 123 XXX 12 12S...

I would like to be able to select certain cells that have linked formula's and then select edit links and change the source only for those cells selected It would be appreciated if someone could assist me in this regard Also posted here...

In the Excel Questions forum I replied to a post, thanking that individual for a solution, but my reply appeared under someone else’s post later in the thread. When the cursor hovered over the Edit button at the bottom of my reply, it said “Edit/Delete”, but when I clicked it, I did not see an...

Hi, Where can I edit comments of the cells below? https://1drv.ms/u/s!Ai8CrEskdewXm1cbebVD-Mm-OXrN

hiya, I have two tables in one database. I have a frontpage menu which gives two buttons. 1. to access form1 (linked to table1) 2. to access form2 (linked to table 2). If I restrict access to the whole database to read only, it means users cannot edit table no.2, which I need them to...