I have 1 master workbook and about 20 children workbooks. The children are excel spreadsheets with several rows and columns of budget data. The master...

Gents, I have a problem on one of my spreadsheet where I have a table with data on columns A thru E. What I want is to have a macro which can look in column A...

Gents, I have 2 cells (A1 & A2) in my worksheet that I change everytime I open my sheet. Their contains exchange rates. And what I want is to have a macro...

i need help on my download scam site the who is dns server is not working with my php database. can anyone help? you can email me directly or use this...

Hello, I have a large organized 'master' workbook that contains certain pricing information on items at various breaking points (based on quantity). I also...

I am having 12 files in different network locations. Each having one worksheet inside. I just want to know whether I can create one file in my hard drive and...

Hi all, I want to delete the last row in a matrix using a macro. I know how to select the last cell but not the last row. Can any one help? Thanks, Kathy

I have written a VBA macro to check certain spreadsheets for valid syntax. Certain cells are supposed to have hyperlinks, whose addresses are related to the...

How could I be able to open different files (excel files) automatically by just typing the name of the files. Is there any macro or .............. function...

Actually, I reckon that I can do it another way: Open the other workbook. Select the required sheets. Copy them to the master workbook. I've just recorded...

Bill Manville Wrote: You need to open both workbooks, activate the workbook to copy from, select the sheet(s) to copy and Edit / Move or Copy Sheet /...

Bill Manville Wrote: Not sure I follow the scenario. How about recording your actions when doing it manually, using the macro recorder. That's just...

Hi, I was wondering - I need to iterate through a set of identically formatted workbooks (values will be different in key cells of course). For each...

Hi I have a workbook of 7 sheets. First sheet is the master list with names of all members, 2nd to 7th sheets names of members according to district. All the...

Hi I have a workbook of 7 sheets. First sheet is the master list with names of all members, 2nd to 7th sheets names of members according to district. All the...

Hi I have a workbook of 7 sheets. First sheet is the master list with names of all members, 2nd to 7th sheets names of members according to district. All the...

Hello, I was wondering if I can do the below with links in excel: I want to create an application that will read an excel file that contains the names of...

I try to approach an external document, defined in cell A1 in cell B2 A1 := 'Sheet1!$A$1 A2 := =INDIRECT(A1) This works perfectly if...

We are a group trying to work inserting different areas of information into a 20 sheet workbook with macros. In an effort to allow all to work at once,...