Tech Problem Aggregator

Need instructions on how to copy data from CD to my new Windows 7

Q: Need instructions on how to copy data from CD to my new Windows 7

I need instructions for using Windows 7. I want to copy data files, folders, and pictures from a CD to my new computer, something that was easy to do in my old Windows XP, but I don't know the process. I could use some help. Many thanks!

A: Need instructions on how to copy data from CD to my new Windows 7

It's exactly the same - open an Explorer window to see the files, select on or multiples using Ctrl-click, Ctrl-A, Shift-click, etc., then drag-and-drop them from the CD to wherever you want them to end up.

1 more replies
Answer Match 63.42%

Hello,
I have one internal drive with 1 TB.
The data there is very important to me , so I bought External removable drive for backup.
Now, I want to copy the data from one drive to the second drive but I have to be sure I have a perfect copy of the data.
The data is mostly songs movies and documents.
I'm using windows 7.

My question is this:

1.If I'll transfer the data through windows 7 by copy and paste, I could be sure i have a perfect copy?
2.There are tools for comparison Between the original data to the data that was copied?
If so, what are they?

If I do not in the right place please Please pass my message to the right place.thanks.

jonathan.

A:transfer data through windows 7 by copy and paste perfect copy?

There is no reason why using copy and paste won't give you a perfect copy and in my view it's more reliable than using the Windows backup utility.

One program I've found invaluable is Microsoft's SyncToy, which you can download here: Download: SyncToy 2.1 - Microsoft Download Center - Download Details

It will sync files between folders of the same name on two separate drives or partitions ( I always use the Echo procedure).

You might also want to consider using Windows 7's Robocopy function.

ROBOCOPY - Create Backup Script

4 more replies
Answer Match 55.86%

Ok.. DDS file:


DDS (Ver_09-05-14.01) - NTFSx86
Run by Administrator at 17:16:58.42 on Mon 06/22/2009
Internet Explorer: 7.0.5730.13
Microsoft Windows XP Professional 5.1.2600.3.1252.1.1033.18.2046.1484 [GMT -4:00]

AV: ZoneAlarm Security Suite Antivirus *On-access scanning enabled* (Updated) {5D467B10-818C-4CAB-9FF7-6893B5B8F3CF}
AV: Kaspersky Anti-Virus *On-access scanning disabled* (Outdated) {2C4D4BC6-0793-4956-A9F9-E252435469C0}
FW: ZoneAlarm Security Suite Firewall *enabled* {829BDA32-94B3-44F4-8446-F8FCFF809F8B}

============== Running Processes ===============

C:\WINDOWS\system32\svchost -k DcomLaunch
svchost.exe
C:\WINDOWS\System32\svchost.exe -k netsvcs
C:\WINDOWS\system32\svchost.exe -k WudfServiceGroup
svchost.exe
svchost.exe
C:\WINDOWS\system32\ZoneLabs\vsmon.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\system32\spoolsv.exe
svchost.exe
C:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exe
C:\Program Files\Java\jre6\bin\jqs.exe
C:\Program Files\Common Files\Microsoft Shared\VS7Debug\mdm.exe
C:\WINDOWS\system32\nvsvc32.exe
C:\Program Files\CyberLink\Shared Files\RichVideo.exe
C:\WINDOWS\system32\svchost.exe -k imgsvc
C:\Program Files\Yahoo!\SoftwareUpdate\YahooAUService.exe
C:\Program Files\CyberLink\PowerDVD\PDVDServ.exe
C:\WINDOWS\system32\RUNDLL32.EXE
C:\Program Files\iTunes\iTunesHelper.exe
C:\Program Files\HP\HP Software Update\HPWuSchd2.exe
C:\WINDOWS\system32\CTHELPER.EXE
C:\Progra... Read more

A:Gxvxc Data, completed instructions now

Hi,

Please do the following:

Please download ComboFix from Here or Here to your Desktop.
**Note:**In the event you already have Combofix, this is a new version that I need you to download. It is important that it is saved and renamed following this process directly to your desktop**If you are using Firefox, make sure that your download settings are as follows:Tools->Options->Main tab
Set to "Always ask me where to Save the files".

During the download, rename Combofix to Combo-Fix as follows:




It is important you rename Combofix during the download, but not after.
Please do not rename Combofix to other names, but only to the one indicated.
Close any open browsers.
Close/disable all anti virus and anti malware programs so they do not interfere with the running of ComboFix.
-----------------------------------------------------------Very Important! Temporarily disable your anti-virus, script blocking and any anti-malware real-time protection before performing a scan. They can interfere with ComboFix or remove some of its embedded files which may cause "unpredictable results".
Click on this link to see a list of programs that should be disabled. The list is not all inclusive. If yours is not listed and you don't know how to disable it, please ask.
-----------------------------------------------------------
Close any open browsers.
If there is no internet connection after running Combofix, then restart your computer to rest... Read more

8 more replies
Answer Match 53.76%

Excel 2003 SP3
Could anybody suggest a way, using whatever method you prefer to copy existing data to another tab, but have the data go transparent by 50%(or thereabouts, so you can just see it), but keep the headings normal font.
Thanks
 

A:Solved: Excel 2003 help to copy data to new tab and make data transparent

6 more replies
Answer Match 53.34%

Some time we need copy system to system data transfer but that time can't copy with surely if any other good reliable option then please suggest like command prompt or third party software. 

Both system windows 7 Pro sometime win xp other side win 7 pro



Thanks & Regards, Amol . Amol Dhaygude

More replies
Answer Match 48.72%

I am trying to Copy Outlook Express data from a XP computer to Outlook 2007 on windows 7
contacts and emails years of them in folders

the microsoft help says run outlook express on the outlook computer

its windows 7 and not available as far as i can see

help appreciated please

A:Help! Copy Outlook Express data to Outlook 2007 on windows 7

Hello rogerk, welcome to Seven forums.

Sorry no one has replied before, but I hope this might help:
How to upgrade from Outlook Express to Outlook

more information and guidance here:
How to import addresses from Outlook Express to Outlook

1 more replies
Answer Match 47.04%

O.S: Windows Xp 2006 sp2
Computer: Dell optiplex GX520
USB: Kingston 2 GB

The problem is that large data cant be copied to the USB.. I tried to copy a 1.8 GB video (.mp4) file and it gave back this error..

"Cannot copy: The request could not be performed because of and I/O device error"

tried several times but it always gives this error..

A:Can't copy data to USB :@

have you tried smaller files?

18 more replies
Answer Match 47.04%

I just copied some pictures from cd to h/d using copy and past.
Now i would like to copy data mp3. to my new pc.Would copy and past work?
Tks
 

A:how to copy data mp3 to h/d

Yes, copy and paste will work.
 

2 more replies
Answer Match 46.62%

Did this billions of times with other MS versions but have never done it w/vista.

Have to copy medical files from hospital. TY
 

A:Vista copy data dvd to dvd...

Easiest method: Copy all the contents to a folder on your hard drive. Then copy those files to another blank disk.
 

2 more replies
Answer Match 46.62%

I have a large Word Perfect file that I want to put on a CD. This CD will be sold to several - maybe 50 - folks. I want to prevent the CD from being copied to another media (hard drive, CD, etc) but I want it to be printable and/or even readable.

Is this possible?? Thanks, Bob
 

A:Copy-protect a data CD

Possible.. But not easy.. Only way I can think of doing it is useing multiple forms of copy protection. I'd use a total hash of the TOC or the CD-roms serial to act as a PGP encryption key, or maybe even a password protected zipped file based on the cd's serial.. Someone could still make a image of the CD including the TOC and serial, but it'd be a whole lot harder.. Even then, unless you wrote your own viewing app, they could still just hit file/save as/ and save it to thier hard drive..

There's a sample of useing a CD's serial as protection here: http://www.codeproject.com/win32/cdcheck.asp

Nero has a tool which can read the serial of blank CDR's.. Can't remember the name of it though..

It would slow down the duplication process, unless you wrote some kinda macro to automate the process..

I've also seen a few freeware protections, you might google for some to try..
 

3 more replies
Answer Match 46.62%

Hi, I have a program that I have installed and works fine, the only thing is I have to keep putting the data disc in the dvd drive to use it. Can I copy all the data onto my computer so that I don't have to use the disc.
 

A:data disc copy

It might help if you told us the name of the program and what operating system you are running.

What kind of data is on the disc that is needed by the program?
 

3 more replies
Answer Match 46.62%

Can I copy a DVD data only, not movie or sound, on my Toshiba DVD player, recorder. I will use the data disc on my computer but don't want to damage
the original disc or the recorder.

Thanks
 

A:DVD data copy on recorder

Depends on the data and manufacturer of the disk.. some companies protect their dvds from copying (usually video games). You won't damage either the original DVD or the recorder in the process of trying but you just may get a faulty disk copy that won't read.
 

1 more replies
Answer Match 46.62%

Hello, I am trying to copy data (fields) from one form to another and I found a VBA code as follows:

Create the command button on the form and double-click it in design mode.
You now are the VBA mode for that button in the click event.
Simply add all the fields in this form:
Anotherform![fieldname] = Me![fieldname]

I tried but im getting the following error message:

"run-time error 424

object required.

Help!
 

A:Copy data from one form to another

Before I try and answer the VBA question can I ask why you want to do this?
As copying data is not supposed to happen in Relational Databases, data should be referred to.
 

1 more replies
Answer Match 46.62%

DDS (Ver_10-03-17.01) - NTFSx86 Run by Ali at 9:37:32.76 on Tue 09/28/2010Internet Explorer: 6.0.2900.2180 BrowserJavaVersion: 1.6.0_20Microsoft Windows XP Professional 5.1.2600.2.1252.1.1033.18.3071.2646 [GMT 7:00]AV: ESET NOD32 Antivirus 4.2 *On-access scanning enabled* (Updated) {E5E70D32-0101-4F12-8FB0-D96ACA4F34C0}============== Running Processes ===============E:\WINDOWS\system32\svchost -k DcomLaunchsvchost.exeE:\Program Files\Sandboxie\SbieSvc.exeE:\WINDOWS\System32\svchost.exe -k netsvcssvchost.exesvchost.exeE:\WINDOWS\system32\spoolsv.exeE:\Program Files\ESET\ESET NOD32 Antivirus\ekrn.exeE:\Program Files\Java\jre6\bin\jqs.exeE:\WINDOWS\system32\nvsvc32.exeE:\WINDOWS\system32\svchost.exe -k imgsvcE:\Program Files\TuneUp Utilities 2010\TuneUpUtilitiesService32.exeE:\Program Files\Modem AC2726 UI\bin\MonServiceUDisk.exeE:\Program Files\TuneUp Utilities 2010\TuneUpUtilitiesApp32.exeE:\WINDOWS\Explorer.EXEE:\Program Files\ESET\ESET NOD32 Antivirus\egui.exeE:\WINDOWS\system32\ctfmon.exeE:\Program Files\Internet Download Manager\IEMonitor.exeE:\Documents and Settings\Ali\My Documents\Downloads\Programs\dds.EXE============== Pseudo HJT Report ===============uInternet Connection Wizard,ShellNext = hx... Read more

A:Really laggy when i copy/cut data

Hello and Welcome to the forums! My name is Gringo and I'll be glad to help you with your computer problems. Somethings to remember while we are working together.Do not run any other tool untill instructed to do so!Please Do not Attach logs or put in code boxes.Tell me about any problems that have occurred during the fix.Tell me of any other symptoms you may be having as these can help also.Do not run anything while running a fix.In the upper right hand corner of the topic you will see a button called Options. If you click on this in the drop-down menu you can choose Track this topic. By doing this and then choosing Immediate E-Mail notification and then clicking on Proceed you will be advised when we respond to your topic and facilitate the cleaning of your machine.We apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here.In order for me to see the status of the infection I will need a new set of logs to start with.Please print out or make a copy in notpad of any instructions given, as sometimes it is necessary to go offline and you will lose access to them.DeFogger: Please download DeFogger to your desktop.Double click DeFogger to run the tool. The ap... Read more

16 more replies
Answer Match 46.62%

For example I have data1.kom and data1.kom but they have different data in them. When I paste it, it gives data1.kom - Copy. How do I just get it to replace the original data1.kom?

A:How to get rid of data - Copy when pasting?

One of the basic rules of computing, and I think this applies to everything from super computers to tablets and to all operating systems, is that you cannot have two files in the same 'place' with the same name.
 
If you want these two files as separate files then you are going to have to rename one of them - at its simplest append the date you created it. So, 'data1 May.com', 'data1 June.com' and so on.
 
If you only want one of them, the one with the latest data, then use the 'Save as' command. In your case 'Save as . . . data1.kom' and this will replace the earlier file with the later one.
 
Chris Cosgrove

0 more replies
Answer Match 46.62%

how do i make a printable copy of files names from a dvd/cd without having to type it out myself?
 

A:printable copy of data

Real easy to do from a dos prompt but you will probably find it easier to use Karen's Directory Printer.
http://www.karenware.com/powertools/ptdirprn.asp
 

1 more replies
Answer Match 46.62%

Hi all ,,,I am wanting to copy certain keys data from the registry from my main computer to my laptop but having a problem how to do it. I see I can print the key name from the edit menu in regedit but how do I do the same with the data and type.
It would be ideal for me to just copy it straight across but as I say I have no idea how to or even if its possible.
Could someone help me please and I will be grateful for any replies.
Len

A:How can I copy the key data in registry

I would not recommend to copy registry across the PC which might cause the PC unbootable. To copy certain key from registry, just click on the key to hight light then click on File->export.

10 more replies
Answer Match 46.62%

Hopefully someone out there can help because I am out of my depth. I'm a PC user rather than a techy (no offence to you guys who understand all of this stuff!) and my computer seems to be causing problems.

I discovered the other day that I could not burn CDs from WMP, WMP kept asking me to install a burner and restart. Problem is nothing had changed on my computer (maybe an anti-virus update but nothing more). I have tried investigating the problem on the web and tried every solution I have found - none have worked.

All my drivers are up-to-date, the CD-RW is working properly (according to the system - XP) but I cannot burn CDs from WMP or Realplayer nor copy files from my c drive. I have even replaced my CD-RW with a new one just to find the problems are still the same!

Can anyone help me?

I have a Dell Dimension 8200 with 4MB of memory, 1 x 80GB HDD, 1 x 200 GB HDD running XP Professional.
 

A:Cannot Burn CDs or Copy data to CD

i had same problem bro
are u using vista
whatever software are you using try any other may it work
i had 4 cd & dvd burning software
but just 2 is working i don't know and i never try to
dvdsanta is best for dvd burning very easy
try cdburnerxppro for make cd or media player is work great
sorry i am just suggesting the best software if this not work u need to try something else.
 

3 more replies
Answer Match 46.62%

a while ago i reformatted my hd with windows and ubuntu. Now stupid windows is malfunctioning... again.

i would like to make a new partition and install windows, but have all my data preserved.

also, what the hell is with the keyboard and mouse??? they don't work at alll!

A:Copy data from old partition

If you install Windows right on top of the existing installation, your user data and program files will be backed up to Windows.old, in the root directory of the partition (C:\). However, your programs will not be saved.

5 more replies
Answer Match 46.62%

I am very new to excel macros, though I make frequent use of excel. 10 years experience.
VBA is foreign to me. Question is: how do I make a macro to click on first case number on a web page, then bring selected data from a mozilla web display of the details about that case to a row of excel?
Also, need then to return to web page, use go back on browser to previous page which is a list of court cases, by the case no. only, and drop down to the next case, click on it, then select same data fields from the next case, and transfer it to next line in the excel sheet? Continue till run out of cases on the page listing the case numbers. The data when transferred should look like the 2nd item unde the headers. I successfully made a little macro that puts the headers on the exel sheet.

The answer may involdve something I am doing. The macro will transfer successfully when I transfer only one data item. however, when I try more, it puts the last item copoied into all the fields.
I am running on xp, windows 8, excel 2007, Mozilla, though I have IE 8 also.
Thanks for any help you can give me. I have successfully used the query in excelll, but thought this would be better.
LENDERADDRESSCITY ST ZIPOWNERDATECV#2010 CV 11112010 CV 1111Pict
2010 CV 1111Pict Pict

2010 CV 11112010 CV 11112010 CV 1111JPMORGAN CHASE BANK NA1931 NEBRASKA DRPict
XENIA, OH 45385Pict Pict

FUGATE, STEVEN D10/15/20102010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 11112010 CV 1... Read more

More replies
Answer Match 46.62%

Is there any faster way to copy 2 TB Data in Windows (with a USB 2.0 Ported Notebook) other than copy and paste?

Copy and paste would take around;

20 MB/second * 60 ≈ 1200 MB/minute ≈ 1.2 GB/minute
1.2 GB/minute * 60 ≈ 72 GB/hour
72 GB/hour * 24 ≈ 1728 GB/day ≈ 1.728 TB/day.

Is there any other faster way to do this?

or

As you would see from My System Specs, I have an ASUS G72. Is it possible for me to change one of the USB Pairs from USB 2.0 to USB 3.0?

I searched Google, found some information about other brands/models or general warnings. I was wondering if anybody has some more specific information?

Thanks.

A:Any Faster Way to Copy 2 TB Data?

Might try TeraCopy. See if that gives you any better results.

Copy your files faster with TeraCopy

9 more replies
Answer Match 46.62%

I need to recover some data off of a 120MB high-density diskette. I did a back-up onto this disk, but since then I got a new computer which doesn't have the high-density drive to read the disk. Can anyone help me get a regular disk or cd-rom copy of this data so I can try a restore and recover my database?
Thank you!
 

A:need to copy data from 120 MB diskette

6 more replies
Answer Match 46.62%

Hi Guys

Hi am trying to duplicate the entire content of a table into the same table but adding the prefix "A_" in front of the new data. With this i will have the same data twice but one with the "A-" all in the same table.

Can any body help me?

Thanks
 

A:Copy data table

8 more replies
Answer Match 46.62%

Hello,

I am looking for a script (.Bat) file to copy data from a directory on server A to another directory on server B.

For example copy the entire contens for MSSQL folder on the C Drive "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\MSSQL" TO another direcotry called "SQL" on server with the following address 1.1.1.1 as an example.

Can someone assist?

Thanks,
b
 

A:Script to Copy Data

16 more replies
Answer Match 46.62%

I've got two hard drives, a 100gb Maxtor 7200 Rpm, and a Western Digital Raptor 74gb 10,000k Rpm. The maxtor has windows XP Pro, and the Raptor has Pro 64 bit. i was only using the maxtor as an interim drive until more drivers came out for 64 bit, but the drivers i want won't be developed :( So i want to put my 32bit O/S on the faster drive.

I basically want to move the 32 bit o/s, all the existing files/programs/settings to the 74gb drive. Is this possible without using a program such as Norton Ghost? Being that the drives are different sizes, will the partitions stay in place? Will i have to install windows fresh on the 74gb drive and just sit there all day moving stuff?

A:Copy Data to another drive.

You should be able to use the manufactures disk utility to copy or "clone" the drive.

http://support.wdc.com/download/inde...pid=999&swid=1

7 more replies
Answer Match 46.62%

Hi All, a Newbie here, can anyone please help me. I have uploaded a file named ďremoving blanks and recording data.xls. on which I am trying to list the IDís of Clients and how much they owe. My problem is that I wish from Cell F14 of the Income Sheet to list, without any blanks, any amounts found in column M of the Payments Sheet and then in Cell E14 of the Income Sheet to record the associated data found in Column E of the Payments Sheet. Iíve checked my formulas textbooks and googled but canít get close to a solution. Any ideas would be appreciated.
 

A:Copy data without the Blanks

11 more replies
Answer Match 45.78%

I need help to create a macro to copy data in a range of cells resulting from another formula to a range of cells on another worksheet. Specifically: Summary!B2:B25 to Inventory!C3:C26.
The data in cells Summary!B2:B25 is resulting in a commands like =('7788'!I2) from other worksheets

When I record the macro and select the source cells then paste at the destination cells, It copies the formula from the source cells and increases the column in the source formula by 1 to the right and looks like =('7788'!J3).

I believe I need to use a macro for this as the 'Inventory' sheet has a few different columns for doing physical counts on different days. The macro will just load the current on hand count from the 'Summary' page to the column of choice. The next time a physical count is done, the next column will be used and current on hand counts will be copied by the macro to the new column.

Your help would be greatly appreciated
 

A:Macro to copy data keeps failing

Hi, welcome to the forum.
I must assume that you are using Excel (since you didn't mention it), but if this is the case I suggest you also mention which version.

Have you tried editting your macro to use the real address values?

A simple sample with fictitious data will help to "see" what you mean.
 

1 more replies
Answer Match 45.78%

Hi, Can someone help me with this problem. Please refer this spreadsheet.https://docs.google.com/spreadsheet...Let say for the table 1, C6 i choose Sam, how can it copy automatically data from table 2 to table 1 (D24:K24 to D6:K6)Thank you.message edited by nur11

A:What formula to copy data to table?

First, a posting tip:When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "I Need A Formula" we wouldn't be able to tell one question from another and the Archives would essentially be useless. I have edited your subject to be more relevant to your question.That said, try this:Put this in D6 and drag it over to K6 and as far down as you need.=INDEX($D$24:$K$35,MATCH($C6,$C$24:$C$35,0),COLUMN()-3)The MATCH function will determine which row of the lookup_array C24:C35 contains the value in C6. It will use that as the row_num argument for the INDEX function. COLUMN()-3 is the column_num argument for the INDEX function. By using the COLUMN() function as opposed to hard-coding the column number of the lookup_array, you can drag the formula over and the column_num argument will update itself.Let us know if you have any questions.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Answer Match 45.78%

My hard drive just changed to fat32 for some reason and all the data is gone?

Does anyone know what could be wrong, can I get my data back?
When I start it up it goes through a check, ive left the check running and its been going ages, im not sure what its doing. Says something about lost clusters and truncated?
 

A:How to copy data from one hard drive to another, different OS

 

1 more replies
Answer Match 45.78%

I have a "Master" spreadsheet, and on that spreadsheet there are tab names that correspond with about 4 other worksheets. What I am wanting to do is copy the data from the worksheet, to the "Master" workbook's worksheet with the same worksheet name. I have this code:

Code:

Subscript out of range
Set wb = Workbooks.Open(Filename:="R:\Test\Master.xls")

Set wb = Workbooks.Open(Filename:="Z:\Test\Test1.xls")
Sheets("January").Rows("3:200").Copy
ActiveWorkbook("January.xls").Activate
Sheets("January").Select
Range("A3").Select
ActiveSheet.Paste
Range("A3").Select
Set wb = Workbooks.Open(Filename:="Test2.xls")
Sheets("Feb").Select
Rows("3:1000").Select
Selection.Copy
Windows("Feb.xls").Activate
Sheets("Feb").Select
Range("A3").Paste
Range("A3").Select

But I keep getting a subscript out of range debug error. Can someone shed some light onto what is causing that error and what modifications need to be made so that the error doesn't continue?
 

A:Solved: Copy Worksheet Data

When and at which line of code do you get the problem?
Have you tried running the macro step-by-step?

Subscript out of range means that you're referring to something that is not there "out of range"

Since I don't have your files and sheets it can be anything.
 

2 more replies
Answer Match 45.78%

Hi Again everyone;

May I please ask for some additional help.

I wish to copy data (not cell formulas) from F115:K115.
I am "trying" to use the following VB formula;

Range(Range("("f115"), Range("f115").end(xltoRight)).Copy Range ("J10")

Actually, the above VB formula copies and puts something into the 7 cells to the right of J10, but it's all gibberish.

I see that I am copying a mish-mash of cell references and so forth, and not 'just' that data (the values) which are in these cells.

Would someone please tell me how to copy 'only' the values which are in cells (F115:K115) ...
Oh yes, the values in these cells (F115: K115) keeps changing (as I want it to do) but the data does remain in these cell locations.

As always, thank you for your help.
J.
 

A:Please: how do I copy (in VB) only data and not cell formulas and such

Hi J,
I assume you are talking about VBa and Excel (version (?))
If you want to copy a range of cells just do that.

You could even record the macro and see what it does.

Range("F115:K115").Copy
Range("J10")..PasteSpecial Paste:=xlPasteValues

You select the rannge you want to copy and then select the first cell in the target range and paste

Hope this helps, if not, I suggest you put some more information in your post, you know, we are quite good at helping but guessing and asuming, that's quite a different matter
 

1 more replies
Answer Match 45.78%

Hi!

What kind of copy speed can one expect? I get like 20MB/s which seems slow (copy on the same HDD)? (but still faster than copy and past when i got 2MB/s).
I need to change my account name and therefor I need to copy my whole user folder of 90 GB and it takes forever...

Is there something I can do to speed things up?

Regards Martin

A:Data transfer copy speed

Originally Posted by martins77


Hi!

What kind of copy speed can one expect? I get like 20MB/s which seems slow (copy on the same HDD)? (but still faster than copy and past when i got 2MB/s).
I need to change my account name and therefor I need to copy my whole user folder of 90 GB and it takes forever...

Is there something I can do to speed things up?

Regards Martin



Hello. Take a look at this tutorials.
Search on for Speed up Hard Drive performance.
Speed Up the Performance of Vista

Alex.

6 more replies
Answer Match 45.78%

I am using Windows 7 Ultimate 64 bit. I have two DVD Burners.

I have a Data Disk I want to copy. Can I do this with CDBurnerXP?

If I can, how do I do it?

If not is there any free burn software that will do it?

Thank you

A:Copy a Data Disk with CDBurnerXP

Hi there ... Imgburn might be a better choice ... All depends on what you are trying to Burn ..
https://cdburnerxp.se/help/Data/copydata

3 more replies
Answer Match 45.78%

Hello

I have a list that will always very in the number of rows. I want to copy a formula from F2 all the way down until the last information in column A. The formula I want it to copy down is =VLOOKUP(E2,'br vs cc'!$A:$B,2,"false")

So in my worksheet column A has info in A26(as well as 24 and 25). However there is no corresponding information in columns D thru H in rows 24 and 25. But I want the formula to copy to f26.

Can anyone help me with the coding for this?
 

A:Solved: VBA copy formula down until last data

8 more replies
Answer Match 45.78%

in my place , there are 3 systems on the LAN network.after i shared the folder , when i try to copy the content on that shared folder over the LAN or local through run prompt as \\ 10.0.0.12 i got the error as

"make sure the disk is not full or write protected and that the file is not currently in use "
when i open file on that shared folder over the LAN or Local through run prompt as \\ 10.0.0.12 i got the error as

access to \\10.0.0.12\***\***.doc was denied.

i want the needful solution to make file sharing over the LAN

OS - Windows xp professional

erroe : "make sure the disk is not full or write protected and that the file is not currently in use"
 

A:can't copy and read data over LAN network

9 more replies
Answer Match 45.78%

Hi,

I was using 250 GB hard disk. Now attached 800GB New hard disk. Both hard disks are showing perfectly. Now i want to copy all data from old hard disk to new hard disk.

For example my "OLD D drive was 50 GB" and "New D Drive is 100 GB" So i want to copy all the data from old d drive to new one. I tried to use "Disk Clone" software. but it was saying partition should be equal. And than i tried "Backup software" so it made whole D drive back with the file name "backup.PBD" .

I can go to old D drive and select all , than copy all the data. And than open new hard disk partition D drive and paste. but it is taking too much time, and not sure it will copy all the data. Or it will give error after few hours. So i want to use software for it.

Your help will be appreciated. Thanks.

Best Regards,
Farrukh Hussain
Http://www.websolpro.com
 

A:Solved: Copy data from one partition to another

Hi, have you tried the program super copier.

Its still copy and paste but its better and has more functions then the regular windows copier.
 

2 more replies
Answer Match 45.78%

I am having trouble copying large amounts of data, and was wondering if there were certain ways to speed up the process. Patch a few .dll's? Use a program?

Thanks in Advance. =)

~Joshua~

A:Copy Large amounts of Data

Try Teracopy.

Copy your files faster with TeraCopy

8 more replies
Answer Match 45.78%

What is a good data cd copy to cd software?
I would like one for dvd to dvd-also?
 

A:What is a good data CD copy to CD software?

PowerIso can do that

PowerIso can do that
 

2 more replies
Answer Match 45.78%

I'm going to sound really stupid here, but I have ME (six years and counting) and sometimes (often?) am completely 'brain dead' and unable to think logically (or even at all). Today is one of those days...

I want to copy some programs (e.g. AVG internet security) and files/documents from my p.c. to my Acer laptop. I know I should be able to do this with an interface cable, but don't seem to have one with the right end connections.

I guess I should be using one with flat connections either end but I don't have one and can't seem to find anything suitable on the net. Can anyone advise me exactly what I should be looking for - and, as importantly what I should ask/search for?

Just to explain - shall be using my laptop as only source of IT and communication (am also deafened, so use email exclusively) as p.c. is going into storage for 5 weeks due to house move.

Apologies again for appearing such a dunce!
 

A:Copy programs and data from p.c. to laptop

Hi,
I don't think you can just move programs by cut & paste like you can with docs & photos - you need to do a fresh install. This site will help you with some more widely used progs.

http://ninite.com/

Sorry I can't help with the cable question.

Richard
 

3 more replies
Answer Match 45.78%

Hi,
I have an inventory spreadsheet that tracks the order number, product ID and the costumer billing and shipping information. Unfortunately the customer information is only associated with the 1st product ID of the order. I need the same information populated for each of the products associated with the same order number. I've been doing it manually with a cut and past but it's very time consuming, not to mention quite tedious. Can someone help me with a short cut of some kind. My apologies for the text written spreadsheet. I don't know how to insert a picture of the real one. Thanks in advance for your help.

Using Excel 2000

A______B_________C______D_______E_____F_____. . . . M
1__Order#__ProductID__Name__Address__CC#__Date_______Date1
2__7000____jp100_____Smith___123_____54___12/04/04___12/03/04
3__7000____aw123
4__7000____sa45
5__7000____jp100_____Doee____456_____54___12/04/04___12/03/04
6__7001____jp100

I need to copy fields C through M of line 2 and paste them in fields C through M of lines 3 and 4. Same thing for fields c thru M of line 5, pasting into line 6. And the list goes on and an....
 

A:Excell help - copy a line of data.

12 more replies
Answer Match 45.78%

Hi,

I have 3 sheet name as A, B, and C. I wan to check if sheet A data has not exist in sheet B, then it will copy whole row from sheet A to sheet B and C. If data in sheet A is exist in sheet B, then it will skip to the next row.

Can someone help me with create a macro?

Thanks
 

A:Macro> If data not exist then copy

6 more replies
Answer Match 45.78%

OS: Dual-boot Windows XP Professional x32, Windows 7 Ultimate x64. (Windows XP earlier OS)
CPU: AMD Athlon 7750 x2
RAM: 4GB
GPU: Nvidia GeForce 9500gt
HDD: Seagate 500GB

Hi guys. For the last two days whenever I am starting my PC, just after the MB logo, I am shown a black screen where at the bottom it is written 4th Master Hard Disk S.M.A.R.T. Status BAD. On searching the net, I found that it indicates my HDD is dying. I am going to buy a new one. How do I transfer the data from the old one to the new HDD? I am not concerned about installed programs, only things like data files, images, songs and such things.
Thanks in advance.

A:How to copy data from old hard disk to new one

After you get the new hard drive and Windows installed. Either install the old drive as a second hard drive or put it in an external USB enclosure and you can copy off what you want to the new drive.

If the data you want isn't that much you could also copy it to a flash drive (USB key) or even burn CD/DVD's.

Which brings up an important point. Your user data, at a minimum should be periodically backed up to some external media or one of the on-line backup services (I like my own media better). If the drive is failing and falied completely all your data would be lost, if not backed up. Backups are not for IF they are needed but for WHEN they are needed.

9 more replies
Answer Match 45.78%

I initially posted in this forum and after a couple of fixes failed was directed to post in forum HijackThis Logs and Virus ect..... which I did. My post is http://www.bleepingcomputer.com/forums/ind...=193433&hl= It's very busy over there, my topic is now on page 13 and still waiting for an initial response.While I am waiting for assistance is it safe for me to try to copy some data, mp3 files, to cd's or a network drive? I think I should prepare for the worst, and would like to retain data from that drive that I have not backed up previously. The infected computer is in safe mode. Sometimes it sounds like it is shutting down, but doesn't.Advice greatly appreciated.

A:Infected - Can I copy data to a CD or other Drive?

you should NOT make further changes to your computer (install/uninstall programs, use special fix tools, delete files, edit the registry, etc) unless advised by a HJT Team member, nor should you continue to ask for help elsewhere. Doing so can result in system changes which may not show it the log you already posted. Further, any modifications you make on your own may cause confusion for the helper assisting you and could complicate the malware removal process which would extend the time it takes to clean your computer.From this point on the HJT Team should be the only members that you take advice from, until they have verified your log as clean.Please be patient. It may take a while to get a response because the HJT Team members are very busy working logs posted before yours. They are volunteers who will help you out as soon as possible. Once you have made your post and are waiting, please DO NOT make another reply until it has been responded to by a member of the HJT Team. Generally the staff checks the forum for postings that have 0 replies as this makes it easier for them to identify those who have not been helped. If you post another response there will be 1 reply. A team member, looking for a new log to work may assume another HJT Team member is already assisting you and not open the thread to respond.If after 5 days you still have received no response, then post a link to your HJT log in the thread titled "Haven't Had A Reply In Five Days?".To avoid confu... Read more

1 more replies
Answer Match 45.78%

Im making a database of Purchase Orders, and on one of the screens theres a list box with all the PO's listed which you can double click on to open up a "View PO" form, that displays all that purchase order details.

It was all working fine, until i got rid of my test PO's and copied and pasted the real PO's from an excel spread sheet. The PO's appear in the listbox, with the few details the listbox provides, but double clicking them opens up "View PO" completely blank.

Any new purchase order i make will have its details displayed, and i even went back to an old .mdb (as opposed to the front end/back end .mde's i was using) to test it, and in there SOME will display data, others wont.

Really stuck on this one, can generally just google the error message and find an answer, but there is no error message..

thanks for any help
 

A:Access - Copy and paste data

If you still need help on this, I would suggest that you look at the Relationships of your tables.
If you have more than one Table in your database you may need data in the other tables to allow the View PO form to display the data.
By pasting the PO data in, you may be missing the required data in the other table(s).
 

1 more replies
Answer Match 45.78%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 1132 MB; D: Total - 36294 MB, Free - 1396 MB;
Motherboard: ECS, G41T-M
Antivirus: AVG update module, Updated: Yes, On-Demand Scanner: Enabled

Hi
Having a problem of solving this, data has been put into sheet1 via a userform starting with a name in cell A1 as the beginning of the data where a combobox gives you the choice of data. Now, in the userform there are 3 textboxes which has to be completed with notes (comments ect) all collected in the data sheet. I get the data from there to sheet2 into an INVOICE form, but cannot get the notes (comments) into textboxes in the INVOICE form, also 3 textboxes.
Please any help solving this.

Thanks in the meantime

Rusty
 

A:Solved: Copy of Data to textbox

7 more replies
Answer Match 45.78%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 1048 MB; D: Total - 36294 MB, Free - 1396 MB;
Motherboard: ECS, G41T-M
Antivirus: AVG update module, Updated: Yes, On-Demand Scanner: Enabled

Copy of Data to textbox

Hi
Attached is a copy of the file I had fixed by "XCubed" and which is working perfectly, but as you can see on the file sheet "Report" I do need another textbox on the Invoice which is pointed out to where it should go. I need to no what code should be added to put the data from sheet "data" in the exstra box.
Any help anyone? I hope the link above to the previous thread works

Rusty
 

A:Solved: Copy of data to textbox

Hi Rusty

You don't say what data you want in the new text box. Here is the code you would need to add to cmdViewReport_Click()
Code:

wkt2.Shapes("Text Box 47").Select
Selection.Characters.Text = wkt1.Cells(rowpos, 17).Value

and where it has "(rowpos, 17)" you would replace "17" with the column you want to pick up.

This will apply to any new text box you add. When you add or "select" a text box you can see (and change) the text box name just to the left of the formula bar. Then add the code as above referencing the new text box name.
 

2 more replies
Answer Match 45.78%

i have just been given an old harddisk that was replaced on a friends PC as it started to make a noise. however, they wanted to know f they could get some data off it.

as this is a boot disc is there any way I can put it into a system as a 2nd drive set to slave and see the data - or will it try and boot and the system see 2 "C:" drives?????
 

A:how to put old boot disk in pc to copy data

You should have no problem putting the disk into your system as a slave drive. It will not boot if there's already a bootable Primary Master hard drive in the system. And as long as the drive is not formated in NTFS and you're not using Windows9X to view it, then you should not have any problems - given the drive still works.

Just set it as Slave if attaching it to a cable with an existing drive or leave it as Master and put it alone on the Secondary IDE.
 

3 more replies
Answer Match 45.78%

I have a combo box with 3 columns showing, at least in the drop down section. The box itself just shows the text from the 2d column, which is just perfect. What I would like to be able to do is copy that text and paste it elsewhere on my spreadsheet. I learned how to use the LinkedCell, but the text from the combo box that I want to copy will need to copied to different places. Is there a way to link the combo box to the active cell or to be able to drag the text to another cell?

Basically, I have a long list of names, and I want to be able to scroll through it, pick out the name I need and stick it in a cell, find the next name, and stick it in another cell, and so on. I would like to keep the array from which I'm populating the combo box on a different worksheet from the one on which the combo box resides and onto which I need to copy and paste in those names. Can I do this?
 

A:Copy data out of Excel Combo Box

16 more replies
Answer Match 45.78%

HI

I have 3 workbooks - A (Mary), B (John) & C (Master)

Workbook's A & B have the following on worksheet 1

Columns B & C contain cell data
Columns D, E, F & G contain combobox data

All data is in rows 6 -34

Workbook C has the same as above, yet on 3 different worksheets

What I want to be able to do is -

Code a button on Workbook C to copy the data from Workbook's A & B to Workbook C's worksheets "Mary" & "John"
Then have it copy the data from these worksheets to a "master" worksheet contained in workbook C.

In otherwords I want to be able to keep Mary & Johns data on seperate worksheets, yet still have an overall view of all of the data - is this possible ??

Any help would be greatly appreciated
 

A:Copy Data between excel workbooks

Hi
It is most definitely possible. We'd need a lot more information to start helping you but you can do a lot to start yourself off by recording a Macro. Try that and see how far you get and come back to us where the macro is failing or needs customisation and we can provide specific help.
 

2 more replies
Answer Match 45.78%

Hello,
I'm using Windows XP and i want to copy all data from my computer's hard drive (D: ) to another computer's hard drive.. DO i need a special hardware for this purpose?
Plz help..
Thnx.
 

A:How to copy data from one hard drive to another in a different PC?

10 more replies
Answer Match 45.78%

EXCEL Question:

I am needing to copy cells from one tab to another (and only copy cells with data) using a Macro.

Tab "Checkout" has data starting in cell A3, B3 and C3. This data could have one or more rows/columns.

I am wanting to copy this data into the "Database" tab. If there is something already entered on row, I need it to go to the next to insert the copied data.

Any and all help is greatly appreciated!
 

A:Copy only cells with data into another tab using a Macro

Hi, welcome to the forum.
Do you have some knowledge of VBA? If so it's quite simple.
Record a macro to copy one row from one sheet to the other.
Stop recording after that.
Open the vba editor Alt+F11 and take a look at the macro code.
If you do not have vba knowledge, then it's another matter.
Question: what happens with duplicate numbers in column B?
I don't think you just want to copy everything from sheet 1 to sheet 2?
Maybe a little more background information?
 

1 more replies
Answer Match 45.78%

Seek for help !!!

I do not have any VBA knowledge, but i know Macro can solve my below problem.
Hope you are able to help me in this.

1. Data in IA sheet will change from time to time.
2. I would like macro to Copy all data in IA sheet & paste to INV Sheet (Blue cell).
If row in Blue Cell are not enought, then it will auto insert row until all the data is filled in.
3. Freight Charges will always in last rows of data.

I really hope & appreciate your help.

I have attached my file here for easy understanding.
 

A:Copy & paste data using VB macro

Try this...
Code:
Public Sub CopyRows1()

' Dec 23 , Ziggy

Dim wb As Workbook
Dim wsc, wsp As Worksheet
Dim CR As Long 'copy row
Dim PR As Long 'Paste row
Dim iLastRow As Long

Dim X As String

'Set wb = ThisWorkbook
Set wsp = Sheets("INV")
Set wsc = Sheets("IA")

X = "A" ' just assigned a dummy value
PR = 25 ' assumed the Data Heading always starts on Row 25

Do Until X = ""

X = Cells(PR, 1)
PR = PR + 1

Loop

PR = PR - 1

'The last row of the sheet copying from
iLastRow = wsc.Cells(wsc.Rows.Count, 1).End(xlUp).Row



For CR = 1 To iLastRow



Sheets(wsc.Name).Range("A" & CR).EntireRow.Copy Sheets(wsp.Name).Range("A" & PR)

' colors the cells blue, but the INSERT also automatically does it
Range("A" & PR & ":I" & PR).Interior.Color = (16777164)

PR = PR + 1

' inserts a blank line
Rows(PR & ":" & PR).Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove



Next CR


End Sub

 

1 more replies
Answer Match 45.78%

Hi ..Does anyone know why text copied from pdf to excel views as boxes? Sigh.. I need to copy lots of data from pdf to excel ...such a pain. Thanks for your help
 

A:pdf file data will not copy to excel

14 more replies
Answer Match 45.36%

Hello,

Part 1:
A client of mines harddrive started failing. I had problems copying files "the regular way" so I used roadkills unstoppable copier, a program that is described as the following:

"Recovers files from disks with physical damage. Allows you to copy files from disks with problems such as bad sectors, scratches or that just give errors when reading data. The program will attempt to recover every readable piece of a file and put the pieces together. Using this method most types of files can be made useable even if some parts of the file were not recoverable in the end."

Part 2:
My client got a new computer and I put all the files on the new computer and it seems to have worked.

Now Im trying to configure a backup system for my client but the problem is that I cant copy the files from the new computer. I have tried Cobian Backup, drag-and-drop and Windows 7 built-in backup with no success. Computer usually freezes. I get error messages like C:/users/documents/pictures/bla bla doesn't exist (although I can browse to the location and use the files).

So some things for your info:

- I have tried copying to two different working external harddrives
- I have succesfully copied the files from one partition to another (on the same drive)
- The computer that the files is on now is using Win 7 premium 64-bit
- Im only trying to copy documents/pictures (no system files)
- Ive tried using Unstoppable copier to copy the files from the new computer t... Read more

A:Unable to copy data from C: to external devices

I maybe stating the obvious here, has the external drive been formatted?
 

3 more replies
Answer Match 45.36%

Anyone have information on how to copy all data from one computer to another for Outlook 2003

Smitty
 

A:Solved: How do I copy Outlook Data to another computer

With Outlook closed, find and copy your PST files (usually outlook.pst and archive.pst) Also, it might be easier to just File-->Export and save them to a location you're more familiar with. If you've got tons of stuff, it could take a while, tho.
 

2 more replies
Answer Match 45.36%

Hi All

I have today taken delivery of my brand new Dell Latitude D820 - and boy oh boy am I happy!!

However, I want to copy all of the data from my MS Outlook 2003 app to the new laptop. Is there a way to do this? I have tried first with Notes and seem to get an error saying another application has lock a portion of the file and I seem unable to import all the notes into the Outlook on the new Dell.

Is there a way to import ALL my notes/contacts/calendar/emails etc in one go?

Thanks
 

A:New PC, wanting to copy MS Outlook 2003 data across... how?

Find your .pst files (probably Outlook.pst) file on the old PC.
Back this up, and put a copy on the new PC. It should be quite a large file.
Open Outlook, File - Import and Export - Import from another program or file - select Personal Folder file (.pst) - next - Browse to the file you transferred, follow the menus as required.
 

2 more replies
Answer Match 45.36%

Solving:
1) How to Copy Newest User Data (12-12-09) from Newest C Drive whose operating system will no longer boot up and the HD now is in a USB exteral storage unit;
2) Copy into working restored older Acronis backup of 9-10-2009.

Best Strategy please:? Other strategies?

I have available as tools:
1.WindowsPE Vista boot disk
2. Koppitz Bot disk
3. Vista Ultimate Installation package


Possible alternatives:
1. (A) Boot up with the WindowsPE Vista
(B) Click Users Folder (12-12-09) and Select ALL, Copy it
(C) Paste into Users folder of 9-10-2009
(D) Reboot

Or

2. (A) Boot up with WindowsPE Vista
(B) Rename Users Folder of 9-10-2009 to Users-Old
(C) Click Users Folder (12-12-09) and Select ALL,
(D) Copy it to C drive
(E) Reboot

or

Other or Better strategies?

Thanks

More replies
Answer Match 45.36%

What software makes a second copy of a data drive an then updates it
later on. I am looking a best methods to back up my data drive which
is my second drive in my computer. I was looking a software package
called "second copy" but I don't know if that is best.
Note, it takes over 24hr to fully copy my data drive so what backup
stragies is best for me.
Thank you,
 

A:Backup Making a second copy of data drive

I highly reccommend Acronis True Image 10. It works with Vista as well as XP. I backup my "C" drive with the OS and programs on it in about 30 minutes. My data drive which contains about 87GB of data takes less than an hour to backup to an internal backup drive. I do this by making "exact images" of the drives. If any of my working drives go bad I simply replace and restore the image from my backup drive and I'm back in business as if nothing happened. Or, in case a file becomes corrupted or accidentially deleted, I can restore individual files very quickly. This program has saved my butt several times and it's well worth the price. NewEgg has it for $39.99 here: http://www.newegg.com/Product/Product.aspx?Item=1528708SF
or you can get the downloadable version for only $31.99 at NewEgg.
 

1 more replies
Answer Match 45.36%

I have a shared 2003 excel spreadsheet that has sheets for each user to input data into on a daily basis. I then have a master sheet that I compile all the data onto. Usually i have to copy the data from each user sheet individually, and then paste it on the master sheet. From there I filter the data on the master and build reports from that data. And there lies the problem, it is very time consuming to do that on a bi-weekly basis.

What i'm seeking to do is have a formula to do that for me automatically or some way to compile that data quickly on the seperate sheet. All this data is in the same workbook. I need to be able to compile all the individual cells in column A of the user sheets, and paste them into column A of the master sheet(colum b from users to column b of master, etc), without adding cells together, or anything like that. Each individual cell in a column from each user sheet needs to be copied and have it's own cell of the same column of the master sheet. I have 15+ user sheets with two tables of data, and two masters for each table of data, that needs to be transferred over bi-weekly for reporting.

Anyone know a formula or process that could do this either automatically or quickly without having to manually copy and paste the data? I do not have access to VBA or the ability to install anything since this is a work computer.
 

A:Excel 2003 Data copy formula

6 more replies
Answer Match 45.36%

Hi, I am looking to copy a row of data from a master sheet to a sub sheet based on the value in column A. this is for a sales organisation, so if cell a2 = "A" then copy whole row from master to Andrew's sheet. if cell a3 = "B" then copy to Bill's sheet and so on.Thanks In advance

More replies
Answer Match 45.36%

Dell Inspiron, Vista, SP2, 32bit, Home Premium

I want to copy data, all text, from a CD to a flash drive but I don't see how.
Can someone please help?
 

A:Copy text data from CD to Flash drive. How?

16 more replies
Answer Match 45.36%

Hi,
I need copy files from one(source) server to another(destination) server and want to log an event in case any failure happens for example if destination server is not available.
I have tested the following command in a powershell script and its just working fine for copy to destination and then moving the files to archive. 

Copy-Item "c:\copy\*" -Destination "\\server1\d$\testcopy" 
Move-Item "c:\copy\*" -Destination "c:\Archive" 


Please advise how can i log event in eventviewer in case of error or if script is not executed.

More replies
Answer Match 45.36%

I'm trying to create a piece of macro code that will pick up all populated cells in a column (E10-E84), and copy both the value in that cell and the value on the same row in column A. I'd like the info from column A to be pasted into column A in an entirely different workbook, and the corresponding data from column E from the original worksheet to go into column B of the new worksheet. Data from the same row in the first spreadsheet needs to remain on the same row in the second. There is also information beyond row E84 which I do not want.

Here is what I've cobbled together so far, but it currently doesn't pick up any data which is a fairly big flaw!:
Sub MoveEM()
Dim wb1 As Workbook
Dim wb2 As Workbook
Dim rng1 As Range
Dim rng2 As Range
Workbooks.Open Filename:="Z:\DPC MI Folder\Copy of RPHD 2013-2014.xls"
Set wb1 = Excel.ActiveWorkbook
Workbooks.Open Filename:="Z:\DPC MI Folder\Checking Workbook.xls"
Set wb2 = Excel.ActiveWorkbook
On Error Resume Next
Set rng1 = "wb1.Range(E10 - E84).SpecialCells(xlConstants)"
On Error GoTo 0
If rng1 Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Set rng2 = wb2.[b1]
rng1.Copy
rng2.PasteSpecial xlPasteValues
'copy column I to Output C2
rng1.Offset(0, 7).Copy
rng2.Offset(0, 1).PasteSpecial xlPasteValues
'copy column N to Output d2
rng1.Offset(0, 12).Copy
rng2.Offset(0, 2).PasteSpec... Read more

A:Locate non-blanks in a column and copy certain data from the row

GCC83,

You have a couple of problems here:

1) The reason it doesn't seem to fail at a particular point is because you have employed "On Error Resume Next," which is a poor practice and should be avoided whenever possible. If that were not there, you would receive an error when the code stopped working. My recommendation would be to remove this line and implement a proper error trap.

2) This line:


Code:

Set rng1 = "wb1.Range(E10 - E84).SpecialCells(xlConstants)"

should be:


Code:

Set rng1 = wb1.Range(E10:E84).SpecialCells(xlConstants)

When you put quotes around something, it makes it a string and you are trying to assign a range object, not a string. Also, the colon should be used in place of where you have a hyphen. Hopefully, this will help!
 

3 more replies
Answer Match 45.36%

I need assistance with creating a macro. I need to create a lot of different reports but I want the macro to create them for me. Is there way to create a macro by: having a list of data, sorting it all by column A, then copying whatever is the same name in column A (and whatever is associate with column A- to the right) and inserting it into a new worksheet and then doing it for all the different data that is in column A. Then once it is put into the worksheet, to save it with whatever the name is from Column A in the first worksheet.

I figured that there needs to be a loop statement in the end so it will get all the grouped data together into seperate worksheets.

Thanks for your help. I have attached a spreahsheet to get a better idea of what I was looking for.
 

A:EXCEL MACRO- sort, copy different data

6 more replies
Answer Match 45.36%

Hello,

Can you copy data (pictures or messages or videos) from a virus (ie. key logger or any other malware or virus)
computer before formatting and reinstalling the OS?

Win 98 computer - virus type unknown for now.

Thanks

A:Copy data on virus effective computer

Hello milehigh28,

It depends on what infection was on the machine. If it is a file infector such as Virut or Ramnit, then no - those pics or music files may be infected as well and will reinfect a new install withina matter of minutes.

What you could do is copy those files to a CD - not a flash drive. Insert the CD and scan that drive at Eset...

Please go to here to run the online scannner from ESET. Turn off the real time scanner of any existing antivirus program while performing the online scan
Tick the box next to YES, I accept the Terms of Use.
Click Start
When asked, allow the activex control to install
Click Start
Make sure that the option Remove found threats is unticked

Click on Advanced Settings and ensure these options are ticked:Scan for potentially unwanted applications
Scan for potentially unsafe applications
Enable Anti-Stealth Technology

Current Scan Targets click CHANGE and select the CD Rom drive letter that contains the CD
Click Scan
Wait for the scan to finish
If any threats were found, click the 'List of found threats' , then click Export to text file....
Save it to your desktop, then please copy and paste that log as a reply to this topic.

1 more replies
Answer Match 45.36%

I've recently purchsed a new laptop with a combo DVD/CD RW drive. When trying to copy data (MP3, jpegs, etc) backed up on CD from my desktop, the drive often fails to read and I get error message "I/O Device Error" sometimes it will copy 100mb before doing this, sometimes it will not read anything. I've tried various CDs burnt on different PCs but all have failed. Purchased software seems toload OK. Even a CD burnt on my laptop failed to copy all the data back onto my hard drive, but all these Cs work on my desktop and work laptop.
The vendor insists that there is not a problem and it's common for some DVD/CD drives not to read all CDs. Is this correct. Is it because I'm trying to copy data by draging it? It's strange as it's an intermittent problem
 

A:I/O Device Error - Copy Data from Burnt CDs

If you can copy at least some DVD/CDs then the problem is media.
Make sure that the media has no scratches or dirt or finger prints on it.
Some drives are very picky as to media.
 

2 more replies
Answer Match 45.36%

Hi Everyone.

I have a Workbook with two work sheets. One sheet is called Course Data and the other is a sheet called Instructor Stats.

The Instructor Stats sheet has a cell B5 to enter an Instructors initials and a command button that when clicked will search the Course Data sheet for that Instructor.

I need help with the vba code that when the command button is clicked it searches the Course Data sheet for the Instructors initials in Column I and copies all occurances of that Instructors entries from B28 to N28 on the Course Data sheet and downwards too the end of the sheet, and copies them to the Instructor Stats sheet and places them in cells B14 to N14 and downwards on this sheet.

Can anyone help at all with this ? It would be really appreciated. I am only just starting to learn a bit about Excel and havant even looked at VBA yet
Thanks

Ortz

I have uploaded the workbook here. It is too large to attach here.

http://wikisend.com/download/789942/Course Data.xls
 

A:Solved: VBA to search for data and copy to new worksheet.

16 more replies
Answer Match 45.36%

I have a new computer with Outlook 2003 installed. I moved my Outlook 2002 personal.pst from the old machine to the new one and opened it in Outlook 2003 and copied each file folderís information to the new file folders in Outlook 2003. Every thing is ok except the calendar.

I can't figure out a way to copy the calendar folder from the old pst file without creating a new calendar folder in the Outlook 2003 file. I end up with two calendar folders and I only want one.

I've tried to drag and drop from the left window pane under calendars and nothing happens. I've also tired to select the pst calendar/right click/copy and paste to the new calendar folder and it creates a second copy.

I've also tried to export to a text file, but you lose all your reoccurring appointments.

I know there must be an easy way to do this. Any help would be appreciated!

Iím using:
Windows XP Media Edition SP2
Office 2003 Basic
 

A:Outlook 2003 calendar - copy data from old pst

10 more replies
Answer Match 45.36%

Hi, I hope someone can help me with this.Please refer this spreadsheet. https://docs.google.com/spreadsheet...In table 1, at functional role column (F7), there is list of functional role that I have to choose. At table 2 (AX6:DS25), I put this formula for cell AX9 =IFERROR(INDEX($C$203:$BX$231, MATCH($F9,$B$203:$B$231,0),1),"") so that when I choose the respective functional role, it automatically copied data from table 3 to table 2. My question is, how can I combine formula so that I can choose another list (Specific position column (G7), so that the data from table 4 can be copied to table 2, based on the specific position i choose.Please note that the row header is the same for table 2, table 3 and table 4. I hope u guys can understand my question.\Thanks in advance.

More replies
Answer Match 45.36%

Hi,
I have a workbook (sample attached) which lists customer data in cols A to J. Each customer has a main ref (col B) and may have any number of secondary refs in cols L onwards. Col K shows how many secondary refs the customer has, and is used in the code below to determine how many blank rows to add for those customers that have 1 or more secondary refs (1 row per ref)
Sub Insert_Row()
Dim LASTROW As Long
Dim I As Long
LASTROW = Range("C" & Rows.Count).End(xlUp).Row
For I = LASTROW To 2 Step -1
If ((IsNumeric(Cells(I, "K"))) And (Cells(I, "K") <> Empty)) Then
Range(Cells(I + 1, 1), Cells(I + Cells(I, "K"), 1)).EntireRow.Insert
End If
Next I
End Sub
The attached shows the worksheet having run the code
What I need now is for the code to do 2 more things Ė
1. Once the blank rows have been inserted for e.g. the customer in row 5, the value in L5 to be copied to B6, and the value in M5 to be copied to B7. (Could select, then transpose?)
2. Then copy the values in cells C5:J5 into the same columns in rows 6 & 7. (Not bothering with col A)
Sheet 2 shows the end result Iím after Basically, Iím consolidating main and secondary refs for each customer into one list.
Hope someone can help?
Cheers,
Phil
 

A:Solved: Copy data to inserted rows

11 more replies
Answer Match 45.36%

Windows7 (all latest patches) / iPhone (new)

Hi
How do I copy all my data files and documents on and off my iPhone ?
On my old (20GB) iPod IO can just us it like an external hard disk. i.e. I can copy and paste through windows explorer on WindowsXP and Windows7.
However although Windows can see the iPhone, it wont let me paste data onto it. (

- Any thoughts?

With thanks
Ship
Shiperton Henethe

A:How can I use my iPhone to copy data (e.g. Office docs)

  
Quote: Originally Posted by shiphen


- Any thoughts?

With thanks


Ship
Shiperton Henethe


Only thought I have is that you need a proper smart phone

3 more replies
Answer Match 45.36%

I have a budget workbook set up in Excel, and in that workbook there are many different sheets all part of the one book.

I have created a formula in one sheet from the data that is collected there, and that data is important for information collected on another sheet. I want to copy the formula and the data from that from that sheet and have it appear in the other excel sheet. I also want the data to change on the second excel sheet as the results from the formula change in the first sheet.

When i have tried to just copy and paste the formula from one sheet to the next I just get a ref error.

Many thanks for your help in advance.

Regards

Anthony

A:Want to copy data and formula from one Excel Sheet to another.

This may help
How to Copy Formulas in Excel | eHow.com

5 more replies
Answer Match 45.36%

I would like to reinstall Windows XP Home Edition on my HP Pavilion dv1000 laptop, but when attempting to backup important files by copying them to a blank cd, I received a message stating that my CD drive "is not accessible" and I am performing an "incorrect function," so I'm putting that option aside until I figure out what the heck is up with that.

On the other hand, I've somehow, miraculously (well, miraculous for me since I'm new at this) figured out how to print from my laptop through my desktop's printer by setting up a network (at least, that's what I think I did), so I was wondering if it would also be possible to backup files from my laptop to my desktop as well. Can I make that happen or is this just wishful thinking? My desktop also runs on Windows XP.

Could someone please throw me a bone here? I'd appreciate it.
 

A:Solved: Can I Copy Data From One Computer To Another Through A Network?

Yes you can! I don't have a bone to spare, but maybe this wizard will help.

Run the Network Setup wizard (found in Control Panel of XP). Tell it each of your computers connects to the internet via "residential gateway" and that you want to enable file and printer sharing. Create a disk at the end only if you have a Windows PC other than XP or 2k Pro or Vista or 7.

Windows XP firewall (if SP2 or SP3) will be properly configured by the wizard. You must uninstall or properly configure any 3rd party firewalls on each machine. Unique computer names and same workgroup, of course.

The Shared Documents folder is automatically shared. Any other folders (or drives) or printers you want to share, just right click on them and sharing ... . When sharing a printer, accept the offer to load other drivers if your other PCs have different Operating System(s).

When you first go into My Network Places there will be nothing there. The first time you click on 'View Workgroup computers' will probably result in great disappointment. It takes awhile (up to 15 minutes) before all the computers in the workgroup get up-to-date and accurate lists of the other computers. Often you can speed up this process via Search for other computers.

When computers show up in My Network Places, double click on one to see its shares. If that includes a printer, you can right click on the printer to connect to it.
 

3 more replies
Answer Match 45.36%

I am using Windows XP with SP3. Prior to the profile being corrupted I've had multiple warnings that my C: drive is running out of space. I already have a 2nd drive and I'm trying to find out about getting a 3rd.

My user profile on my desktop has been corrupted. I found instructions on how to copy the data from the old user profile to a new one, however I cannot find the file the instructions are looking for.

The instructions say to copy from the old file into the new. The problem is I cannot find the correct file.

The profile names on the desktop are Christina (me), Scott (dh), and William (ds). As you can see from the screenshot of Windows Explorer, only Scott and William are listed as seperate folders. I believe the "Christina" setting are under "Compaq Owner", but I'm not sure.



I created a new user profile in Control Panel and named it "Mom". However, it does not show up in Windows Explorer as a named folder.

I took the screenshot while logged into my dh's user profile.

I need help finding out why the new user name doesn't appear in Windows Explorer and how I can verify if I have been using the Compaq Owner account as shown in the files. Then I need to find out how to properly copy the data from the corrupted profile.

Thank you,

Christina in GA

A:Corrupt User Profile, cannot copy data to new one

Welcome to TSF....

Try this:

How to recover the damaged user profile in Windows XP

http://support.microsoft.com/kb/555473/en-us

5 more replies
Answer Match 45.36%

Hello!
I would like to ask a favor from the specialists here : I need a VBA code that can copy some tables/ charts from a website. The website is bet365.com, and the tablesare placed in the section: Results (at the bottom of the page)> Search Criteria: (Sport: Virtual Soccer, Date: Last 48 hrs, Search by : Virtual Soccer). Then you click the button ?Get Results?. Then the website will display a list of the matches from the last 48 hrs. First of all, I need the code to open each match in a separate window and to copy a table from that page, and then to paste it in Excel. Secondly, if I repeat the action after 8hrs, for example, the site will show the matches from thelast 48hrs, and the code will have to check which is the last table I copied and to continue to paste from that point on, on the same sheet.In order to make things more clear,
Thank you in advance!
PS: In order to be able to access the section ?Results?, autentification is required, and I will provide the usename and password in private.
 

A:VBA code which copy data from a web page in excel

Is this legal?
Sounds dodgy?
 

6 more replies
Answer Match 45.36%

Hi
I have a Workbook(User) that contains data for the issues that have been resolved. Every week I need to pull out a copy (certain columns) of the data that meet a certain criteria and paste it into another workbook(Master) for manipulation.
For Instance I need to copy alll the rows that have "yes" as Feedback and paste it into another workbook.
I want Macro to be stored in one file only(Master). I need to report data on weekly basis and want a new file to be created each week.

I have attached the prototype of files that I am using.

Regards
Manjot
 

A:Copy data from one workbook to another which meets the criteria

Welcome to the board.

"Every week I need to pull out a copy (certain columns) of the data that meet a certain criteria and paste it into another workbook(Master) for manipulation. For Instance I need to copy alll the rows that have "yes" as Feedback and paste it into another workbook."

While it's possible that "manipulation" includes other actions you're not telling us about, including the Master book in the process at all appears to be complicating things unnecessarily.

With your User.xls active, you could just run this:

Sub test()
Sheets("Sheet1").Copy
x = Range("A" & Rows.Count).End(xlUp).Row
Range("N1") = "Check"
Range("N2:N" & x).FormulaR1C1 = "=IF(RC[-5]=""Yes"",""X"",0)"
Range("N:N").SpecialCells(xlCellTypeFormulas, 1).EntireRow.Delete
Range("N:N").Delete
End Sub

to get a new book with only the rows from User.xls where Feedback = "Yes". You could then save this new book with the date in the name.

"I want Macro to be stored in one file only(Master)."

Storing it in your personal macro workbook would be better. See "Record a macro" in Help.
 

1 more replies
Answer Match 45.36%

sorry if this is posted in the wrong place. not sure if i should be in the hardware or the software forum.

i am going to upgrade my os from win98se to either win2000 or win xp (pro or home - any suggestions on which is more appropriate?). i will probably also need to upgrade to a new larger hard drive (60-80 GB). i think i can just simply copy over the data files on my old hard drive over to the new drive.

what i am wondering is if there is some way i can just copy over all the applications installed on my previous old hard drive that was operating under the win98se os. i have quite a few applications and to have to re-install all the applications and reset all the preferences to my existing settings would probably take quite a bit of time. just trying to see if there is a shortcut to all those troubles.

tks.
 

A:copy data & applications from old hard drive

No.

All "applications" will have to be re-installed.

When an application is installed, all the registry keys are updated with the location of all the library files etc. To just copy over the applications will cause them to fail as
this information is unknown.

Also I would suggest XP Home, unless you are going to connect to a large corporate domain, or need to run a dual processor server, Home is adequate.
 

3 more replies
Answer Match 45.36%

What is better when moving large amounts of files and data (20+) to either copy or cut the files? Or does it not make a difference?

I was told cutting fragments your hard dive while copying does not.

I've only noticed that cutting is faster.

A:Is it better to Copy or Cut when moving large amounts of data?

If you Copy, you aren't moving anything. Cut will move it though. w7 will auto defrag your drive at any rate.

5 more replies
Answer Match 44.94%

Hello
Have a folder, call it DATA, containing subfolders DATA1, DATA2, etc. Each subfolder contains an Excel workbook.

Have a workbook with a macro that with a button click opens a code specified workbook/worksheet and copies a range of data to the first workbook, then closes the second workbook.

Now I want some way to select which one of the DATA# subfolders, and hence the workbook it contains, has data coppied from it.

Thanks
 

A:Macro to select subfolder to copy worksheet data from

6 more replies
Answer Match 44.94%

Does The virus privacy danger copy it self when burning data onto cd/dvd ?

A:Does The Virus Privacy Danger Copy It Self When Burning Data Onto Cd/dvd ?

Try running Malwarebytes to get rid of it!

5 more replies
Answer Match 44.94%

Is it possible to save formatting such as column width, row height, fonts, etc...? If so, is it also possible to insert data from another excel file using the copy and paste method without losing the format?

Example: File 1 has the formatting I want to use but the data needs replacing. File 2 has the data I need but not the formatting. Is it possible to copy the data from File 2 and paste it into File 1 without losing the formatting from File 1?

Thanks for any help!
 

A:Excel - copy data to file with desired format?

6 more replies
Answer Match 44.94%

What would be the best way to find a specific Column Header, and copy the data found in the column until the column header is found again?
 

A:Solved: Excel Macro Copy Data From Columns

8 more replies
Answer Match 44.94%

I have an excel file that has a sheet with pipeline information on loans (sheet name is "Pipeline"); there is a unique identifier on column D (loan number) in that sheet. In that same excel file but a different sheet called "Projections" that same unique identifier (loan number) is on column "D", there are 4 other columns with data that I would like to copy over to the Pipeline sheet from the Projections sheet based on the loan number match.I would like the macro to match the loan # on column D (range is D2:D600) from Pipeline sheet to column D in Projection sheet (same range) and if found I would like to copy the contents of columns I, J, K and L from the Projections sheet to the same columns in the Pipeline sheet for each loan number that matches.I honestly don't know where to start, I usually use the macro recorder and tweak from there but the macro recorder doesn't really help you create the logic, can anyone help me?

A:Macro to copy data from one sheet to another based on match

Why don't you just use VLOOKUP?The basic formula for Pipeline!I2 would be as follows. Drag this down as far as required.=VLOOKUP($D2,Projections!$D$2:$L$600,6,0)For Pipeline!J2 use =VLOOKUP($D2,Projections!$D$3:$L$600,7,0)To expand on this a bit, you could put this in Pipeline!I2 and drag it both down and across to Column L.=VLOOKUP($D2,Projections!$D$2:$L$600,COLUMN()-3,0)Finally, to eliminate the #N/A error that will occur if a value isn't found on the Projections sheet, put this in Pipeline!I2 and drag it down and across.=IFNA(VLOOKUP($D2,Projections!$D$2:$L$600,COLUMN()-3,0),"Not Found")Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

5 more replies
Answer Match 44.94%

I have two Western Digital 1Tb HD's which I use for archiving and are carbon copies of each other and my third installed OS HD. They are both external to my computer, in fact one came as part of a WD My Book.

Previously, I had my Asus P5Q Deluxe fitted and I could just plug the two HD's into the PSU with a spare power cable and connect them to the mobo with a couple of Sata cables and copy any data from the main installed HD or replicate data between them. No problem.

However, due to RAM issues, I have swapped the mobo out for my Asus P5W DH Deluxe. I just assumed I could go ahead with my adhoc method of plug and play HD connectivity but after shutting down my desktop, wiring in just one archive HD and powering up, the computer went a bit funny.
All the icons had shifted over to my TV display, next to my desktop, while my monitor's desktop pic got squashed vertically with vertical letterbox lines left and right, pretty much as though I had been messing with the AMD Catalyst Control Centre.

Any ideas why plugging in an HD (or two) into the spare Sata/EZ Raid sockets would cause this? Why didn't it behave like P5Q, e.g. plug & play style, or as if I had simply plugged in the HD via the USB?

One thing I forgot to check was if the HD showed up in 'My Computer' while the icons and what not were on the TV screen.

Tom.
 

A:Problem making adhoc HD connection to copy data

Nevermind. I plugged the two archive HD's into the mobo today and all is fine and copying perfectly.

Tom.
 

1 more replies
Answer Match 44.94%

Hi All,This is probably pretty easy but I cant seem to find what Im looking for on any other forums. I have a master sheet that I am keeping a list of names, personal information and a seperate colum for each skill set the individaul can perform. Basically what I want, is if there is a Yes in a particular colum for a specific skill set, it will copy all of their information onto a seperate sheet. If the cell is blank then no action needed. The other sheet will then create a new list of all the individuals with the same skill set but keep the master sheet as is. I also need this rule to work for each colum, and each colum to correspond to its own sheet. This means that for individuals with multiple skill sets, they will be listed on each sheet.Not sure if this makes any difference (and Im assuming it doesnt, but I am using a mac with office 2008)Hope that makes sense and that someone can help.Thanks in advance for your input.
 

A:Copy a row if data in cell matches and paste to new sheet

Taka a lokk at this post
http://forums.techguy.org/business-applications/959076-find-copy-paste-macro-excel.html
The macro will need to be editted but it does more or less anwser your needs
 

1 more replies
Answer Match 44.94%

I'm attempting to get some data off of this older system. It's a Win2k machine. I have tried two separate external hard drives, which I know work, and both times, when I try to copy 20GB of photos, after it starts copying for a while, it says it failed because there is not enough disk space. But there is plenty of disk space. One was a brand new 500GB drive, and the other had over 100GB available.

Ideas?
 

A:Attempted to copy data onto External; Says not enough space where there is plenty

Run Disk Check from explorer on both drives.
A corrupted file can report incorrect file size.

Also use SpaceMonger to locate hidden large files (its free, download.com)

Try coping parts at a time. I gather you have sub-directories anyway?

A single bad file can put a stop to a multi-GB transfer of files
 

3 more replies
Answer Match 44.94%

I am using Windows XP and am in the process of creating a data partition on my C-drive to make it easier to do backups. My question:For the backup of the data partition, is there an advantage in creating an image of the partition on an external hard drive as opposed to simply copying it?If I first do a disc-check just before restoring and some sectors are labeled as bad, then would restoring an image simply try to write data on to the bad sectors whereas restoring a copy of the files would presumably skip any bad sectors?Thanks,Thoughtful Skeptic

A:To backup data files, is it better to create an image or a copy?

First of all...it's better to create your image/backup/clone...to another drive.More drives lessens the chance that a single thing can ruin your day, shares the risk among at least two drives.Creating a data partition on the same drive affects chkdsk, defrag, running AV/malware scans, etc...these run quicker if C: partition is smaller...and it (somewhat) reduces the chances of total loss if a portion of the hard drive goes bad.In order to copy or clone a partition...you must use special software. Some of these programs will create partitions which are bootable, some will not...you need to read the specifics of the program before you ever install it and use it.Bad sectors recognized via chkdsk /r...are areas which are marked as unuseable and any data on such is moved to sectors which are useable. After chkdsk /r has completed, those sectors so marked...remained identified as unuseable. No data will be written to such.Louis

6 more replies
Answer Match 44.94%

Hi,

I'm looking to set up a macro to do the following:

Open up a workbook called Works Order Register
Find my Works Order on the register by matching the WOnumber (I8) and Contractor name (C1735) from Works Order workbook.
Once found copy various data e.g cell I1735, I1737 etc across to columns D, E etc on the register against the corresponding row found in the previous step.

I've got parts working ok, but not the whole thing together.

Thanks for help.
 

A:Excel Macro to lookup reference and copy data

12 more replies
Answer Match 44.94%

Hi Excel masters,I hope someone can help me with this:I need to get data from an online report (which can be exported as Spreadsheet) automatically filled in an excel sheet (in another template).The tricky part is that information in the online report can change with additional row/column for additional items purchased. How can I create additional row/column in my excel sheet and get all data to be filled in (copied) from that online report automatically whenever there is any additional items appear in that report?For example: In Online Report, there are following items:ShoesClothesGlassesBut in our Excel template, there are only these items:ShoesClothesHow do I automatically add a row in my Excel template for Glasses and other items that could be updated in the future? (i.e. whenever there is any additional information in the report downloaded online, that piece of information can be added in our excel template.Hope you can help me with this, pleaseee :)

More replies
Answer Match 44.94%

I have an Excel 2007 spreadsheet with 9,000+ entries. Column F contains text data (50-60 characters), which will include a 10 character serial number in the format "xxnnnnnnnn". The first two characters will always be alpha and the next eight will always be numeric.

I need to find each of these 10 character strings and copy them to column G of the same row. I do not want to do this manually if at all possible. Is there an excel formula that can do this type of function?

Your assistance is very much appreciated.

Mark
 

A:Solved: Excel - Find data, Copy to new cell

16 more replies
Answer Match 44.94%

Does anyone know the best way to copy records from one field in a table to another field in the same table? There are approx. 40,000 records that need to be copied.
 

A:Solved: Access Table: Copy Data from One Field To Another

16 more replies