help me with vba please

I am new to posting and have intermediate excel skills. I have a multiple sheet workbook. I am focused on the “Input” and “Sheet1” sheets. The input sheet is designed so that each row contains all the inputs for that line item. Sheet1 uses the values in the line item to run calculations (i.e...

I'm having a rough time creating a macro to do what I need. I know I'm going to need a couple of them to achieve the effect ultimately, but I'm going to start with it in a smaller scale. I have a table that is say about 50 lines. It has 7 columns. I'm looking for it to update a word document but...

Hello, I am new with VBA/Macros. I am currently working on a macro and I need the macro to go down an entire column and run everytime the number '2002' is in column R. I have a button set up, but it is currently only working when I am on an active cell. Below is the formula from VBA. Private...

I have written arrays to populate the following information: 1) the number in the 1st cell in the range containing a NUMBER to F5: {=INDEX(N5:AR5,MATCH(TRUE,ISNUMBER(N5:AR5),0))} 2) the number in the cell at the top of the page that corresponds with the cell found by this array to E5...

Hello! I'm really hoping someone can help me. I have searched and searched and I cannot find a solution that works for me. Our network at work has an issue that when we share an excel file, if anyone on Windows 7 (most of us are on XP) opens the file, it will automatically unshare it. So, we...

Hi, I'm new to this forum, and equally new to using macros in Excel 2007. I basically need to merge three tables into one. The first two tables contains rates based on an issue age, and a fixed period of time. The only difference between them is the first table is for a "Band" class 1, the...

Hi! I'm trying to make a macro that searches a date in cell A1 and a combination of two criteria in cell D1, then i need delete entire row, how can I do this? Follow the example: A B C D <tbody> Date Client Count Historic...

Hello everybody! :) I have been attempting to cobble together code from different forums for the past several hours to make a macro to unhide a specific number of worksheets based on a cell value, and have failed miserably thus far. To that end, I thought I would try appealing to you nice folks...

I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined. I may also have rows of customer data that are not in need of combining. A unique customer member number can be used to identify the rows...

hai semua salam sejahtera.... saya newbie dan tidak mengerti sama sekali vba. saya mempunyai satu file excel dengan 2(dua) sheet 1. sheet pertama (d17:co116) dan ingin saya jadikan lembar input data, dengan data validation list katakanlah (PENDIDIKAN_AGAMA, PENDIDIKAN_KEWARGANEGARAAN dan...

i work with stock market where rates are shown in 1st row a1 cell to x1 cell i want to copy value not formula every minutes in row 2 onwards to study changes in rates plz help me to perform this and give me v code and how to include it in excel 2007

Good morning everyone, I have created the following code, which takes a search term and creates then launches each hyperlink into Internet Explorer - By and large it works, which is great... but it is almost like the code is too fast for Internet Explorer and it only opens every few search...