I am looking for advice on using Excel as an Access front end for data
entry.  I googled this and found code for using DAO/ADO.  I'm just wondering
if anyone has any good links for further suggestions.
Thanks

Is there formula or anyway to be able sort the below data into a format that
I could create a pivot table on? I spend to many hours doing this every month.
Invoice #:    12345    Invoice Date:    1/16/1950    A/P Code:    ABC
Due Date:    1/16/1950    Total Payable:    $100.00     Reference:    Freight:

i have a data entry sheet which reads:
     A                        B          C              D
E         etc
                                 Week 1                 Week

I am creating a retail price for our items. Problem is that I want the retail
price to end in either a .49 or .99. Example when I figure my retail pricing
off my cost it may come out to $6.74 and I would like to have a formula so
that it would automatically come out to $6.99 or ...

Is it possible to do a macro to update information between the following
situation.
1 - Journal Spreadsheet - same every week - needs to be updated in cells J2,
J5, J8, etc. - every 3rd cell with information from spreadsheet 2.

How do you format to eliminate dashes in a cell that numbers example a upc:
7-67774-54123

To All
I was wondering if you could help me with my problem.
If you have data in your worksheet and you say delete all the data in the
last row, when you say F5 (Goto) "Special" and select "Last Cell" then it

I am looking to work out a % increase (for rent) formula over a few years.
eg   rent today is £40 per week currently
At 5% increase each year
What will rent be in say 10 years time?

I created an invoicing system that uses Vlook-up in Excel.  The Excel
worksheet has a drop down menu and when the user clicks on it, they
get a list of company names that they can select from. Selecting a
company name automatically fills in the name and address fields on the

    I am trying to figure out whether or not a string has a space in
its contents. I am using the following code.
(AppWSF is set equal to Application.WorksheetFunction)
If IsError(AppWSF.Find(" ", Given_Data.Value, 1)) = False Then

I'm working on my first Excel form and need to create option buttons
with Excel's forms toolbar. After making several sets of Group Boxes,
I can't figure out how to remove the Group Box frame surrounding the
option buttons. I know it's something very simple but would appreciate

How do I split a street address field apart?  Field will have 2-3-4-5
digits, followed by a space then a series of alphas.   i.e.   837 Third
Avenue   -or-    6 Street West.
In a column of these address fields, wish to create two fields: the 2-5

Is it only if the OS tells it?
I've posted a message (with no response) so I'm asking a different way.

I have a client that opens a file in excel. We are unable to view the file in
normal view. We can see the file is we go to print preview or full screen
mode. How can i change it to view in normal screen mode?

I have a simple spreadsheet for determining the hours and minutes that an
employee works during a pay period.  The current result is formatted like
"38:45"  meaning 38 hours and 45 minutes.  My payroll software needs the
time worked in decimal format (i.e., 38.75).