copying and pasting with hidden rows
I insert subtotals to my worksheet. I want to copy this, meaning just the
subtotals excluding the hidden rows, how do I do this?
Use the outlining symbols (to the left) to hide the details (only show the
Then select what you want to copy
check visible cells only
go to the new sheet
> I insert subtotals to my worksheet. I want to copy this, meaning just the
> subtotals excluding the hidden rows, how do I do this?
thanks. that works.
"Dave Peter...Avoid Printing the Combo Box with the Chart
I have a chart sheet with a combo box which I use to select the county
I'm interesting in plotting. My question for the group - is there a
way to keep the combo box from printing with the chart? Perhaps what I
need to do is simply create the chart on a worksheet and print it from
there. Just thought I would ask. Its not critical, but I thought it
would look nicer if I could leave the combo box off. I wanted to use
the chart sheet just to keep things "cleaner".
Right click the combo box and on the properties tab uncheck the Print
mtonkovich...Send/Receive Progress dialog box appears
The Outlook Send/Receive Progress dialog box appears
every time during a send/receive, even if you have
selected the Don't show this dialog box during
Any ideas, besides the answer from their knowledgebase?
...multiple monitors & dialogue boxes
Using Dynamics GP 8.0 - If multiple monitors are in use, dialogue boxes (e.g.
"do you want to save changes" - yes, no, cancel) only pop-up in the primary
monitor, not the monitor displaying Dynamics GP. Dialogue/message boxes
should pop-up inside the Dynamics GP window so you don't have to mouse over
to the other screen to click them.
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, fol...Check all check boxes in a multiple form
I need help trying to check all check boxes in a continuous form. Now,
this form has only filtered data from its table. I need to change all
the check boxes to TRUE but only the data reflected on this form, not
the whole table. Please reply!!
Why post twice in 5 minutes? This newsgroup is supported by volunteers. If
someone hasn't responded within 24 hours of your post, you might want to try
re-formulating your description and re-posting. And 24 hours is not a
'service-level agreement' of these groups.
If your need is more urgent, ...Copy Worksheet to Preserve Page Set Up
I have a workbook with a very detailed worksheet that I want to copy
onto addtional worksheets to run different scenarios. I can easily
copy the worksheet but it doesn't preserve the detailed page set up for
printing. How do you get it to copy the page set up too?
Uzytkownik "TiChNi" <TCNICHOLS@YAHOO.COM> napisal w wiadomosci
> I have a workbook with a very detailed worksheet that I want to copy
> onto addtional worksheets to run different scenarios. I can easily
> copy the worksheet but it...Copying numbers from Excel to Word
I have numbers in Excel formated in Hebrew font Narkisim.When I copy them
from Excel to Word (2003 and 2007) it converts the numbres to Times New
Roman and force them to be formated as ENGLISH charachters instead of
Is it a bug?
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4762 (20100111) __________
The message was checked by ESET NOD32 Antivirus.
If you paste the numbers into a Word range formatted with the Narkisim font, I'd expect them to retain ...Run macro after booting is over
Is it possible to run a macro when I turn on my PC?
e.g. I want my list of duties to be undertaken today.
This list is saved in an excel file. I have excel sheets by date.
This is as much a Windows question as an Excel one but yes you can do that.
Place a shortcut to the Excel file in the startup directory of your personal
start menu and Excel will run that file on startup.
Once running you can call macro using the workbook open event
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still suffic...copying vba code to a standard code module
How do I copy vba code from a web page to a standard code module? Note: I
don't know what a standard code module is.
In the VBA editor, go to the Insert menu and choose Module. Cut
and paste the code from the web page to that module.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"1vagrowr" <firstname.lastname@example.org> wrote in message
> How do I copy vba code from a web page to a standard code
> module? Note: I
> don't kno...Copy down problem 2
I have the value 2 in cell A1 and the value 4 in cell A2.
I have the formulas =1+1 in cell b1 and =2+2 in cell b2.
I need a way to automatically add cell A1 into the formula
in cell B1, so that the new formula in B1 would be =1+1+A1
or =1+1+2. Then I need to be able to copy that down, so
that B2 would then equal =2+2+A2 or =2+2+4. Thanks!!
...Exchange 2000 Running Real Slow
I'm hoping to find some help with this wierd problem.
All of a sudden today my server started to "crawl" when I investagated I
found that the server was very unresponsive. After doing a little digging I
noticed that there was a "PreSubmissionQueue" with over 1500+ items in it.
Most of it looks like spam.
Using the suggestions from other posts I checked my NDR and whether I was a
"relay". I also stopped AV and GFI from running. The system still runs real
slow. If I stop the virtual smtp server, the system returns to "normal" but
of course...Long Message delays in Exchange 2003 running on Server 2003
We're getting delays on e-mail, I've seen the "sent" time on the e-mail
be both correct and also delayed as well. Often I will see a user get
other e-mails just fine but e-mails from one domain will all drop into
the mailbox at once several hours after the client has reported them
being sent. I implemented message tracking; since that has been in
effect I have tracked several e-mails that have been delayed or
reported missing and have not seen any sign of them hitting our
exchange and being delayed.
E-mails from one client for instance had been working just fine, up
until 9...Running Sum 02-10-10
I have a report that I am having problems with running sum. It is
basically a daily ledger and is laid out as follows:
Person Beginning Accounts Receivable Balance
Grand Totals for person
The report works fine as long as I am running it for one person. Page
one calculates the correct runningsum. However, the subsequent pages
tack on the daily total for the previous person. The third page, for
the previous 2 people, etc.
I have the fol...Exchange 5.5; To Address not last, first
In exchange 5.5 in the global address book all the names are listed
as lastname, firstname. How can I make it read firstname then lastname.
This for writting emails with outlook.
In Administrator, click on OPTIONS-TOOLS and in AUTO-NAMING tab go ahead
change the Display Name Generation
"David Lewis" <*@*.*> wrote in message
> In exchange 5.5 in the global address book all the names are listed
> as lastname, firstname. How can I make it read firstname then lastname.
> This for writting emails with outlook.
I am trying to have 1 of 8 different macro's run depending on the value of a
If I enter 1 in cell A3, I would like macro1 to run. If I change cell A3 to
2, I would like macro2 to run and so on all the way up to entering 8 and
getting macro8 to run. I am unable to find any good examples of how to do
this. I realize I will probably have to use Worksheet Event to do this but
what is the macro code I will need.
Right click the sheet tab and select veiw code. Paste the following:
Private Sub Worksheet_Change(ByVal Target As Range)
If .Addre...how do I copy and paste data with a formula?
I need to create a formula that when an "x" is put in chosen cell, certain
information is copied and pasted into new worksheet Report. So far I have
=if(a1:a100="x", This works to activate formula, but
how do I copy and paste particular data inside this formula?
What are you doing if X is in the cell? You don't use a formula to "paste".
But you could use Find and replace (Ctrl+H) to replace "x" with something
else. Or, if that "particular data" is in column C, perhaps your formula
should read (and b...open attachment
Im using an IMAP account.
When I have an attachment open, and then change emails in outlook to
view another email, Outlook decides to create a second copy of the
email with the open attachment, and "mark for deletion" the first
email. In doing to Outlook locks up as the copy is created and
uploaded to my IMAP server.
Does anyone know how to stop it doing this? Im using Outlook 2003.
Don't open an email from within outlook - save it to the hard drive first.
Or get in the habit of closing the attachment before changing messages.
Also, make sure you have all ...How to make "Report" run for specefic 'Date' or other criteria?
I can use something like...
Like [Enter Date w/o leading zeros like 4/2/2007] & "*"
into a query... then build a Form on that query... Then run the Form
And Access will pupup a screen and ask for a date.
How can we do this when we run a "Report" on the same Query?
thanks for any help.
Mel <MyEmailList@gmail.com> wrote in
> I can use something like...
> Like [Enter Date w/o leading zeros like 4/2/2007] & "*"
> into a query... then build a Form on that query... Th...Re-sizing a Dialog at run-time
Hi, I want to be able to change the size of my dialog at run-time.
Dlg.SetWindowPos(NULL, 0, 0, 400, 600, SWP_NOZORDER | SWP_NOMOVE);
And it's always the same size as what the dlg is in the resource editor
(not 400x600). How do i change it? I've tried using precreatewindow and
altering the cs values, but still doesn't work.
Try to use MoveWindow
"hamishd" <Hamish.Dean@gmail.com> wrote in message
> Hi, I want to be able to change the size of my dialog at run-time...Mail merge times; How not to show seconds please? #2
I have a spreadsheet being used for mail-merge to Word letters, which
includes times for appointments. In the s'sheet the formatting is for
hh:mm but on merging the seconds also show and this is not required.
I'd like to know the easiest way of merging to show only the hour &
minutes. Is there a formula to convert or remove the seconds values
I'd rather not have to manually enter another column of "text"
formatted times if there is another way that anyone can help me with
Thanks a lot.
I see you expected an answer within an hour. Please ...formula to search and find item sheet1 copy to sheet 2
i need to find an item in a colunm on sheet1 and auto copy that items row of info to sheet2. sheet1 changes with each import of data as to where "wings" may be on line 27 one time and move to 29 on the next import. so i need to search colunm B for "wings", when "wings" is found copy that row of info to sheet2 to create a list on sheet2.the formula will need to be adjustable per line, where as i can just change the item "wings" to "burgers" then insert the formula into line 2 sheet2.this will allow sheet2 to locate "burgers" on sheet1 ...Mark copy of sent email as read
MS OUTLOOK 2003 on XP PRO.
I would like to setup a "rule" (either a "Rules Wizard" Rule or code in VBA)
to make a copy of every sent email, move it to a folder and mark that copy as
read. I did a search on google, and found the command "Item.Unread=false"
but I have no idea how to setup the code around it.
I hate asking, "Can someone show me how to do the entirety of what I'm
asking?" but I've never programmed in Outlook before and I have no idea how
to define an event trigger. (In access, I'd be looking for somet...CLIstCtrl in icon view, the first row is at too high
I am using a CListCtrl derived class to display a set of icons to user
where she/he could select an item.
Otherwise everything is OK, but the first row is at too high.
Especially when I am using the extended style LVS_EX_BORDERSELECT, the
upper part of the selection border is cut out completely.
Does anyone know how to make the icons to be drawn a bit lower in
...Is it possible to run "If Statement" with DSum?
I am currently working with a database that uses the following code:
=DSum("[WeeksService]","Service Record Query","[EmployeeID] = " &
[EmployeeID] & " And [DepartmentName] = Current_Department_Name")
This code works to give me the sum of all Weeks Service where the Department
Name is equal to the Current Department Name and I do want to keep that code.
In addition to that code though, I need to add, I'm guessing, an "IF
Statement" that will provide me with the sum of ALL Weeks Service of ALL
Department Name IF the ...3 copies of systray.exe
Can anyone explain why I have 3 copies of the above file in :
I was alerted to this when the one in the temp file was identified as
trying to run on startup by my AV. I blocked it without any problems
with the system tray.
Thanks in advance.
You can safely delete the following
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can...