Can I move down 12 rows in excel for every new entry
I am entering records of numbers which have formulas for calculation. I want
to place these records every 12 rows and be able to automate the worksheet
for our office personnel. How? HELP!! There can be anywhere from 50 to 150
records depending on how many batches are produced in manufacturing plant.
right click sheet tab>view code>copy\paste this. If not column A (1) then
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
"Mickey&...Help: Formula put into entire row creates large file size
I have a spreadsheet where I would like one column to be the
concatenation of two other columns.
For example, in column C I would have =A1&B1.
This excel file will be given to people and they will fill in values
into columns A and B. The trick is, I don't know how many rows there
will be, so I don't know how many rows in column C should have this
If I paste this formula into the entire column C, the excel file blows
up to 3 megabytes. (It's only 15KB without this column).
Are there ways for me to accomplish this more efficiently?
Thanks for any help
Are y...Can i apply 2 mailbox manager policies to the same mailstore ?
I have been reading up alot on this issue, and the only information i have
been able to find is that you cant run more then 1 exchange recipient policy
against the same user.
My issue - I want to have a seperate mailbox manager policy run against each
of my 4 mailstores to do a cleanup of inbox and sent / draft items. this
policy moves the mail items into the deleted items folder for each mailstore.
On top of this policy i want to have a policy that will delete all mail
items older then 60 or 90 days depending on the mailstore from the deleted
items, and delete them permanently. How ca...Will un- & reinstalling Outlook'03 delete email & addresses?
I've been plagued with an Outlook problem for about a month. Settings are
right. Test email works fine. All other internet related programs are fine.
But Outlook gives me a "send/receive error" message as fast as I can hit
"Send/Receive". If I keep it open just to check contacts or calendar it
always crashes within 10 to 60 minutes. If I start it in safe mode it seems
to work all right. I reinstalled and it worked for 30 minutes and then did
the same thing.
If I Uninstall first, and then Reinstall, will it help? Will I lose my
contacts and emails?
Find...Corrupt Access 2003 File
I was working on this file earlier today, I even just opened it and it was
fine and all of a sudden there is a write delay to the save the file, I
closed it and I try opening it again and it is corrupted. I don't get it. The
message I am getting is below. What does that mean. I just finished making a
lost of update to the file. The last time I backed it up was Tuesday, and I
have done a lot of work to it between then and now. I don't have the time to
go back and redo all that work again. Any help will be appreciated.
"Microsoft Office Access has detected corruption in this ...Outlook 2003 won't let me delete msg in Outbox
I have an email in my outbox that has a 6 MB attachment.
Well, for whatever reason, Outlook was having issues
sending the email, so after several hours, I decided to
delete it. Pressing the delete button does nothing, no
error. Trying to permenantly delete it (shift delete)
and it gives me the error message "The item could not be
deleted. It was either moved or already deleted, or
access was denied."
It's a bizarre error. I'm only using Outlook as a pop3
email reader. There's no exchange on the backend. This
is with Windows XP Professional. Any help woul...help
I have some texts files, which i want to read in each line, and then
write back each line to a new text file.
So for example, I want to read in the 2 lines below:
I store each line of data in the following vector:
So FileData =3D ""C:\Data\=D3=EA=D2=B9=D0=C7=BF=D5",6,10,3,3,8"
FileData =3D """,0,0,0,318.592,83.04552"
(the data is in the vector correctly)
Then I go to write the data to a new text file...
FILE ...Converting XLS file to QIF or to OFX
How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
> How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
In Excel, save the file to CSV and ustilise iCreateOFX Basic from:
to convert the saved CSV file to OFX.
...New mail appearing as old deleted item
When new mail arrives in inbox an old long deleted item appears in place of
the new mail showing in bold as new mail. The real new mail is not visible at
all and is therefore lost.
This problem also used to happen in Windows Mail so I bought Outlook 2007
but it still happens intermittantly.
What do you see in your Unread Mail folder?
"Kate B" <KateB@discussions.microsoft.com> wrote in message
> When new mail arrives in inbox an old long deleted item appears in place
> the new mail...Querying MS Access from C# on stored file paths
I'm storing some particulars about file usage in my MS Access
database, incl. the full paths of those files. I tried to query the
database in my C# code. My idea was to retrieve from the database by
means of SQL when a file was used the last time, but I only know the
directory it is in, so in my code I tried to construct a WHERE clause
as follows: String whereClause = "WHERE Filename LIKE '" + dirpath +
Of course I'm working on Windows and I don't want to think of
portability now. Obviously, the variable dirpath contains double...Can't Upgrade from 2004 to 2005
Several months ago, a creeping corruption problem that caused me to
spend weeks manually reconstructing transactions, destroyed my
confidence in Money's ability to maintain my data.
When I tried to updgrade from Money 2004 to Money 2005, it insisted that
I disable bill pay and that it would re-enable it. Instead of
re-enabling bill pay on the same account, it created a new empty account
and attached bill pay to that. There is no obvious way to correct this
and the new help system is totally useless. In the few days I had Money
2005 I never found a single answer to a question i...execute batch file does not execute all command lines
I am using the following code to execute a batch file which contains
multiple commands, each on a separate line. Each command-line creates a
file. What I am finding is that only some of the files are being created ( 7
out of 11 ).
If I then run the batch file directly ( either by double-clicking, or
pasting its path into cmd.exe window ), all files are created ( 11 out of
private void executeBatchFile(string pathBatchFile,
...Precompiled headers and source files in subdirectory
Hello, I'm using MSVC++ 8.0 SP1 on WinXP Pro and I have a simple,
app-wizard generated MFC application. It was using precompiled headers
to speed up build times (as is the default), but when I tried to move
the c++ source files to a subdirectory "src" to in the project/solution
directory, I can't build the program anymore without disabling
precompiled headers. I get these errors:
error C2859: c:\coding\msvc\toolbar-demo\debug\vc80.pdb is not the pdb
file that was used when this precompiled header was created, recreate
the precompiled header.
error C2859: c:\coding\msvc...WHY DID YOU DELETE MY POST?
All I did was ask for some help with massive amounts of spam coming to my
exchange server. Please explalin to me why you deleted my post I really need
some help with this issue.
On Thu, 9 Jun 2005 12:21:03 -0700, "dath"
>All I did was ask for some help with massive amounts of spam coming to my
>exchange server. Please explalin to me why you deleted my post I really need
>some help with this issue.
You want to look again, Seth and Will replied.
depending on your hardware, etc you can do this on the same server, ...Opening Text Files and Re-Saving Them
I am trying to write some code which will allow a user to select a folder
and then will open all of the text files in that folder and re-save them as
I have sorted out the code to enable the user to select the folder they wish
to use, but am looking some assistance on the looping to enable each of the
text files to be opened and re-saved.
Can anyone suggest how I might do this.
If the text files are all the same, you could record a macro that Opens, saves
as an excel file, and closes the file.
Then that recorded macro could be modified to open...Mail Relaying denied error message, how can it be fixed???
I setup outlook express smtp to use incoming: mail.tpg.com.au
I can successfully receive emails and read newsgroup but I can't send out
emails because it keep on return the below error message, how can it be
fixed so that I can send emails? Thanks...
The error message when sending is:::
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was 'firstname.lastname@example.org'. Subject
'Re: Again', Account: 'mail.tpg.com.au', Server: &...How can i stop same data being repeated in a column
I have a list of contract numbers relating to application numbers or
payments. they are in the format nnnnnnan or nnnnnnpn. The columns are fixed
to this format only. If they are entered with the a or p in the wrong place
or if they have been left out completely an error message will appear to
alert the user. I want to know how to alert the user if they enter an
application or a payment number that has already been entered.
ie if they enter 022079a4 but that same application has been entered else
where in the column.
Hope you can help
See Chip Pearson's
http://www.cpearson....the system cannot find the file specified outlook 2003 #2
Attachments show up in emails, but when you try to open
them, the messages comes up "the system cannot find the
file specified", but other recipiants on same email can
...What's the name of the file that stores AutoComplete addresses
My Outlook had to be re-installed and I lost my contact list which is very
large. I see several files in the recycle bin. Is one of them by contacts?
Autocomplete cache is an NK2 file, named for your profile, often
Paste the following line in the address bar of windows explorer;
and it will open to the folder where its stored.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:dailytips-subsc...ftp server or I can saved from Ecxel? #2
I need to fine out how to save a hml workbook onto my website do I need to
use ftp server or I can saved from Ecxel?
...can`t print single checks
when I try to print a single check, the blue print icon
will not come up and can not print any new checks , but if
I try to reprint a previous check I have no trouble
I'm not sure exactly what issue you are describing, but read
"sp" <email@example.com> wrote in message
> when I try to print a single check, the blue print icon
> will not come up and can not print any new checks , but if
> I try to reprint a previous check I have no trouble
...Outlook 2003 Can't Open Item MS OFFICE FAILED
Yikes, I'm having a real problem. I am running
Windows XP with Service Pack 2 Home Edition
Office 2003 with Service Pack 2 (only have Outlook and Word installed)
Toshiba Notebook M15-S405 Satellite Pro
1.4 ghz with 512 mgs ram
I woke up one morning and saw that I had a stop error window open on my
computer explaining that Windows had encountered some kind of driver
error and that windows had to restart. Windows offered that I review
my system for serious errors. That is a very sad thing to wake up to.
So I ran a chkdsk and defragged and a virus check. No problems there.
I checked my ...trouble opening office 2003 excel files
Operating System: Mac OS X 10.6 (Snow Leopard)
I am having difficulty opening Excel files that were created in the 2003 version withthe 2008 version. The files were originally created on a windows XP machine, then imported into a Mac using Office 2003 under system 10.4. The files are rather large, approximately 60 columns by 10,000 rows. I haad no difficulty in working with the files between the Windows and Mac systems. I recently got a new MacBook Pro with an Intel processor and installed Office 2008. When I try to read these large Excel files on my new lap...Can I convert footnote numbers to text
I'm working with a document where the author has used the automated endnote
facility in Word. Since this is about to be translated into Quark for
typesetting, I need the endnote marks and the numbers with the endnotes to be
real numbers, not endnote marks -- Quark will not read them as numbers.
I was sure I did the conversion using ActiveDocument.ConvertNumbersToText in
Visual Basic once before, but I can't seem to make it work. Help! There are
20 chapters with about 40 endnotes each.
ActiveDocument.ConvertNumbersToText only works with paragraph numbering (and
LISTNUM fi...Merge Cells I can't find
I was trying to hide a column, and got a message that I couldn't, because
cells in another column were involved. I don't see those cells, and "merge"
is turned off. Any suggestions for finding them?
This quick macro will remove all merges on the current sheet:
You can, of course define a range instead.
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"Ed Kearns" wrote:
> I was trying to hide a column, and got a message that I couldn't...