Could someone please help me with a macro that will insert a row between
Groups
of Numbers. I would like to be able to insert a row between >=10000 and
<=19999,

I'm sure this can't be that hard, but I am trying to use a cell that
contains a worksheet name in a formula, but can't get it to work.
CellA1.value = "Sheet1"
Formula is VLOOKUP($A$1,Sheet1!A1:B4,2,FALSE)

I am using access to open, refresh, and close an excel spreadsheet. The
code below works fine as far as opening and closing the spreadsheet,
but it doesn't refresh the data. Any idea why?
Thanks in advance for any help.

Hi to all
I am trying to import a works database into excel.
I can convert database to CSV etc buton  importing to or opening in
excel the text in each cell is truncated to 256 characters.

I have two tab delimited spreadsheet files of a product database. My
MAIN concern here is that I need to import the prices from one
spreadsheet, to a specific column in my original spreadsheet, and I
need those prices to correspond with the respective product IDs. Is

I don't want to make the current sheet I'm working on too complicated, so
prefer not to go the macro route.  Was hoping a formula would take care of
this (?).
If I enter a date via "^;", it would be so nice if the sheet knew to change

I have a spreadsheet that insists on only showing the serial value of
the date.  For example the cell displays as "6/15/2005  9:58:08 AM" but
in the formula bar lists itself as "6/15/2005 9:58:08 AM".
If I try to go to Format-->Cells and set the formatting to a different

need download for template for avery 5266

I am trying to use a running balance for my worksheet.  I have column C as my
withdrawls, column K as my deposits, and column M as my balance.  How to I
create a formula for column M to give me a running balance as I add
withdrawls or deposits?

I can't scroll in one tab of a spreadsheet.  It works in other tabs.
Problem is when i click and drag a range, or use the scroll wheel on my
mouse, the sheet won't scroll.  Anyone else had this problem?

I would like to be able to delete a row with a name in it based on a
cell with that name from another cell in a different worksheet.  Any
ideas?
Thanks,

I set up an external data source to update a weekly report.  However,
the number of lines in one of the sources can fluctuate weekly.  This
week, that source had more lines, and as a result my refresh did not
bring in all of this weeks data.  How can I fix the data source to to

Is there a simple way to have a macro automatically started when a workbook
is open?
Thanks
Francesco

Question: Is it possible to have a standalone VBA script file that Excel can
open, or does the VBA have to be written into an Excel document? If so how
is it done?
Ta

Ok, this is kinda difficult to explain but i will try to. I have a
workbook with 7 sheets inside. Each sheet accounts for one big category
for example Air, Noise, Pollution. Take the "Noise" active sheet for
example, it has a Row named Procedure/Training in which i want to