I would appreciate it if someone here could provide input regarding my steps to separate imported Excel data into 3 related tables and advice on how to implement it.
Here's more detail - the Excel data is in 2 separate worksheets. Each sheet has a line of data for each day there is a record. I...
I have a table that summarizes & compares data from several years by week (each year is given 52 weeks for this ongoing effort). Each yearly table has over 100 items that are tabulated by week. All of the data is numerical but some of it is in decimal form and some is in time form - [h]:mm:ss...
I'd like to know if there is any way to copy a file that has the quote symbol: " in it's file name.
EXAMPLE: 02 "Progress is our mission…".mp3
My wife gave me a MP3 CD book but portable CD player does not support MP3 format...
No problem I thought. I'll just transfer the file to my MP3...
I'm attempting to install XP SP2 on an older laptop (it is slightly better than the min sys rqmts for XP: Dell P3 500MHz, 128Mb ram). I understand W98SE would perform better but this will be use for internet 98% of the time and I need to really restrict what other users could do.
After the...
I looking for a macro that I can insert into an Excel file to lookup a file path and return the path as text.
Ideally, when the user activates the macro with a button click it would prompt the user, with a dialog box (similar to the "Open" file or "Save as" dialog boxes) to lookup the file...
I am attempting to write a macro that would retrieve data from text file that could be large (500+ pages of text). The text file is the output of an engineering software package. Currently we manually gather the data to perform calculations that the software package does not handle. What I...
Problem:
I have several Excel files, each has one column of data (approx 1500 rows) with evenly spaced blank lines after each data entry (either 2 or 3 depending on who generated the data, but it is consistent within each file).
Goal:
Organize the data into columns, alternating data rows with...
Is anyone aware of how Theunderbird could be started with the calendar (Mozilla Calendar) extension automatically opened OR how to open the calandar without Thunderbird
Thanks
I just re-formatted my old P3-500MHz, re-installed W98SE and have not installed an email client yet.
Does anyone have a recommendation for an email client that would serve multiple accounts? A calendar would be nice but it is not a requirement. I would also like to be able to reply to email...
I am using Outlook 2000 as an email client at home and work (I just changed from OE 6.0 at home to Outlook for calendar purposes).
When I save attachemnts, Outlook always seems to save the attachments as read-only. How do I change this?
It is irksome to go to Windows Explorer and change...
Web pages load very slowly over my LAN at home (cable modem feeds a Microsoft MN-500 Base Station hard wired to desktop and wireless to Linksys notebook adapter in a laptop). While pages are loading the mouse movement is very jerky (both computers).
I was having troubles with lock-ups and...
Is there a way to change the Input Range of a Combo box based on a radio button selection? If this goes well, the spreadsheet user will make a choice from several radio buttons. For each selection, I would like to reference a different data array.
Is there a way to "hide" the Combo...
When I edit an equation or insert an equation into a Word document (Word 2000) using Microsoft Equation 3.0 I am no longer able to see the equation after closing the Equation toolbar. All that is visible is a box that shows the boundaries of the equation object. But the equation does show in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.