Copy lines from sheet 2 to sheet 6
I have some data in sheet 2 in col I.
the data I want to capture is spaced by 7 spaces all the ay down:
I have data in sheet 2 col I row 1 ,7,14,21 etc
I would like to show the data in Sheet 2 to Sheet 6 col B row 1,2,3,4, etc
On Sheet6, enter this in B1:
And in B2 enter this:
and copy down as needed.
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------...How to add 5 min to current time ()
How to add 5 min to current time ()??
On Tue, 12 Feb 2008 21:23:00 -0800, ghost <email@example.com>
>How to add 5 min to current time ()??
DateAdd("n", 5, Now())
or for just a time value - actually a date/time value on December 30, 1899 -
DateAdd("n", 5, Time())
John W. Vinson [MVP]
Im using outlook 2000...i would like 2 show the UK and USA national
holidays...ive tried importing them but they are still not showing.
"Do you know where you're going to?"
...Task updates are lost in PS2007
We are using timesheets only and the resource enters their actual hours and
remaining hours within thie timesheet. We only alllow resources to provide
thier task updates via the timesheet. We are also using the codeplex and do
not use the my task page at all.
Sometimes the status manager does not get their task updates, but the actual
hours show in the timesheet that was saved and submitted. Do you know of a
fix for this, or is this a known bug?
This NG is for the desktop versions of MS Project. Better repost in
Jan D...Historical aged trial balance #6
Hi can anyone tell me the store procedure used to extract a Report
Reports-Sales-Trial Balance-Historical aged trial balance
Because the management want that report to be in Excel format
you can extract the report to excel format however u'll not get it in
a readible format. You need to some formating. To extract the report,
print the report to file and select tab delimited. This will give u in
excel format. You can write a small macro and sort the things out to
make it readible.
On Jun 22, 9:04=A0am, Thirumal <Thiru...@discussions.microsoft.co...Outlook client connect to exchange server 5.5 problem
Outlook client connect to exchange server 5.5, i get the following message
box: "The name could not be resolved. The connection to the microsoft
exchange server is unavailable.
All other clients are able to connect and resolve the mailbox name. I can't
ping and resolve the exchange server from the problems outlook client. The
problems occur after i run repair the w2k pro.
can anyone help?
can not ping... well start with basic IP testing. use
ipconfig /all from a command prompt on the misconfigured
client. Check for DHCP default Gateway - make sure it
looks like a client t...Create Expression from Func? (3.5 SP1)
Is there are way to create an Expression from a Func? I don't like
cluttering up my method signatures with the whole
Expression<Func<TResult, T>> type. I would prefer for callers to
simply see Func<TResult, T> instead.
I'd like to take a Func and create an Expression from it. Is that
Jehu Galeahsa wrote:
> Is there are way to create an Expression from a Func? I don't like
> cluttering up my method signatures with the whole
> Expression<Func<TResult, T>> type. I would ...I've just lost my ability to copy and paster in Excel.
The cell does not highlight when I hit copy.
...MS Word should highlight non-contiguous repeated words also
MS Word generally highlights contiguous words which are mistakenly repeated
when typing. Why not extend this help facility to non-contiguous repeated
words within a sentence?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/co...Amazing Problem in AllocPhysMem wince 6.0
I am writing a Port Driver for x86 platform in WinCE 6.0. I want to
allocate virtual and equivalent physical memory in driver and mapped
it to USER mode to use application. For that I used AllocPhysMem in
driver and passed that
address through IOCTL calls but i cant use that virtual and physical
address in application side. Because AllocPhysMem returns Error Code
as 0x57 (meaning Parameter incorrect).
But the same code is working in WinCe 5.0.
My code snippet is,
VirAddress = (LPVOID)AllocPhysMem(32,
...SMTP connector on Exchange 5.5?
Does anyone know how to setup an SMTP connector on Exchange 5.5? Something
that is equivalent to Exchange 2000 SMTP connector?
Thank you, Jack Black
On Wed, 5 Jan 2005 17:02:38 -0500, "Jack Black" <JackBlack@hat.com>
>Does anyone know how to setup an SMTP connector on Exchange 5.5? Something
>that is equivalent to Exchange 2000 SMTP connector?
>Thank you, Jack Black
...Tab order #5
Pressing tab or enter key selects next cell to the right
or below. Is there a method by which the tab/enter order
can be customized to enable other specific cells to be
Don't know about your version of Excel, but in mine:
Tools>Options>Edit, Move selection after enter, Directions, gives you some
Microsoft MVP - Excel
"Manhar" <firstname.lastname@example.org> wrote in message
> Pressing tab or enter key selects next cell to the right
> or below. I...search #6
hi i want to put a search option in a spredsheet so you can enter 3 or 4
criterias and it will search a page or a few pages for all the results that
match the criteria, than it will return all the results to the 1st page, is
You can use an Advanced Filter to extract data to another sheet. There
are instructions in Excel's Help, and here:
> hi i want to put a search option in a spredsheet so you can enter 3 or 4
> criterias and it will search a page or a few pages for all the results t...GP 6.0 Security
I am setting User Classes in GP 6.0 and am interested if there's any
document showing relations between windows, reports, files. Information
in Tools/Resource Decriptions doesn't look usefull. For example if I
need to enable Trial Balance Report option for the user, which Windows,
Reports and Files have to be included in order for the report to print
correctly without 'not privileged' errors. What should be better
approach: disable everything and add wanted options or enable everything
than disable just screens that I don't want users to see. Latter looks
I have a user who is getting emails addressed to another person in their
mailbox. I checked the headers and the email was only addressed to person A
(no cc's or bcc's), yet person B got it in their mailbox. What could be
causing this? I have exchange 5.5 with SP 4 installed on a Windows 2000
UserA most likely has some type of rule set up on his/her mailbox. Log on to
UserA's mailbox with Outlook and check the rules. Also, there might be a
setting on the mailbox itself that forwards message to UserB, so check the
Delivery Options tab of UserA's mailbox prop...MsgBox 11-24-07
When a report is open I have a MsgBox which also opens, asking "would you
like to print this document". If the operator Clicks on "no", then the
MsgBox disappears, if they Click on "Yes" another MsgBox opens asking "how
many copies would you like". is there a way to add field to this MsgBox into
which the user can input a number of copies they would like, and then for it
to produce the correct number.
You may want to try creating a pop-up form instead of a msgbox for this. In
the macro or vba where you currenlty have your MsgBox, ...Exchange 5.5 Reinstall & isinteg -patch
Let me give you the situation:
I'm a brand new administrator just joining a medium sized (bout 2000 users all together) company. Specifically, I'm going to be handleing their move to Windows 2003 and Exchange 2003. One thing that I'm really distrubed by though is that their existing infrastructure is downright scary (their PDC died last week...so get this, they slapped the hard drives in another machine and prayed they could get it to come up...they did, but how crazy is that that that (like that? ;) ) happened at all.) Anyways, backk to their exchange org...they have three dom...Word to Excel conversion
As we are able to mail merge from the Excel data, is it
possible to convert MS Word labels into Excel Data?
how do you store your data currently?. If it is in a Word Table you may
simply copy+paste thiese contents to Excel
> As we are able to mail merge from the Excel data, is it
> possible to convert MS Word labels into Excel Data?
...Word merged with Access
I am using both Word and Access 2003.
When I merge a Word Letter with Access, sometimes not all of the queries
show up, in the drop down box, to link the letter with. Does anyone have any
ideas of why this happens? Is there a way to make all of the queries show
up? Are the queries limited to a certain number? I would appreciate any
help or ideas that you can give me.
Without more information, I can only guess...
Any chance any of those queries that are not showing up are NOT "select"
queries (i.e., they are Make Table, or Delete or Insert queri...Word forces Save As when Saving
I have had this happen quite a few times since using Word 2007 (Office 2007
suite) over the last 1+ years . At some point while working in a Word
document, I press Ctrl-S to save and instead of saving the doc as usually
happens, the Save As dialog comes up and I am forced to save the document
with another name. This is very, very frustrating and completely interrupts
my workflow because after saving with a new name, I have to close the
document, delete the original so I can rename the saved-as doc with the right
This seems to happen when I've been working in the sam...Amount in words to be printed on the invoice
I need to print the invoice amount in words in MRMS 2.0
this is available through Microsoft. check out the following site:
> Hi Mates,
> I need to print the invoice amount in words in MRMS 2.0
> Any suggestions
...upgrading exchange 5 to 5.5
I have a single exchange 5.x organization with 5 sites, one server in each
site. One server is running exchange 5, the rest are on 5.5 SP4. I want to
prepare the organization for a 5.5/2003 mixed mode situation.
Can I in place upgrade the 5 to 5.5? Has anyone had any problems or advice
with regards to doing this? If it can't be in place upgraded, what are the
alternatives for 2003 preparation?
...5.5 actual database size
Which formula does exchange 5.5 standard use to decide if it's reached 16G
1. Database size = file size
2. Database size = file size - free space (shown by event 1221)
I just need to know if I have to do an offline defrag or not as event 1221
is showing around 4G of free space (after a lot of archiving) but the file
size is very close to 16G.
Thanks in advance.
"=?Utf-8?B?UGV0ZUw=?=" <PeteL@discussions.microsoft.com> wrote in
> Which formula does exchange 5.5 standard use to decide if it's reached...sorting numbers #5
Hi were have problems in sorting out our inventory item numbers. We have
over 15,000 item numbers that can't be changed or zeros deleted. The
problem is when there are zeros in the item number.
Needs to be
darkjedi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29153
View this thread: http://www.excelforum.com/showthread.php?threadid=488748
Since I didn't re...Public Folder Migration #5
I want to migrate my Public Folders to a new Exchange server mail server.
I have migrated my mailboxes using ExMerge, however, I have no idea on how
to migrate my Public Folders.
Please help me.
Add Your new exchange server also to public folder replication server list.
Once it get replicated you can remove old exchange server. And all public
folder will be by default Mail enabled public folders when you migrate.
> I want to migrate my Public Folders to a new Exchange server mail server.
> I have migrated my mailboxes us...