#macros

Hi, I am trying to make a spreadsheet that will not only lock certain cells but when a button is clicked a new row is added and the previous row then becomes locked. I want to lock all cells that are grey. Then once the click here button is pressed a new row is added to row 10 then row 11...

Hi, I am using a Macro-recorder to help copy names from our software system to an Excel sheet. The number of rows is often not equal, sometimes 1 name/ 1 row, sometimes 6 names/ 6 rows. I would like to continually keep pasting names under eachother without empty rows, to do this I want to...

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...

Dear all, I have these several huge excel files, each with a lot of sheets. I have to manually search each of them for specific string and to check if it exists somewhere. I have found the following code and so far it works. But in order to search for a string, every time I have to open the...

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px} span.Apple-tab-span {white-space:pre} </style>I need to transpose vertical data from column B to horizontal data. My table...

Hi, I've created a worksheet that has userform buttons on sheet1 and I would like to copy it to sheet2. How can I copy it so that the buttons would work for sheet2? The reason is I need to separate shift entries. thanks!

Hi, I'm new to Macros... I need of code which does Autofill in VBA for dynamically columns. Columns will change which needed to be get from last column (END function) and need to do autofill function based on the rows in particular column. Since Vlookup is used to build the formula. Thanks...

Hi there, I put together a suite of macros to automate the running of reports through Excel. These reports fetch data from an ODBC connection, refresh a Pivot Table, create a copy of the workbook and save it to a designated folder. This works great for the majority of our clients. However...