Hello, I know how to copy and paste data from one sheet to another with ranges
but I'm just wondering if there is an easier way by simply stating something
like
Workbooks("Backup.xls").Sheets("Data") =

Sheet1 with Column Date headers, for the next 18 Months.
Sheet2 with Holidays Dates in Column A
Questions :
1. How do I shade the headers with VBA for Weekends & Holidays  ?

I'm fairly fluent in MS Access but I've been handed a task that is
baffling me.  I've been asked to produce a report(s) in Excel that has
a series of sales by territory.  I have a bunch of raw data in a
spreadsheet that has several items including Name, Address, State,

Hi,  I have the following code in a form but do not know how to do the
following.
'copy the data to the database – this is the part I need to change.
When I copy the data to the database I want only the entry in CmbSiteList

In my study of RaiseEvent, I have a Question.
I have 2 Textboxes in UserForm1: TextBox1, TextBox2
When I run, Event is fired only on TextBox2.
TextBox1 does not fire Event.

I have a worksheet with a table that contains twenty columns. Four of them
have numeric data. The challenge I face is to sum the data per column in
these four columns for which the data in the other sixteen columns is the
same on each row.

I am trying to make labels for warehouse product showing product
numbers and locations from an placed order.  I have a worksheet with
part number, location, and qty in seperate collums. I can setup the
merge to print one copy of each part ordered,no problem, how can I

How do I modify G2 in .Formula = "=vlookup(G2," & VLookUpAddr & ",
4,false)" the number so that it can loop through cell by
cell receipt numbers in columnG of sheet1 and yield result like G3,
G4, G5.... etc.

why dont this work on other machine(pc) copied to same location(folder) same
name and every thing. the only thing is I used excel 2002 and I dont know
what ver the other pc has on it.
Sub Sort_Drivers()

I have built a query and have the following code on a command button to
refresh the query.  
Private Sub CommandButton1_Click()
Sheets("Invoice Due").Activate

hi need help with being able to format text box in userforms as $ instead of
an unformatted number.  so currently for eg my text box shows 232434 i would
like it to be represented as 232,434$ in the text box....this is a trvial
question but i've tried looking up some stuff on ...

I hope someone can assist.
I am trying to add the " symbol to the beginning and end of my cell
values.
I have dates in some of the columns so I do not want any of the

How do I modify the receipt number so that it can loop through all the
receipt numbers in columnG of sheet1 and yield result.
------------------------------------------------------------------------------------
Option Explicit

Hi XL-guru's
First I like to express my admiration for your expertise.
I read the posts in this NG for 5 months on a daily basis and I've learned
so much allready.

I am setting up a template (worksheet) for someone to copy as needed.  
Attached to this template are macros and a userform.  
I am setting up this template to use a userform to enter checking account
transactions and each worksheet will be a check register.