copy hard drive?
I am running out of space on my hard drive and want to migrate to a larger
one. Can I "copy" my current hard drive onto a larger one? Is it necessary
to purchase software to do so. PC running SP with all the SP packages.
Also would hate to have to reinstall the many programs involved. Thanks.
> Hello group,
> I am running out of space on my hard drive and want to migrate to a larger
> one. Can I "copy" my current hard drive onto a larger one? Is it necessary
> to purchase software to do so. PC running SP...Macro to copy macros
Is there a way to copy a macro from one workbook to another using a macro?
See Chip Pearson's site Bill
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"Bill" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Is there a way to copy a macro from one workbook to another using a macro?
Thanks Ron. It seems to work, though it is coincidental with my use of this
method that I was warned of a "Bloodhound" v...Copy-Paste ever changing ranges
On Sheet 2 I have ranges in column C, column E and column G all of different
lengths and all changing in size as data is added, but all starting in row
What I would like to do is to copy the range from Sheet 2, column C to
column A in Sheet 3 starting at cell A2, then directly below, paste a copy
of the range from sheet2, column E, and then directly below paste a copy of
the range from sheet 2, column G. Make sense?
I am thinking code on a button would be apt? any thoughts.
By ranges, I assume you mean named ranges. If so, copy this code and paste
it into a standard modu...copy comments to word
I'm having difficulties writing code to copy comments to word.
I'm confused on the "Selection" and/or "Range" Values and how to use them
in this situation.
I need to be able to highlight a range of cells in excel...
Then, copy all the comments in the selected area to a word document.
I have ran across code that will copy the whole workbooks comments but that
is not needed for this.
Thanks for all the help.
The following code will copy the comments in the selected range to Word:
Sub CopySelectionCommentsToWord...If Statement that Copies to another Sheet
I am not sure how to create an IF statement that does the following:
If a cell is >1 then copy the contents of another cell onto another
Can this be done? And does this make sense
Thank you for your help!!
Message posted from http://www.ExcelForum.com/
It can't be done - worksheet functions can only return values to their
However, you can put this in the cell in your second sheet:
J1: =IF(Sheet1!A1>1, Sheet1!B1, "")
which will display the contents of Sheet1!B1 if Sheet1A1 > 1, else will
display a null string.
In...Copy Paste Special Macro
I need to copy the value of a formula into a cell one down and one to the
left of the current cell I am copying. Rather then right click and select
the options. I can build a macro to copy then paste special but...I want the
copy to be the current cell I am in then move the active cell on down and one
left then paste special. Is there a way to use visual basic to move one cell
left and one cell down and move only the information in the cell?
The following sub will do what you want:
Dim x As Variant
x = Selection.Value
Selection.Offset(1, -1) = x
Select the ...Copying an Array Formula
How do you copy an array formula from one cell to another
montagu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1522
View this thread: http://www.excelforum.com/showthread.php?threadid=38759
> How do you copy an array formula from one cell to another?
1. Go to your original cell
3. Go to your other cell where you want the formula copied
------------------------------------------------------------------------...Macro to copy text between two different delimeters
I am trying to write a macro in Excel to select text between cells
which contain words.
1.) I need to search for a cell that contains only one-single word
"item:" and then copy the contents of the cell just-above that cell
2.) I need to search for a cell that contains only one-single word
"component(s):" and then copy all of the rows below that until I find
a cell that contains only the word "Zip"
Any samples would help for either of these challenges
This is just an example of technique, not a full solution. This macro
searches the activ...File placement with copied sheets
I have a spread sheet built that currently has 382 sheets of data. The sheets
are 12 columns x 61 rows. There are conditional formats applied. I can copy a
blank sheet move it to the required location, input data, but it will not let
me save it. I get an error box to send to Microsoft. When I close it will go
to recovery and updates the file as version1, version 1 version 2 ect...
Save a copy of the workbook and delete some sheets (say) a dozen. Can you
create new sheets and save now?
If so I suspect you may have run out of system memory which is the limiting
factor for...Copy Multiple Sheets
How can I copy multiple sheets (2-5) to a new workbook. I know I can do a
savea as, but then I lose the original, unless I reopen it. TIA
Click on the tab for sheet 2, hold down shift and then click on the tab for sheet 5. Now right
click and select 'move or copy', then select new book from the top dropdown, tick the 'create a
copy' at the bottom of the dialog box and hit OK.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
----------------------------------------------------------...Copy Sheet and move to end
i have posted something similar earlier today but this is alittle different.
I have a sheet called Template in a workbook. i need to be able to issue a
macro that will copy it and move it to the far right after all other sheets.
Then rename it 1 number above the last sheet. i.e. if the last sheet was 2567
then my new copied shett will be 2568.
ActiveSheet.Name = Sheets.Count
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"Nigel" <Nigel@discussions.microsoft.com> wrote in ...Copy Files from '2002' Money...
....on main computer to laptop "2002' Money.
I back-up to CD or Memory Stick...plug into laptop... hit restore from
back-up and it says password needed. I have no password on original. I am
signed on to same passport password on both computers also... HELP!!!
In microsoft.public.money, NeedingHelp wrote:
>...on main computer to laptop "2002' Money.
> I back-up to CD or Memory Stick...plug into laptop... hit restore from
>back-up and it says password needed. I have no password on original. I am
>signed on to same passport password on both computers also......deleting old .pst files and copying to new PC
Now using Outlook 2007. Through fits and starts I've wound up with multiple
pst files. I can tell from the dates which ones no longer apply. When I
delete these, are their supporting files I should delete too?
Secondly, if I copy all the files from the directory to laptop for a winter
vacation, what settings do I need to modify on the laptop copy of Outlook for
it to work?
Thanks for you help!
The first thing you must realize is that you must never do anything to a PST
file in Windows Explorer until you have disconnected it from an Outlook
profile. After that ...HELP copy and paste
I am trying to copy a range of cells and paste them after every Total
This is what I have so far:
Dim theRange As Range
Dim lastrow&, firstRow&, x&
Set theRange = ActiveSheet.UsedRange
lastrow = theRange.Cells(theRange.Cells.Count).Row
firstRow = theRange.Cells(1).Row
For x = lastrow To firstRow Step -1
If InStr(1, Cells(x, 1), "Total") > 0 Then
Range("A5 : G7").Select
ActiveSheet.Paste Destination:=Worksheets("Payroll").Cells(x + 2,
Plea...Help with a Copy and Paste Macro
I tired to get an answer for this over in excel.function over the last
week, but I wasn't able to get an answer. Hopefully someone over here
that doesn't check that will be able to help me out.
Here is my problem. I have this macro that takes a line and copies it
to the end of a list on another tab. The one problem? I need it to
Paste special - Values. And if you can write a better macro then this
one that does what I need, please do. I just need it to work
Range("A2:C2").Copy De...Copying an excel worksheet
I have a two worksheet excel document. The first worksheet has all the raw
data and formulas. The second worksheet has some nice table layout with the
final results imprted from the first worksheet.
What I need to do is copy just the data (results) and tables from the second
worksheet without any of the formulas or macros to a brand new excel
document that can be submitted for presentation.
I have tried highlighting all the cells in the first excel sheet and then
doing a copy and finally a paste in the new document, but get the message
"Data on the clipboard is not the same size...Copying spreadsheet with formulas
Hello, I would like to copy a fairly large spreadsheet retaining the
formulas but without the data which I inputted. I appreciate your help
Message posted from http://www.ExcelForum.com
This example will copy all worksheets in a new workbook and delete all constants
You can also run it on a copy of the workbook if it is active
Delete the <Worksheets.Copy> then
Dim sh As Worksheet
For Each sh In ActiveWorkbook.Sheets
On Error Resume Next
On Error GoTo 0
Re...Need macro to copy a hidden row
I have a spreadsheet with rows 701 identical rows [rows 6 - 706]. These rows
contain formulas, data validation, merged cells, and conditional formats. As
I enter data into the rows, I sometimes need to go back and insert a row
with the same formulas, validation, merged cells, etc. I thought the best
way to accomplish this would be to hide row 6 (as I sometimes will change
one of the rows by adding an @sum or something, so I can't be sure that the
row above where I currently am working is unaltered, so I figured to use a
hidden row as a "template") then access it [row 6] to copy a...Copy worksheet to new workbook : Values & Formats
Is it possible to cpy an entire worksheet (Values & Formats) to a new
workbook without copying formulas ?
Sheets(X).Copy is building links to previous workbook.
Thks for help
After coping go to Edit->Links, and break links, and excel will replace
links with values.
If you do it from VBA, which seems so, try with PasteSpecial metod.
"Franck" <email@example.com> wrote in message
> Is it possible to cpy an entire worksheet (Values & Formats) to a new
> workbook without copying f...VBA Copy Paste Issue
I have a workbook that is used by multiple users and the copy paste
lines of the code do not work on the newer computers. It gets hung up
when I code Range("A1:A5").copy Range("A1").pasteSpecial Xlvalues. I
do not understand why this does not work on all computers. It errors
out and tells me that it can not paste because the range is nto the
same. So then I have to speciff Range("A1:A5") to paste.....this does
not make sense to me.
...Copy down (propagate) function/forumula needed
I have a project I'm working on where I get a huge spreadsheet and I need to
"massage" the data to make it ready to load into a database. There are two
The data I want to "copy down" is in the first column. For example cell
A1="some data", A2 A3 A4 are blank, A5="some data", A6 A7 are blank,
A8="other data", etc.
so... I want to be able to propagate whatever is in the first cell down
through the all cells below whether the cell is blank -or- the cell has the
same value (see cell A5). When a cell value changes, then the n...Copy & Paste issues with "Quotes"
Hello All -
I'm having an issue when I copy data from my POS software and then
paste it into Excel. I believe the issue revolves around the use of "
in certain fields.
For example, one of the lines that I'm having problems with looks like
this when I copy it to Notepad:
"AVN12223" "Pipe Extension - 3"" 336.40"
"Accessory" "9" "Each"
When I copy the same data on the clipboard to Excel it comes out like
AVN12223 Pipe Extension - 3"336.40Accessory
As yo...excel vba
I have set up my sheet to protect using a password name login which the
runs the macros. It is set up so that the sheet's cells cannot b
edited, but the person can copy/paste the info onto another sheet.
This is a problem because there are hidden cells which contai
sensitive data. Any ideas
Message posted from http://www.ExcelForum.com
Hi, just a comment that i just found out, check out this
link that I was refered too. That password that you
setup doesn't do squat when you have access to this...
I was mad when I saw this, when mean...Cell truncated to 256 characters during copy to new worksheet
When you copy a cell which has greater than 256 characters
from one worksheet to another the cell gets truncated to
256 characters. I have used the workaround suggested in
the MS knowledge base. Does anyone else have any ideas?
Was the suggestion in the KB to copy the worksheet, then come back and copy the
cells, then paste the cells?
If it was, then I don't have another suggestion. If it wasn't, then I do.
Brad Backlin wrote:
> When you copy a cell which has greater than 256 characters
> from one worksheet to another the cell gets truncated to
> 256 char...error copying file or folder
I get the following error when copying Outlook messages
to a folder in my file server.
"error copying file or folder-
Not enough storage available to process this command"
I have plenty of storage on source and target computers.
Any help would be greatly appreciated.