contents

Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001 Help appreciated - completely lost! :laugh:

Hello everyone. I have been searching through the forums looking for an example to delete the contents of a cell based upon the value in another but cannot seem to get it to work. What I have is a spreadsheet that in A15 if it is blank, I would like to have E15 to delete it's contents. If A15 is...

Hello All, as i try to learn my self how to use VBA kindly i need a vba code to delete ACTIVE cell contents , as when i select a cell i can delete all the contents in the same row

Hi, I am trying to clear the contents (not deleting) for duplicates of the Range A36:G36 and downwards (only the duplicated values should be deleted, the original should not be cleared). Right now I have some code that do almost what I am after. The problem is that it is clearing the full row...

What I want is a Ctrl - o (say) marco, that takes an existing cell, whatever's in it, and adds "=round(" to the front and ",0)" to the back. If I try to record a macro, with or without relative references, when I call it again, it repeats the cell contents I was recording the macro in...

I set up a table of contents because I have over 100 tabs in my spread sheet? The scrolling / tabbing over just takes too much time. Is there a way to freeze the TOC, so I can get to it from any tab without having to arrow back?

I have a functioning VBA macro to export the contents of a worksheet to a .csv file. I am curious if anyone knows how to supplement the below script so that the contents of that exported .csv file are copied to the system Clipboard for pasting into a separate program. The current method is to...

Anyone know if it's possible to set a userform caption to equal the contents of a cell? Thanks

Howdy, How can I list in the ListBox or TextBox (in the UserForm) the modules from a .xlsm file In ListBox1, list the modules and in the ListBox2 or TextBox, the contents of the selected module in Listbox1. Is that possible? I have seen on Youtube or forums, that I can list the modules in a...

Can you do a Count down a column where the first three letters of the cells contents start with "DLE"?

Hi, I am struggling to get a satisfactory method of doing this and fromgoogling it, it seems to be due to a suspected bug in Excel but I haven't beenable to find anything that provides any help with my specific requirement. I am using Excel 2010 which is what we're constrained to at work...

Hi Guys, I have 2 tables one named 'Steve' and the Other named 'Dave'. Is there a way to use VBA to clear the contents of both tables but leave the formulas in columns R,S,T,U,V. At the moment i just select all rows from row 3 down (leaving the heading and row 2) and delete . I then paste...

Hi My computer is printing the spreadsheet only (cell only), leaving out the contents. It is printing the cells only but not the contents. How do I fix it? Stan

HI, I have tried both below options to either show all data or remove filters in preparation for the workbook to be reused but neither work. On top of this I would like to clear contents in range A:W down to last entry on one sheet and a different range on another sheet. Both are in tables but...

Hello, I am having no luck at getting this right. I have two sheets. In the first sheet I would like to conditional format the whole sheet - if the any of the cells match any of the contents of a column in sheet 2. The column in sheet 2 will be about 50 lines and the contents will be in the...

Hello kings i want A Formula to display the contents of the first filtered cell Exemple like this pic

I have table of contents which lists all sheets in my workbook. I am trying to write a formula next to the sheet name that provides the number of items on each sheet that need to be reviewed. Basically a count of rows in column A of each sheet starting with row 5. The sheets are numbered like...

I have a range of cells on one input sheet that is automatically copied over to an order form. Formula in order form cells is =Home!E14 etc. Now that we have 2 suppliers I need to remove (clear contents of that row or range) orders on the order form, column J, that starts with JPM, but clearing...

Heres the deal: I have two worksheets named Data and Target. I need to get some of the records from the Data sheet moved to the Target sheet. The Target sheet will have the same header row already populated. The difficulty Im having is I need to base this all on the contents of the data in one...

Hi In this macro line, Application.Goto Reference:="rangename" I need the "rangename" to be given by the contents of another cell eg A1, because it will change I'm sure it's simple - but not to me. Thanks for your help. M