Sub Level project copy
We want to copy sub level entries from on project to another.
So we chose "project cost-item copy" but it just won,t work
We used the project copy instead
anyone knows How????
Or in this case
what is the easy way to copy
SPjt departement Data from one project to another?
...I am trying to write a macro using If...Then
I am trying to write a macro that will look at the value in column G. If
that value is blank or zero, then select the entire row and delete it. Then I
want it to populate columns A with a number "111119" and column H with "TEXT"
Here's what I tried, but it's not working.
(There are other sorts, etc. that precede this item in the macro, that seem
to be working fine.)
If Range("g:g") < 1 = true
Then ActiveWorkbook.Worksheets("Tab3 Upload").Rows.Select
If Range("b:b") >...bizarre excel copy/paste problem
I've had this problem for as long as I can remember with Excel 2000 and
upgrading to Excel 2002 has not changed anything. Any input is
When I copy a cell (ctrl+c) and try to paste (ctrl+v) into the SAME
worksheet, Excel will just paste it once and deselect the highlighted
cell. That single copy works fine (ie while copying formulas), but it
just wont let me paste multiple times. Upgrading Excel has not changed
Interestingly, MS Word does not seem to have this problem. Also if I
use the clipboard, I can paste repeatedly. Does this make sense to
I'...disappearing macros #2
I have a user who has successfully recorded some simple
macros and saved them to the Personal Macro file. the
macros have worked up till now. They have now disappeared
from the macro list. Tools, macro, macros produces a blank
I tried to find the macros by unhiding the personal book
but the unhide option was greyed out - Personal wasn't in
the Windows file list though and we couldn't display it in
any other way.
I thought that it may have been overwritten so tried to
create another one. I got a message to say that it was
already open, went to the Windows menu and t...use macro and allow undo
I have a macro that I recorded which works great. It does a copy and special
paste to another work sheet. The only problem is that after it has run, if I
made some kind of mistake and it copied the wrong stuff (or whatever), I
cannot click on undo or alt-backspace. Is there anyway that the copy and
paste of the macro can be undone this way?
Sorry, you can not undo any macro operation....
"ben" <email@example.com> skrev i meddelelsen
> I have a macro that I recorded ...? Rich Edit Formatting Lost When Inserting At Position 0
I'm using a CRichEditCtrl but am having trouble with the formatting. I
use SetSel and ReplaceSel to insert text into the control and if the text is
inserted in the middle or at the end of the control's buffer it works just
fine but if I insert it at the start (SetSel(0,0)) then it takes on the
formatting (both character formatting and paragraph formatting) of the text
immediately after it (the text formerly at 0). There is a small note about
ReplaceSel in MSDN:
"This function will format the inserted text with the existing character
formatting. When replacing the e...Macro and hidden sheets
I have a WB with 10 worksheets.
At the time I did this WB, I also created a Macro that had the task to
change the format of all the sheets.
Today, I have decided to hide some of the sheets and the macro does no
I guess this is because it cannot find the sheets which are hidden.
My question is: Is there a way to allow the Macro to work as before, meaning
to continue changing the format of the hidden sheets as well?
Something like a condition that says, if Sheet XY is hidden then look for it
A hidden sheet cannot be selected, so try r...Replacing export with descriptions -Vlookup Macro
I have a monthly report that I export from an old system.
Column A contains a number and I have been using VLookup to reference the
description of the number from Worksheet2 Column A, B with Column B listing
Is there a way of creating a macro to do this? If so, will I still have to
create an empty column for the result or can the macro replace the data in
You can write a macro. The macro could replace the cell containing the
number. Something like this:
For Each cell In Selection
cell.Value = WorksheetFuncti...How does one copy subtotal rows?
How does one copy subtotal rows?
Since my access to NNTP is limited, a copy of your reply to
ALEXANDEReBARNEs@Yahoo.Com is especially appreciated.
One usually selects the rows he wishes to copy,
Then hits <F5>,
Then, in the "GoTo" window clicks on "Special",
Then, in the "GoToSpecial" window clicks on
"VisibleCellsOnly", then <OK>.
Now, right click in that selection and choose "Copy",
Then navigate and paste to "wherever".
------------------------------------------------------------------...How to copy/paste from Excel to Word without showing gridlines?
How can I copy/paste from Excel 2007 to Word without the image showing the
If you are going to paste as image instead of Table, turn OFF gridlines
in Excel before you copy.
> How can I copy/paste from Excel 2007 to Word without the image showing the
> gridlines? Thanks
If you just want to copy/paste the text (not as an object):
1. Copy the cells you want from Excel
2. In Word, Edit<Paste Special<Unformatted Unicode Text
"Bob I" wrote:
> If you are going to paste as image instead of Table, turn...How do I copy a Word text file into Excel in a way that each char.
How do I copy a Word text file into Excel in a way that each character ends
up in a separate Excel cell?
Paste each line into column A.
Then put this in B1:
drag to the right (as far as you need--but you've only got 256 total columns)
and drag down the range
Newtech programmer wrote:
> How do I copy a Word text file into Excel in a way that each character ends
> up in a separate Excel cell?
Thank you. Very helpful.
"Dave Peterson" wrote:
> Paste each line into column A.
> Then put this in B1:
> =MID($A1,CO...Help with macro code #2
I have a simple command button macro to hide a work sheet page. Is ther
a way to keep the sheet from being hidden if there is a value in boxe
e.g �g13,o13,g24,o24� then open a msgbox �sheet in use�. Thanks fo
any help with this
Private Sub CommandButton5_Click()
Application.ScreenUpdating = False
Sheets("Sun Misc Log").Visible = False
Application.ScreenUpdating = True
Db1712's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1591
View this thread: http://www.excelfo...I can't get pictures to appear when I insert tem in a frame.
when I insert a picture file into a document, it does't appear on the sceen
but seems to be there nevertheless.
Do you have View, Pictures, Detailed display enabled? If not maybe your video
card needs upgrading.
Read the fourth FAQ here:
"Kilno" <Kilno@discussions.microsoft.com> wrote in message
> when I insert a picture file into a document, it does't appear on the sceen
> but seems to be there nevertheless.
...Need help with copy if
What I am trying to do is copy column A-D from "scheduled" worksheet t
"test" worksheet if column X has an "X" in the column. Is thi
possible and if so how is it done
Enter and run this small macro:
Dim r1 As Range
Dim r2 As Range
Dim L As Long
For L = 1 To 65536
If Cells(L, 24).Value = "X" Then
Set r1 = Worksheets("scheduled").Range("A:D")
Set r2 = Worksheets("test").Range("A:D")
...my macros disappear... is it SP2?
My macros which I use to sort data in excel have not
worked since I installed SP2... it may be unrelated??
Here is what happens:
When I click on the button which I setup to launch the
macro, it brings up the macro list, like it does not have
one set. When I select one... and then hit the button
again... same thing... like it will not allow the macros
to be assigned to it.
I have tried rewriting the macros... I have created a new
My only thought is that having resently installed SP2,
that changed some security setting somewhere. I have
checked t...When copying and pasting charts the chart size decreases
Sometimes when in excel I can not copy charts and paste them without them
automatically decreasing in size by what looks to be a set ratio. i know to
select "don't move or size with cells", but this does not help. This problem
is erratic and can just start occurring in a worksheet after i have pasted
other charts without this problem. Any help with this would be much
In Excel 2003 and earlier, if the window zoom is not 100%, if you copy
an embedded chart and paste it, it will be pasted at a size
approximately equal to the original size times the zoom. This is...Copy Top 10 conditional formatting down 1000+ rows
I have 20 columns which I am using top 10 conditional formatting. When I
copy this (B3:T3) down to the bottom of my spreadsheet, the range changes to
(B4:T1200) instead of each row (such as row 4 = B4:T4 and row 10 = B10:T10).
Any ideas on how to copy this logic down the spreadsheet without doing it
row by row? thanks
This code should work. Start with leftmost cell in top, conditionally
Dim MyCounter As Integer
Application.CutCopyMode = False
For MyCounter =...Copies of Inbox and Sent Items not working in Outl;ook Express
I needed to reload my entire machine and wanted to save a
copy of the Inbox DBX file and Sent Items DBX file. I
contacted my service provider. They instructed me to do
1. In Outlook Express under Tools/Options/Maintenance
click the Store Folder. This displays the location of
these two files.
2. Copy the location
3. Click Start/Run, paste the location and click OK.
4. This opens the folder with that location.
5. Copy the Inbox and Sent Items and store them (I did on
my backup CD).
They told me that after I reloaded the machine I could
then copy the files from the ...insert into
I have an insert into query which is as follows;
strgoaldescription = InputBox("Type new goal.")
strservicetype = InputBox("This goal is for what service?")
intprGroup = InputBox("Indicate the pr_group number if any")
intprGroup = IIf(intprGroup = "", Null, intprGroup)
strsql = "insert into goal (goal_description,los_id,pr_group_id) values('"
& strgoaldescription & "', '" & strservicetype & "', " & IIf(intprGroup = "",
Null, intprGroup) & ")"
...Outlook 2003, "Insert ink annotations" is not available when writting new e-mail
I have a tablet Pc and office 2003. All the sudden, cant
not insert ink annotations in new e-mails. The
corresponding icon is gray and l can not click it.
However, this works in Power Point and Outlook.
make sure plain text isn't selected.
"ANGEL REBOLLO" <firstname.lastname@example.org> wrote in message
> I have a tablet Pc and office 2003. All the sudden, cant
> not insert ink annotations in new e-mails. The
> corresponding icon is gray and l can not click it.
> However, this works in Power Point...Macro code mod
The macro below allows users to group/ungroup rows in a protected sheet.
Question: how to modify the VB code so I can incorporate additional tab names
or better yet, have the macro apply to the entire workbook?
Thanks in advance for your help,
.Protect Password:="xlhelp", userinterfaceonly:=True
.EnableOutlining = True
For Each sh In Activeworkbook.Worksheets
.Protect Password:="xlhelp&q...Enable macros
I've got a fairly compex workbook with lots of named
ranges. I've been using and updating this WB for over a
year. All of a sudden, I now get the following message
every time I enter something in any field:
"The macros in this project are disabled. Please refer to
the online help or documentation of the host application
to determine how to enable macros."
I don't have any macros in this workbook.
...Rule to move leaves a copy in Inbox ???
I have a number of rules that move email to varying boxes based on word in
the senders address. Then the last rule moves any remaining emails to other
folders based on account. Problem is I end up with a copy in both places.
I have checked and rechecked to make the rule is to MOVE the emails, not
copy. The rule is definitely MOVE. Why do I end up with a copy in both
This is Outlook 2003, but I recall having that problem with OL XP too. I
ended up using a third party tool, but I would rather not do that again if I
can help it.
Do you have the stop processing add...Copy Functionality Lost
Up until a day or two ago, I could select a cell to copy, paste it into
another cell and the original copied cell would remain available to be copied
again (it would be highlighted with the dotted border).
Now, after one paste the copy cell reverts to normal, and I have to
re-select it to copy into another location.
I know I can use CTRL or SHIFT, but I find the retention of the copy ability
This is a networked office PC and imagine I might have to ask our IT Dept
(as Administrator) to do something.
Any ideas appreciated, thanks
If you paste by pressing Enter you'll exit ...Scan and copy cells from one spreadsheet to another.
How to take data from one spreadsheet and copy it to another. The porblem is
I have to scan columns on both for a match first. The only example I could
think of is something like this.
If A5(on first spreadsheet) = C68(on second spreadsheet) then copy H68(from
second spreadsheet) to E5(on first spreadsheet) else enter 0
There is over 1500 lines so I would hate to have to do this manually. Thanks!
do you mean:
If the value occurs in column A on the first sheet and in column C on the
second sheet, then copy the value from column H of the same row as it
occured in in C (of the s...