Recent content by dkriese

All I have done so far is to search the internet for a solution, tried robocopy, didnt have what I need. I did move all the documents to the base directory named client dat, where there are subfolders for each client name and the documents are also named by client name. each folder and...

I have 1000 files/documents saved with last and first names, I need to move these files/documents to their respective folders that also have last name first name. I would like the script to read the last name and move it to the folder with the same last name, some sort of script or batch file...

Check out this cool code I had help with. Works great if you have a list of names and addresses used for Data Validation and you need to have additional customer info. Take a look Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ' Ignore VBA Error If Trying To...

IF you download from Microsoft Template Wizard with Data Traking it will create an excel database of your data entry from a template to the excel database, which is a workbook with the same name as your template with the word database added, and a worksheet named Table1

Office XP/Excel 2002 Yes, you had to download the add-in from the microsoft site, it's a great little wizard, and if you follow the instructions for Template Wizard with Data Tracking, it creates an excel database file with the same name as your template which adds the word database, the tricky...

Check the monitor regresh rates, you can change them based on your video card speed. Or in XP you may have to turn off the effects I am running at 85 hertz

Diasble it in device manager, disable this device USB Root HUB

The issue is I can't change the original worksheet as it was produced by the company, what they want is to have the person doing the data entry (who only knows data entry) be able to automate making separate worksheets for each client number for that month. The same client may appear on the one...

take a look at this site http://www.j-walk.com/ss/excel/faqs/xl97faq1.htm John Walkenbach who wrote the Excel Bible has alot of good tips you may need to re-write the macro in VBA, however, are users still using 97? in other words, are users using both versions of Excel?

what is the best method to automate the copying of rows to another worksheet, macro, or formula. I have a worksheet with rows of client data, I need to copy all the same client data to another worksheet i.e. with column headings client id name location hours I may have client id 1004 listed...

I was advised by the application developer Timberline to use excel, really

THe spreadsheet has to integrate with another accounting program, and I was advised that I could only use excel, otherwise I would have to create an access database that exports to excel that imports to another app, too many steps

take a lok at the draft sheets I started http://www.dkriese.com/ex3.jpg http://www.dkriese.com/ex4.jpg The weekly sheet (ex3) needs to post to the monthly sheet (ex4) which is then used to create a draft invoice which is sent to the parent company for final invoicing. The shaded area are the...

Can anyone advise me - I am creating an interactive excel spreadsheet for a client who is not computer literate. It is for project management. I wish there was an MDE for excel, but we all know there isn't. Can all of you advise the best way to make this spreadsheet appear a a standalone...

I have a columns of customer id numbers, names, addresses, state zip, how can I get my client to pick the id number and it returns the data of the name address etcc in the next cell, i used vlookup but it only returns the data in one column, are there many ways to do this?