Computer Support Forum

Solved: excel help if field is blank copy contents

Question: Solved: excel help if field is blank copy contents

Hi, I need help with a macro. I want to copy the contents of the cell above into the cell below if the cell below is blank.

A1 1234
B1
C1 5678
D1
E1 2345
F1
etc.

so it looks like this after the macro runs.

A1 1234
B1 1234
C1 5678
D1 5678
E1 2345
F1 2345
etc.

A1 is line 1 of column A. My apologies that I don't know how to copy an excel into my post.

Thanks in advance for your help.

Relevance 100%
Preferred Solution: Solved: excel help if field is blank copy contents

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Solved: excel help if field is blank copy contents

Hi

Is a macro absolutely necessary? This can be done by using a blank column and, starting in row 2 enter this formula

=IF(A2="",A1,A2)

Copy this to the end of your list then copy the new column and PasteSpecial/Values to column A.

A few extra steps than a Macro but much easier to maintain. If you really need a macro let me know and we can whip something up.

2 more replies
Relevance 89.38%

I am working on a database that stores genus, species, and variety I want to sort the data with genus, then species, then variety.

Now the tricky part. Sometimes there is no species. When this is the case, I want the database to sort that record off of variety.

I have though of a way to do this, but need help with the code.

If I make a species2 field, I could create an expression that would look at the species field. If the species field is empty, it could copy the data from variety. If it is not empty, then copy the data in the species field.

Once the species2 field has the updated data, I could then do a sort

genus, species2, variety

The report would have genus, species and variety showing and species2 would be checked off to not show in the report.

I am using Microsoft Access 2000.

Any help would greatly be appreciated.
 

Answer:Access - if field is blank, copy field A, if not copy field B

You should not actually need another field to do this, just another column in your report's Query. Something like this as a Field header :-

dummySpecies: iif(isnull([species]), [genus], [species])

this should provide a column with the species in if it there and the genus if it is not, which you can use in place of your actual species field in the report for sorting.
 

1 more replies
Relevance 75.44%

Hi folks,I've simplified this problem to the basics.I have a user form in Excel, (2000). It displays some text in a textboxI want to copy the contents, (to the Windows clipboard), of the textbox using a button.The textbox is called txtTIP and I have the following code with the Click event of the button;txtTIP.CopyThis doesn't seem to work, unless I have previously selected the contents of the textbox. I can't seem to work out how to do this in VBA.Can anyone advise?Thanks in advance.Regards,Simsy

Answer:Copy textbox contents with Excel VBA?

txtTIP.Select txtTIP.Copyshould work.

10 more replies
Relevance 75.03%

If I can describe my problem.

I have a table containing 2 columns one has the contents a-f and the second has a text content relevant to that letter i.e. A=large flange over centre line. tblVariant

A second table lists the products along with their variant letter. tblProduct.

I have created a form based on tblProduct and I want the text box to have a popup window that displays the relevant text for the contents of that box when the mouse hovers over it?

Is it possible?
 

More replies
Relevance 73.8%

Hi ,

I have the code for triggering an outlook email, if i click on a button . I have attached the code for this in the bottom of this message . I would like to add one more functionality for this code . I want to copy several columns in the excel file and paste it in the email body . The excel file is attached for your reference. I would like to know , how to copy the contents of the excel worksheet and paste it in email body. please help.
Sub GenerateEmail()
Dim olApp As Object, olMail As Object
Dim ws As Worksheet
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
End If
Set olMail = olApp.CreateItem(0)
olMail.To = "[email protected]"
olMail.Cc = "[email protected]"
olMail.Subject = "Macro for mailing"
olMail.Body = "Test Macro" & vbCrLf & vbCrLf & "See our double space?"
'olMail.Attachments.Add strFullPathNameHere
olMail.Display

End Sub
 

Answer:How to copy the contents of excel and paste it to email body ?

6 more replies
Relevance 72.98%

Hi all,

Cell A1 has value One
Cell B1 has value Two
Cell C1 has value Three

My requirement is to compare the contents of Cell A with Cell B and blank out contents of Cell C if contents of A <> contents of B.

I have written the formula like this:
=If(A1=B1,"",C1="") This assigns a value of True or False to cell C1 based on the values of A1 and B1.

I have also used
=If(A1=B1,"",C1=" ") The same result.

I need to blank out the contents of cell C1 completely without using any macros.
 

Answer:Making the contents of a cell blank in excel without macros

If you want C1 EMPTY then this is an impossible task. It needs macros.

If you merely want it to look empty then it's as simple as putting =If(A1=B1, X ,"") where X is the contents you want in C1 when the two are equal.
Or you could leave the original contents in the cell, and add conditional formatting to C1 whiting out the cell if the two are equal.
 

2 more replies
Relevance 66.83%

I have an access 2007 database that has fields for several addresses. I would like to have access skip subsequent address fields if the previous field is blank. I have done this before but for the life of me cannot remember how it was done. Thanks.
 

More replies
Relevance 66.42%

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.
 

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

16 more replies
Relevance 65.19%

My HDD is failing, so I'm trying to transfer all contents of this drive to a new one. I backed everything up with Windows Image Backup. The problem is that when I boot into Windows Setup, go into Repair options, it won't let me unload image into my new HDD. It always makes the C drive (my current failing master drive) the destination and won't let me change it. I went through the entire process one time, only to realize all I had accomplished was deleting everything, and then copying everything, to the same drive.

I then tried copying the image to an external HDD, and removed my internal master drive, only to find that I could not go through with the process at all.

Do you have to go through a normal install of Win7 to the new drive, and then boot back into Setup (via the optical drive) after that is done, and go into the repair options/Windows Image backup to restore your desktop and all of its content to the way it was on your previous HDD? Is that the step I am missing?

Hope I am making sense.

Answer:[SOLVED] Trouble with Windows Image Backup (cannot copy my OS and all contents to a n

Hi Southtown84 and Welcome to TSF,

Whenever I do this operation, I always reinstall Windows completely to the new drive. Then go into Control panel > Recovery > Advanced recovery, and simply choose to install from a new image then and there.

I would recommend you to do the same. So just save the image file to a CD/DVD or any external media, then reinstall your computer, and use the method mentioned above when windows is properly installed on the new HDD.

5 more replies
Relevance 64.37%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
12/12/2011
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance
 

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like

=MAX(LEN(TEXT(A2:A470000,"m/d/yyyy")))

exit celll with ctrl, shift, enter
 

1 more replies
Relevance 63.96%

I'm wondering if there's a simple setting I'm missing somewhere that returns the blank space in the name field of a window when in Detail view to blank space instead of the extension of the file name on the same plane that I click on.

I'm looking to be able to quickly change the focus from the folder structure in the left navigation pane to the name field and scroll instead of selecting any file and without having to go all the way to the far right of the window to drag the slider down to reveal the target files. I also want the blank space to work as such so I can drag-select 2-4 consecutive files in the list and quickly open them. I kind of have that part working with the checkbox viewstyle but its still too "sticky" and will sometimes only grab the first file I start on anyway.

My thanks to anyone who can ease my annoyance with Vista if but for a night.
 

Answer:Solved: How to make blank space in the name field blank space?

16 more replies
Relevance 63.55%

I have an excel file with a column with values like 100, 200, 500, 500-02, and 500-04.
Access wants the column to be a number because 500-02 is not one of the first records.

If I use the acImport or acLink I get the same results. Which is an error importing (I get all the data just not the text values in the column) or a null value in the link when view from Access (even though you can open the spreadsheet with excel and see the true data). If I use the import Wizard and change the Field to text it that data is fine.

I also tried acImporting to an existing table with the field set a text but it changes it back to numeric and screws up.

I have a vision impared user and I need a button click to get this data into access.

Thanks for reading my post.
 

Answer:Solved: ACESS: import excel field as text

7 more replies
Relevance 62.73%

I have been asked to print 300 address labels from an Excel document, I was going to do a mail merge from Word but the originator has entered the addresses all in one cell per record. There are no commas separating the elements, only spaces. Is there an easy way to split this out so that I end up with Add1, Add2, postcode etc all in their own columns?
 

Answer:Solved: Excel problem - splitting the contents of cells

Look at the "Text to Columns" feature in Excel. You should be able to use this and split the data using a space as the delimiter. If this doesn't work for you please post a sample workbook so we can see what we are dealing with.

Regards,
Rollin
 

2 more replies
Relevance 62.73%

Hi all

Is there a way (using functions/formulas) to have Excel automatically duplicate the contents of a row on one sheet onto another sheet within the same workbook if text in one column of the first sheet contains a certain word? And if so, how could this be achieved?

I have attached an example workbook to help explain what I'm trying to achieve.

What I want to end up with is when I type text in any row of the Master sheet, I would like the entire contents of each row to automatically be repeated on the worksheet of the same name (as per column O). For example row 5's contents from the Master sheet would duplicate into the sheet named Accommodation. In addition, should the details ever change in the Master, this would need to be reflected in the individual sheets also. My only concern is that I'd like the individual sheets to fill from the top rather than match the exact row number position from the Master, ie row 5's contents to be placed into row 2 of the Accommodation sheet seeing as it's the first occurrence, and row 6's would go into row 3 etc.

I hope that all makes sense, please let me know if not.

I'd be hugely grateful for any suggestions & help. Thanks heaps.

Sue
 

Answer:Solved: Excel: Auto duplicate row contents from 1 sheet to another if col contains a

11 more replies
Relevance 62.32%

Hello,
I have a conundrum and I hope somebody out there can understand what I am talking about. I have a spreadsheet I am developing where the first worksheet is a table of contents and summary, and I have over twenty worksheets that all contain data for different items.

I would like to be able to click on a cell within my table of contents worksheet and have the relevant worksheet open so I don't have to keep scrolling through endless sheets. I have to log a bunch of defective items and keep notes & tallies on them so if there was such a function as this it would really help me out! (I really don't want to have to do this on Word) My searches on Excel's help page have all been in vain - seems like nobody has ever asked this question (or nobody has in a way that I understand). As you can probably tell, I don't know a whole lot of technical jargon. I am a beginner at this, so please keep it simple! Thank you!!!!!
 

Answer:Solved: how to link an excel worksheet to a tabel of contents page?

CTRL+K is the hotkey combo for "Insert Hyperlink".

Then choose "Place in this document"; from there, it's self-explanatory.

Welcome to the board.
 

3 more replies
Relevance 62.32%

Excel Marco Dropdown Menu Cell Contents I have an excel workbook with a "INPUT" WkSht, and a "ACTIVE" WkSht.
INPUT has a dropdown menu that looks up a list in ACTIVE, locates a desired value, and displays several cells contents in ACTIVE, - in the INPUT page.
This is working.

Question 1:
One cell in ACTIVE contains "comments" - how do I display the comments in the cell from ACTIVE, in a cell in INPUT - so I can look at all of them.

Question 2:
How do I update the contents of a cell in ACTIVE, at the same location that was selected from the dropdown.

I am a beginner - please help.

See present MACRO below...

Sub UpdateLogWorksheet()

Dim historyWks As Worksheet
Dim inputWks As Worksheet

Dim nextRow As Long
Dim oCol As Long

Dim myRng As Range
Dim myCopy As String
Dim myCopy2 As String
Dim myCell As Range

'cells to copy from Input sheet - some contain formulas
myCopy = "D5,D6,I18,D20,D19,D8,D10"
myCopy2 = "D5,D6,D7,D8,D9,D10"
Set inputWks = Worksheets("Input")
Set historyWks = Worksheets("Payments")

With historyWks
nextRow = .Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0).Row
End With

With inputWks
Set myRng = .Range(myCopy)

If Application.CountA(myRng) <> myRng.Cells.Count Then
MsgBox "Please fill in all the cells!"
Exit Sub
End If
End With

With historyWks
With .Cells(nextRow, "A")
.Value = Now
.NumberFormat = "mm/dd/yy"
End With
.Cells(nextRow, &q... Read more

Answer:Solved: Excel Macro Dropdown Menu Cell Contents

16 more replies
Relevance 62.32%

Hello,

Can you please kindly help me to solve the below interesting issue? (I will make my best to make myself understood, which is sometimes very difficult)

I need to see DIRECTLY in Windows Explorer (I use Win Xp) what is contained in the cell A1 on Worksheet1 of an Exel file (most often, the contents of the cell is a date in special Excel date format = yyyy-mm-dd, but sometimes the contents is a text). The purpose of all this is to sort Excel files (according to the contents A1 of the particular file) directly in Windows Explorer without the need for opening the files.

I hope that this could be realizable by transferring the contents of the cell into one of the standard Excel file properties that can be seen in )Windows Explorer) Details View (eg. Description, Subject or any other property) every time on saving the Excel file.

In addition:
- If the contents of the cell is "preserve", the Excel file property should be left as it was before I opened the file.
- If the contents of the cell is "delete", the Excel file property should be (strange to read)deleted.
-----------
EXAMPLE:
On saving the Exel file, whose cell A1 in Worksheet1 contains „2012-01-05“, this date should go into the Excel file property Description.
- However, if the contents of the cell is „shall be done later“ then „shall be done later“ should go into the property. If the contents is „preserve“, the property should be left as is. If the contents is „delete“, the property... Read more

Answer:Solved: Transfer of cell contents into an Excel file property

You marked this as solved so does that mean you got this sorted? If so could you post your solution so others may benefit from it?

Rollin
 

3 more replies
Relevance 62.32%

I'm sure this will be a simple question for all you Excel guru's out there and novices alike.

I was asked by a colleague why their spreadsheet loses the formulas when the cells contents' are cleared. My limited Excel experience has led me to believe there is a way to stop this as a default. Is that right?

In other words; I need to be able to clear a cell's contents, for editing purposes, without having to reinput the formula!

I'd appreciate your help guys

SliderSteve

#Using Microsoft Excel 2003#
 

Answer:Solved: Excel: Clearing a cells contents without the underlying formula

Hi Steve,

You can select certain cell types. They are part of the Special Cells collection. In this collection, you have certain constants, i.e. numerics, texts, etc. You also can select logical and error cells. To see this, hit F5 and click Special. If you do not want to clear formulas, you can use the Constants option. In VBA, this would look like ...
Code:
SpecialCells(xlCellTypeConstants, 23)
Hope this is what you're looking for. If not, please post back.
 

3 more replies
Relevance 62.32%

I've upgraded from Excel 2000 to 2007 and cannot get the pivot table field list to show. I activate the pivot table and switch it from hide/show either by right clicking or from the toolbar but still no joy. I''ve looked all over the spreadsheet to see if it hidden anywhere but cannot find it. Any suggestions? If it is hidden somewhere can I move it via vba code?
 

Answer:Solved: Excel 2007 Pivot Table Field List Missing

16 more replies
Relevance 62.32%

I wish to know if it is possible to update a field on one sheet with the last entry of another sheets column?

as info is added to one sheets column the data on the other sheet is automaticall altered to show the last entry in the first sheets column where i entered the data in the first place
 

Answer:Solved: EXCEL: update field on one sheet with the last entry of another sheets column

16 more replies
Relevance 62.32%

How does one create a mail merge document that will print only certain paragraphs or sentences based on data in each record? For example, a mail merge document where you wanted the first paragraph to be one thing if [fieldx] is "yes" and something else entirely if [fieldx] is "no"?
 

Answer:Word: Mailmerge Letter Contents Based on Field Value

Check here, Don:

http://www.mvps.org/word/FAQs/MailMerge/MMergeIfFields.htm
 

3 more replies
Relevance 61.5%

sorry about that title, not sure how else to summarize it...

here's what I'm looking for - if it's even possible?

if I have a formula in a cell - IF(A1:A20>0,1,0)
how do I get the value that's greater than 0, rather than a 1 for true? in other words, I don't want a 1, I want the actual number/value (from a1-a20) that made the IF true?

thanks!
Ron
 

Answer:Solved: excel - how to retrieve contents of a cell found in a range in a formula

8 more replies
Relevance 61.5%

Excel question:

Testing - I have a column of numbers where I do a countif (A10:A365,A1)
In this case A1 = "1" and the column contains various number from 1-10.
I want to count the number of times 1 appears in the column up to row 100

I want to substitute "A365" with a value from cell "A2" ie, A2 = 100 and make it A100
So I'd like the countif logic to be countif(A10:A100, A1)

Then if I change A2 to 150 I get the range from A10:A150.

My issue is this range is used in a number of different caluclations and I'd like to dynamically change the rows to search.

Any help/direction appreciated.
 

Answer:Solved: Excel - reference a value (contents of cell) for use in dynamic part of range

Try this in place of your original COUNTIF:

=COUNTIF(INDIRECT("A10:A"&A2),A1)

(the section "A10:A"&A2 builds a literal string that "responds to" A2 value ; then you just throw in INDIRECT to make it work "for real")

Rgds,
Andy

EDIT: you may prefer a different approach:

=COUNTIF(var_Range,A1)

, where the defined name var_Range refers to:

=OFFSET(Sheet1!$A$10,0,0,Sheet1!$A$2-9,1)

You can test the dynamic range "effect" by entering 12 in A2, pressing F5, typing var_Range and pressing Enter. Then repeat with 15 in A2. Etc., etc.
 

3 more replies
Relevance 61.09%

Under the title of the portion of the worksheet that I am working with, I want to use text to describe the worksheet that is to follow. I don't want a box that refers to one cell. I want to write continuously, the whole width between the margins of the page, on multiple lines if necessary, just like I was in a text document. I have tried every way I can think of, but can't get it to do what I want - something like how a title works, but without the centering. I want this space to be independent of the rows and columns that are set up in the worksheet. I know there is alt-enter, and I've tried wrap-around. I am hoping that this can be accomplished without importing to or from Word.
 

Answer:Solved: Windows xp, MS Office 2003, Excel. Using text to describe contents of worksh

10 more replies
Relevance 60.68%

I can't be the only person who's noticed this difference, but I've searched everywhere and can't find anything on this... perhaps I'm just using the wrong words. Anyway...

Lets say I have a word document named "Messager Manual" that i want to open.

Windows 7 scenario: with Word 2007 open, I click the home button and click Open. I browse to the location of my documents, and I type "messager" into the File Name field. I'm met with an error window which says...
Windows XP scenario: with Word 2007, I click the home button and click Open. I browse to the location of my documents, and i type "messager" into the File Name field. The entire contents of the folder are searched and then filtered down to only contain all file names which contain what is placed in the File Name field.

Does anyone know why they changed this functionality and if there's a place to edit these settings?

I do realize that I could use the new file explorer to accomplish this, but it seems silly to me that they would add in this functionality in one area, only to remove it from another.

Thanks,

Chocko

Answer:Open dialog box settings? File Name field no longer filters contents

This function did not change from Office 2007 to Office 2010 for XP, Vista and Win 7.
It is the same - it searches folder and gives files with such word in names.

I just double-checked with Office 2010 in Win 7, Office 2007 in XP and Office 2007 in Vista.

The above mentioned window appears only when you start typing part of a file name and click ENTER (which in this window is linked to button Open)

Screenshot from Win 7 attached.

5 more replies
Relevance 59.04%

Hi Everyone
I know how brilliant you all are at answering my questions! I have an Acer laptop running Windows 7 and want to copy a DVD I made from recorded programmes on my TV (through my DVD player) on to a blank disc (ie make a 2nd copy). Can I do this using Windows Media Centre? I also have Cyberlink Power DVD8 which came with the laptop but this seems only capable of playing DVDs and not copying them. I tried downloading some freebie software but it converts the files to MOV or AVI etc and I just want a straight copy. I can do CDs on my PC with Sonic RecordNow but I don't have a DVD writer on the PC. Do I have to buy dedicated software to put on my laptop (which has a DVD writer) for DVD copying?
I know I can use the DVD player to do another disc but it was so laborious to make the first one I don't want to go all through that again unless I have to.
Cheers! Technomum
 

Answer:Solved: copy dvd to blank dvd

11 more replies
Relevance 58.63%

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.
 

Answer:Solved: Access Auto-Populate a Field using a field from another table

15 more replies
Relevance 56.17%

I have an ecommerce store, we imported data from one platform to another and had to combine multiple fields from the old into the new platform. In doing that, we gained data but lost a tab function that allowed you to simply click on specs to see them.
Here is what I am trying to do:

I have exported all of the products:
in the product description field it lists multiple areas of information, ie company information, sku, upc, specs, features.

I want to run a macro that says look in cell c1, find the word specs and copy everything from the (s) to the word features which is in every product and that cell.

paste that smidgit of text in a different column.

then I can import this sheet back into the system and then have the individually made tab also show specs when clicked on.

The data cell is the product description the specs are there adn they need to copy to the product warranty tab cell and be able to copy this macro or formula down for 8000 products for a global change
 

Answer:Solved: Excel find and copy

14 more replies
Relevance 56.17%

Hi All,

I want to have a button that copies cells B5, D5, F5, H5, J5, L5 from worksheet "Input" into a table in the next page starting in row 2 and adding the entries into the next row continually on worksheet "Trial", based on if there is a value in the B column. I'm pretty new to VBA and I've been playing around with some different suggestions but just can't get the hang of if it.

Can anyone help????
 

Answer:Solved: Copy cells VBA Excel

You are talking about a list or just row 5.
What is your excel version?
Pls upload a file with sample data.
 

1 more replies
Relevance 56.17%

I want to enter a row of data (17 cells) on one (detail) sheet and then if a conditional being true, auto copy that row of data to another (summary) sheet.
Currently I enter new data manually on my detail sheets and then reenter or manually copy the data to my summary sheet. Once the data expires, I want to keep it on the detail sheet, but no longer on the summary sheet. So I have to manually delete it from the summary sheet.

Bonus question: Since I have multiple detail sheets, is there a way to vary the size of the target area on the summary sheet where the rows would be copied? The target area is in the middle of a summary page and it would be cool to not size the target for worst case "true" results.

Thanks!
 

Answer:Solved: Excel conditional copy

7 more replies
Relevance 56.17%

I have thousands of cells I need to copy.

If I copy inside of the function box, it copies correctly as such:

Code:
else if(strstr($_SERVER['REQUEST_URI'], "catid=2569&"))
{
But if I copy while the cell(s) is highlighted, it copies incorrectly as such:

Code:
"else if(strstr($_SERVER['REQUEST_URI'], ""catid=2569&""))
{"

I need to copy thousands of cells, and if I select them all and copy, it gives me the wrong code (too many quotes). What can I do?
 

Answer:Solved: Excel: Copy cells exactly?

14 more replies
Relevance 56.17%

I am trying to come up with a macro that once executed will go to a defined name, insert a row, copy what is in row one and then paste the copy in the row that was just inserted.
 

Answer:Solved: excel macro copy

7 more replies
Relevance 56.17%

I know it will sound completely naive as a question but I seem to have done something wrong.

I want to copy the values of a row to the one exactly below it (for an enormously huge list of data), i.e.

A B
1 aaaaaa bbbbbb
2
3 ccccccc dddddd
4
should become

A B
1 aaaaaa bbbbbb
2 aaaaaa bbbbbb
3 ccccccc dddddd
4 ccccccc dddddd
I wrote (I'm totally new at this)


Sub Copy_Rows()

'Select last row in worksheet.
Selection.End(xlDown).Select

Do Until ActiveCell.Row = 1
'Copy the selected row
Selection.Copy
'Move down one row
ActiveCell.Offset(1, 0).Select
Selection.Paste
'Move up two rows
ActiveCell.Offset(-3, 0).Select
Loop

End Sub
but it doesn't seem to work. What am I missing?

Thanks
 

Answer:Solved: Excel/copy rows

15 more replies
Relevance 56.17%

ok, I'm selling my 40Gb 2MB cache maxtor to a mate and replacing it with an 80Gb with 8Mb cache of same manufacture.

I've recently reinstalled XP so don't want to do a full install on the new disk, I just want to copy the files over to the similarly partitioned 80Gb.

40Gb was originally split into C: 5Gb (for system and windows) and D: 35GB (apps and data).
I want the 80Gb to have similar partitions for windows and apps but the extra 3rd 40Gb partition for my accumulating data.

I only need to copy C and D initially and then root out all documents and data from newD to newE right?

Some suggestions i've read of simply copying and pasting havent worked cos of files in use, even in safe mode. Most mirroring apps seem to need to work from floppy to get around this - I don't have a floppy drive...

are there any freeware windows apps for this or easy DOS steps or workarounds for "files in use"?

any suggestions which don't require paying for stuff or using a floppy are welcome
 

Answer:copy old HD contents to new HD?

11 more replies
Relevance 55.76%

When I try to forward or reply to an email, my from field comes up blank and then the email will not deliver. It happens occasionally when I hit reply and very frequently when I try to forward. The server will not deliver it if there is no from.

Anyone seen this before?
 

More replies
Relevance 55.76%

Using Excel 2003 in Windows XP

I would like to use the contents of one cell as the destination location for copying data.
For example
I have 2 worksheets 1) Results and 2) info
in info
A1 = 'ABC'
C1 = 'Results!O54' < this is calculated based on other data in sheet.

Using a macro, I'd like to copy contents of A1 to cell location 'Results!O54' more specifically to where ever C1 points... C1 will change based on other data in info sheet.

The macro record for action looks like this (but I would like the 'O54' to be based on contents of C1 which changes)
Range("A1").Select
Selection.Copy
Sheets("Results").Select
Range("O54").Select
ActiveSheet.Paste
Sheets("info").Select

There is more to it then that but I think this is where I am stumped.
 

Answer:Solved: Excel: Uses contents of Cell to select a cell

Sheets("info").Range("A1").Copy Destination:=Sheets("Results").Range(Sheets("info").Range("C1").Value)
 

3 more replies
Relevance 55.76%

Hi,

I'm new to board and it's a pleasure to meet all of you. I have a small problem that I think some of you might be able to help me out. I don't know exactly if this could be done by formula but I would prefer it as such.

In the workbook provided, I have a list of names and their arrival and departure hours. I need to check the folowing:
• if the departure hour in cell C1 is bigger than 00:00
• if column B1 contains a time

If both are true then copy A1, B1 and C1 to E1, F1 AND G1. If not, then just use blank as a result.
Hope that I was clear enough and that it can be done with a formula.
Thanks for the support.
 

Answer:Solved: Excel formula search and copy

12 more replies
Relevance 55.76%

I need to move data from a second worksheet to the first. See attached example. The second worksheet will be changing weekly (the real data will be about 18000 records), so I'd like the formulas to be in place with minimum intervention. I need to pull the AgentSet off of the second worksheet (ServerDump) and put it in Customer Form (Type of Agent). I would like to say 'BaselineAgent' if it's true. I've tried different formulas and think I should be using vlookup but can't get it to work. Any suggestions or examples of coding I could use? Thanks!
 

Answer:Solved: Excel - Match and copy between two worksheets

12 more replies
Relevance 55.76%

Hi guys, Please I would like to extract only strings starting with C:\Documents and settings...... from the following data in excel worksheet. Any suggestions will be highly appreciated.

C:\Documents and Settings\Joy Okonkwo\thesis_projects\weka\src\main\java\weka\attributeSelection\GreedyStepwise.java(498) C:\Documents and Settings\Joy Okonkwo\thesis_projects\weka\src\main\java\weka\attributeSelection\GeneticSearch.java(703) StringBuffer FString = new StringBuffer(); boolean didPrint; if (m_starting == null) { return getStartSet(); for (int i = 0; i < m_starting.length; i++) { didPrint = false; if ((m_hasClass == false) ||
if (i == (m_starting.length - 1)) {
else {

return FString.toString(); public String toString() {
C:\Documents and Settings\Joy Okonkwo\thesis_projects\weka\src\main\java\weka\attributeSelection\InfoGainAttributeEval.java(22) C:\Documents and Settings\Joy Okonkwo\thesis_projects\weka\src\main\java\weka\attributeSelection\ChiSquaredAttributeEval.java(22) package weka.attributeSelection; import weka.core.Capabilities; import weka.core.ContingencyTables; import weka.core.Instance; import weka.core.Instances; import weka.core.Option; import weka.core.OptionHandler; import weka.core.RevisionUtils; import weka.core.Utils; import weka.core.Capabilities.Capability; import weka.filters.Filter; import weka.filters.supervised.attribute.Discretize; import weka.filters.unsupervised.attribute.NumericToBinary; import java.util.Enumeration; import java.util.Vect... Read more

Answer:Solved: find and copy function in excel

16 more replies
Relevance 55.76%

Hi,

In Excel 2003, I am coping a tab with it's data into another tab.

I have attached an xls file, Main Tab (contains a form, I removed unnecessary data) and Copy Tab has a button that would copy the main tab (using vba code) into another tab.

I noticed the checkboxes id gets reassigned to a different checkboxes ids.
ie. main tab - checkbox id 1199, and after coping it changes to a diff id.

How do I make the checkboxes ids stay the same?. In my vba code I use the default (main tab) checkboxes ids to checkmark right checkbox.

I hope it makes sense what I am trying to accomplish.

Please advice,

Thank you
 

Answer:Solved: Excel 2003 copy tab Question

A workaround for this would be to rename the checkboxes in your code. In each of the copied sheets, they have been renamed to their defaults 'check box 3'
Code:
ActiveSheet.Shapes("Check Box 3").Name = "Check Box 1199"
HTH
 

3 more replies
Relevance 55.76%

I am trying to write some vba code to Copy the the contents from each row in excel and make it into a new text file. I need the 1st Row to be in each text file though. So the 1st loop would be A1 & A2 row copy next loop would be A1 & A3 copy. When i paste the values in the new sheet to be saved as the text file I need to transpose the paste so row 1 now will be in column A. The filename would be created from the value in Column A. I have uploaded some example files. Any help would be greatly appreciated. The bonus would be if i could get any empty spaces removed from the cells.

I tried modifying some code that Jimmy the Hand wrote linked here
http://forums.techguy.org/business-applications/951580-save-excel-each-row-html.html
with no luck.
 

Answer:Solved: Copy Columns from excel into new file

7 more replies
Relevance 55.76%

I have a bunch of Excel cells that are spread out across several columns.

Is there a quick way to "move" these cells so they are all in the same column, with different Rows instead?
 

Answer:Solved: copy/paste excel cells

9 more replies
Relevance 55.76%

Good morning. I consider myself a novice when it comes to Macros. I have written several simple macros using the macro recorder and VBA. My current dilemma is I have a template (worksheet #2) in which I wish to copy a range of rows several times within the same worksheet with a blank row between each copied range. The number of copies is dependent on the number of rows of data (cost centers)within worksheet #1.

I have seen some macro language that should accomplish the copy range, however, the next step is what throws me. For each copy of the template range, I'd like to insert the data (cost center) that comprises the rows on worksheet #1.

Essentially I want to create a copy of the template range for every cost center listed on worksheet #1. See the attached example.

Once the copies are made and the cost centers are inserted, my database will refresh the worksheet #2 and bring forth the data for each cost center. Macro language is not needed for the last step.

Thanks in advance for your assistance. Please let me know if the inquiry is not clear at any point.
 

Answer:Solved: Copy & Insert Macro - Excel

10 more replies
Relevance 55.76%

Hi

I'm really new to writing code and I'm trying to develop some stuff in Excel 2007.

I want to record a macro for a command button that when clicked, will copy the data from Cell A6, and past it with formatting and everything into whatever cell I selected.

I can get it to copy and paste, but only into a certain cell.

Help required!

Thanks

C
 

Answer:Solved: Excel Copy and Paste Macro

MacShand, welcome to the forum.

Try This:
Code:

Range("A6").Copy
ActiveCell.PasteSpecial Paste:=xlPasteAll
Application.CutCopyMode = False

What the code does is it copies the contents in cell A6 to whatever cell you have selected at the present time. So, make sure before you run the code the correct cell is selected or you may copy over needed data.
 

3 more replies
Relevance 55.76%

Hi,

I have an Excel worksheet with data in columns A-D. When scanning down the worksheet I note certain rows that need to be duplicated. I would like to have a macro that would, when activiated, insert a blank row below the identified row and copy the data from the identified row into the newly created blank row.

Currently using Office 2003.

Thanks in advance MBInDe
 

Answer:Solved: Excel Insert Copy Paste

is this part of the solution required for
http://forums.techguy.org/business-applications/868445-excel-data-sort.html
or a different issue
 

1 more replies
Relevance 55.76%

Hello,

I know nothing about programing an excel Macro but I need help createing a macro to do the following:

file 1
col a ffffcol b
1 ffffffffff48
2ffffffffff 26
3ffffffffff 53
4 ffffffffff8

File 2
col c fffffcol d
1
1
2
3
3
3
4

I want to fill the rows in col d in such a way that 1 coresdponds to 48 and so forth.

Also, the file has over 7000 rows of information so doing it by hand is not a viable option
 

Answer:Solved: Excel Copy paste macro

6 more replies
Relevance 55.76%

Hello,

I'm new to spreadsheets and would appreciate any help. I tried using the Macro recorder to do this task but it seems to only work for the cell that I recorded the macro on.

Here's what I'm trying to achieve.

I have text in colum A. I would like to find all instances of "BW" in column A and Copy the "BW" to the corresponding column B

Using the macro recorder only copies it in that one cell.

Thanks for the help.
 

Answer:Solved: Find and Copy text Excel

9 more replies
Relevance 55.76%

I got the below code from http://www.rondebruin.nl/copy6.htm site.

Is there anyway of modifying this code so it saves each work with a specified password?

This process is carried out every month and there are 2 lots of 242 (1 set of new account and 1 set of renewal account for loans) new workbooks created so takes an age to open them all and resave with a password.

Thanks in advance for any help.
Sub Copy_Every_Sheet_To_New_Workbook()
'Working in 97-2007
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim Sourcewb As Workbook
Dim Destwb As Workbook
Dim sh As Worksheet
Dim DateString As String
Dim FolderName As String

With Application
.ScreenUpdating = False
.EnableEvents = False
.Calculation = xlCalculationManual
End With

'Copy every sheet from the workbook with this macro
Set Sourcewb = ThisWorkbook

'Create new folder to save the new files in
DateString = Format(Now, "yyyy-mm-dd hh-mm-ss")
FolderName = Sourcewb.Path & "\" & Sourcewb.Name & " " & DateString
MkDir FolderName

'Copy every visible sheet to a new workbook
For Each sh In Sourcewb.Worksheets

'If the sheet is visible then copy it to a new workbook
If sh.Visible = -1 Then
sh.Copy

'Set Destwb to the new workbook
Set Destwb = ActiveWorkbook

'Determine the Excel version and file extension/format
With Destwb
If Val(Application.Version) < 12 Then
'You use Excel 97-2003
FileExtStr = ".xls": FileFormatNum = -4143... Read more

Answer:Solved: EXCEL - Copy Every Sheet To New Workbook

'Save the new workbook and close it
With Destwb
.SaveAs FolderName _
& "\" & Destwb.Sheets(1).Name & FileExtStr, _
FileFormat:=FileFormatNum, Password:="xyz"
.Close False
End With

Spent some time and worked it out - lol

Added in the bold section into the save section of the code.
 

1 more replies
Relevance 55.35%

Hi all

I'm sure that this one is very simple for you to figure out but I have spent hours on it and I can't figure out how to do it. Here is what I want to do.

If column N is blank then MsgBox("Please put ......")
ElseIf column N is not blank then Exit sub.

Thanks

Mario
 

Answer:Solved: Excel - If column N is blank then...

Here is one way
Code:

If Application.WorksheetFunction.CountA(Columns("N")) = 0 Then
MsgBox ("Please Enter Value in Column N")
Else
Exit Sub
End If

Here is another
Code:
If Application.WorksheetFunction.CountBlank(Columns("N")) = ActiveSheet.Rows.Count Then
MsgBox ("Please Enter Value in Column N")
Else
Exit Sub
End If
How about another???
Code:
If IsEmpty(Range("N1").Value) _
And IsEmpty(Range("N" & ActiveSheet.Rows.Count).Value) _
And Range("N1").End(xlDown).Row = ActiveSheet.Rows.Count Then
MsgBox ("Please Enter Value in Column N")
Else
Exit Sub
End If
Regards,
Rollin
 

2 more replies
Relevance 55.35%

Hi Im Very new to Ms Access. I am trying to build a simple database That list Client details for invoicing and installation address for service calls.
I have fields Listed as:
Client add1, Client add2, Client add3, Client add4, Client post. These fields i fill in manually
I then have a field that is a Yes or No field Labeled as copy Client to Installation
I have Fields Listed as:
Inst add1, Inst add2, Inst add3, Inst add4, Inst post.

I want to Manually fill in the Client Add fields and then if the Installation address is the same set the copy field to yes and have it copy the details from the relevent Client add fields to the matching Inst add fields.

If the Client address is different from the Installation address i want to set the copy feild to no and enter the installation details manually.

Any help greatfully received
 

Answer:MS Access 2007 Copy Field

Lyntonw, welcome to the forum.
Can I suggest an alternative strategy, as it is not normally a good idea to have duplicated data in a database.
Can I suggest you make your "copy" field in to a "Use Client Address" field?

If you want to continue with the "copy" version then you need VBA code to copy the Address data over the the Inst fields.
It tacks the format of
me.[Inst add1] = me.[Client add1]
me.[Inst add2] = me.[Client add2] etc
The field names have to be exact, including correct capitals where they are used.
 

1 more replies
Relevance 55.35%

I have 2 tables and need to copy all the values from one field of tblB to an existing field in tblA.

I am using the RunSQL command from within an Access Macro and have inserted this SQL Statement.

UPDATE tblA SET fieldA = fieldB from tblB

This syntax does not seem to be correct since I am getting error message:
"Syntax error (missing operator) in query expression 'fieldB from tblB'."

Can you please help.

THANKS
 

Answer:SQL statement to copy field from one table to another

try this:
select * into tblB from tblA

I hope these helps.
good luck.
 

2 more replies
Relevance 55.35%

I have a Vista system I am about to put Win 7 on but the HD is almost full. Deleting enough stuff to free up space for 7 is not an option so I will replace the current 200GB drive with 500GB drive.

So what is the best way/software to copy the full contents of the small drive to the new drive and have everything intact and running just the same on the new drive? Is there anything free that will do this?

Thanks,

Steve
 

Answer:Copy HD contents to another HD, what works best?

sundance2008 said:


Is there anything free that will do this?Click to expand...

Some manufacturers offer free oftware that will allow you to attach their drive as a slave and then clone the contents of the old drive to the new drive. Did your 500 GB drive come with any kind of utilities disk? If not, check out the manufacturer's web site to see if they offer downloads.
 

3 more replies
Relevance 55.35%

I have purchased a new 2TB external HDD. I want to backup my old one (also 2TB) by copying everything to the new one. It's about 1.6TB.

I assume a Copy/Paste transfer would not work (I always seem to encounter one error or another, when I try to Copy more than 40 or 50GB at a time). And I'd rather not babysit it for hours, copying chunk by chunk.

They're both NTFS by default, if that's important.

Answer:Copy all contents from external USB HDD to another?

When you say copy, do you mean the copy in the picture ?

8 more replies
Relevance 55.35%

I have a workbook with different sheets. I want to copy the contents of the cells C11 and B2 of every worksheet to a different workbook. Can somebody help me in doing this.

Answer:how can i copy the contents of 2 cells in eve

Are you looking for the syntax for a formula?='C:\Documents and Settings\user name\My Documents\[Book1.xls]Sheet1'!$C$11Replicate for each sheet.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 55.35%

Win 7 64-bit PC
I'm try to copy the contents (all files) of my D: partition to my E: partition
(These are separate drives with only one partition each).
All the programs I've tried so far only seem to want to copy the partition and create a new partition on the E:
All I want to do is copy contents, so trying to find software that can just copy contents.
 

Answer:Copy contents of one partition to another

My D: drive can no longer be accessed, had made a back of it 2 months ago, so only lost two months of not really important stuff.
if i want to try to copy the last two months of stuff?
Is there a program (non-windows)that might be able to access it?
 

2 more replies
Relevance 55.35%

this should be an easy one but I can't figure it out.

using windows explorer for my example -

I have a folder that has lots of sub folders in it.

I want to copy the names (text only) of the sub folders to a document but not the contents (files) of the sub folders.

how do I do this? when I try to a copy it wants to copy name & contents.

any ideas?

Answer:copy text not contents

open a cmd shell in the top dir

dir /d > filename.txt

9 more replies
Relevance 55.35%

I'm going crazy| It's so simple & I sure I've done it before.I have two spreadsheets. One has one column headed "Title" and the other has several including one header "Title". I want to copy the single column to the corresponding column in the bigger spreadsheet.Easy - select single column, copy, go to second spreadsheet & paste but good old Excel says the receiving cells must be the same size as the cells to be pasted - there are over 400 lines. What am I doing wrong?

Answer:Copy contents of XL spreadsheet to another

Copy the cells that you want (not the entire column).On the second sheet click in a single cell at the top of the range where you want to paste, then paste.

2 more replies
Relevance 54.94%

Hi. I am trying to run a macro to copy items on 1 sheet and have it paste them on the 2nd and 3rd sheet. I am trying but can't quite seem to get the excel code to do what I want. I can't post a copy of it because I accidentally deleted it.

Can anyone help me?
 

Answer:Solved: Excel: Copy/Paste Macro Code Help

9 more replies
Relevance 54.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?
 

Answer:Solved: Excel Macro Copy Data From Columns

8 more replies
Relevance 54.94%

Hello all

I'm playing around with the idea of using the BeforeDoubleClick event to copy and paste the contents of cells. Is it possible to copy and paste two adjacent cells at the same time by double clicking on one of the cells? Here's the scenario:

Sheet 1
Column A contains item description
Column B contains price of item
I want to double click on any cell in column A, say, A10 and have the contents of A10 and B10 copied and pasted into columns A and B on sheet 2.

The data in columns A:B is constantly changing, with items being added or removed all the time. I don't want to have to keep amending the code to take into account fluctuations in the numbers of new lines.

At the moment I can get the contents of a single cell copied and pasted into the required place on sheet 2. Here's my code, which also highlights in red the cells on sheet 1 that have been copied:

[code starts]
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With ActiveCell
.Copy Sheets("Sheet2").Range("A65536").End(xlUp).Offset(1)
Cancel = True
Sheets("Sheet1").Activate
.Font.ColorIndex = 3
Range("A1").Select
End With
End Sub
[code ends]

Columns D:E and G:H on sheet 1 also contain similar data to columns A:B. Is it possible for me to apply the same double click principle to these columns but have the contents of the selected cells pasted into their respective columns in sheet 2, for example, double click on, say... Read more

Answer:Solved: Excel 2003: using BeforeDoubleClick to copy and paste

This works for me:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 1 Or Target.Column = 4 Or Target.Column = 7 Then
Cancel = True
Target.Resize(, 2).Copy Sheets("Sheet2").Range(Mid(Target.Address, 2, 1) & Rows.Count).End(xlUp).Offset(1)
Target.Resize(, 2).Font.ColorIndex = 3
Else
End If
End Sub
 

2 more replies
Relevance 54.94%

I have an annoying issue with Excel 2010

Have the following fields in Excel.
Week Num / Heads / Hours Worked / Total Hours Worked / 8 Hrs Worked Friday / 8 Hrs Worked Saturday

Worked Friday & Worked Saturday are checkboxes
I have first 3 rows manually configured to link checkbox to the cell its in.

Copy and pasting these checkboxes to the rest of the cells.
All checkboxes are still linked to the original cell. I removed the $ symbol in checkbox properties.
When I check Box at row 1, rows 1,4,7,11 ect.. get checked.

I'm wondering if anyone knows a faster way to update these checkboxes.
Or am I forced to update each checkbox manually.

I found very little about checkboxes in Excel on Google Search.

Thanks in advance.
 

Answer:Solved: Excel - Copy/Pasting Checkbox cells

I think you'll have to do it with a macro.
Do you have a sample file (attach it) with the checkboxes so I can take alook?
 

2 more replies
Relevance 54.94%

Hello Everyone.

I need a help with the VBA macro.

I have one excel file & a word file. I need the data in the excel sheet to copy in to the word document.

This is what i need,

1. When you open the excel file, it has two columns Units & Comments.
2. The data in the Unit column need to replace this "XXXXXXXXXXXXX" in the word document,
3. The data in the Comments column need to replace this "cccccccc" in the word document,
4. once the unit column & comments column data is copied in to the word document. I need the word document to be saved with the file name of "XXXXXXXXXXXXX".

As a end result, i would have each file for each row in the excel file.

Is this possible? Could someone help me with this thing?

Thank you so much for looking in to this,
 

Answer:Solved: Copy data from Excel to Word Document

10 more replies
Relevance 54.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
 

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

16 more replies
Relevance 54.94%

I need to create a macro in Excel that will look for a certain text within a column (Column A), Copy the data in another column (Column B), and paste the data in another column (Column C).

For Example....

Column A
ABC1
ABC1
ABC1
ABC1
ABC1
DEF2
DEF2
DEF2

Column B
1000
1500
78
562
235
89
456
258

So, I would like to copy all the data in Column B that correspond with "ABC1" in column A, and paste that data in Column C.
 

Answer:Solved: Excel Macro Search and Copy Rows

16 more replies
Relevance 54.94%

Greetings.

I have a pivot table that I'm trying to pull a sample from. It is 1800 rows, of which about 400 have data that I want to use for my sample selection. I'm trying to generate my sample randomly. I've hidden the empty rows. I tried to copy this into another file, but the hidden rows are included as well. Data sort doesn't work, or I can't get it to work.

Any ideas? I was hoping to just copy the data only rows into a new file and generate random numbers for my sample, using the row #s as my selection criteria.
 

Answer:Solved: Excel- copy and paste without hidden rows?

6 more replies
Relevance 54.94%

I have been reading up on creating log files with Excel Macros.

I am trying to figure out if it is possible to have a Macro output the contents of the currently selected Cell to a text file?
 

Answer:Solved: Excel Macro Copy Cell to log file.

16 more replies
Relevance 54.94%

Hi

I currently have a worksheet called "Plan" where the user will enter text into "C34", once complete they will click on a form control button to email the spreadsheet.

I need help with code that would "copy" the text from "C34" to a worksheet named "Goal 1", position "C8" when the user clicks the form control button.

Any help would be greatly appreciated.
 

Answer:Solved: Excel Copy text code help needed :-)

Decided to use a formula instead ;-)

=IF(sheet1!A1<>"",sheet1!A1,"")
 

1 more replies
Relevance 54.94%

I have a macro that I have used for a very long time with no issues. It appears to be something with the number of records. I use it to copy and paste from one worksheet to the bottom of the other. I used it with no problem yesterday when I had 31896 records but with 31982 records today, it errors out with copy and paste are not the same size and shape.

code
Dim UsedRng As Range
Dim FirstRow As Long, LastRow As Long, FirstCol As Long, LastCol As Long
Set UsedRng = ActiveSheet.UsedRange
FirstRow = 2
FirstCol = UsedRng(1).Column
LastRow = UsedRng(UsedRng.Cells.Count).Row - 2
LastCol = UsedRng(UsedRng.Cells.Count).Column
ActiveSheet.Range(Cells(FirstRow, FirstCol), _
Cells(LastRow, LastCol)).Select
ActiveSheet.Range(Cells(FirstRow, FirstCol), _
Cells(LastRow, LastCol)).Name = "END"
ActiveSheet.Range("END").Copy Destination:=Sheets("CANOPI - Link report").Range("A" & Rows.Count).End(xlUp)
\code
 

Answer:Solved: Excel VBA Copy & Paste no longer works

Well, I just tried it manually and it did the same thing. The only difference I can see is the number of records.
 

2 more replies
Relevance 54.94%

Hey all,

Here's my situation, any help is greatly appreciated:

I have a list of 13 items in one column. A couple of the cells will be hidden by the macro, but then what I need the macro to do is copy the first 10 unhidden items onto the clipboard.

What row(s) will be hidden will vary from week-to-week. If I were to simply have the macro copy a cell range, there would be a chance of it copying a hidden cell. I believe what I need is a way to have the macro do a count of how many unhidden cells it has selected, and stop when it reaches 10.

Forgive my ignorance but I am literally just picking up Visual Basic as of this week.

EDIT: Just to clarify, I have the hiding of the cells taken care of. I just need some help figuring how to copy the top 10 cells that aren't hidden.
EDIT 2: Found that I could delete the hidden cells. Worked perfectly.
 

More replies
Relevance 54.94%

I am creating a table where I want to flag if actions are overdue or complete by date and need a formula which will mark overdue if the action is late to be completed e.g.

cell A1 21/4/13
cell B2 22/5/13

My formula in cell C3 reads: =IF(A1>B2"On time","Overdue") which is working fine BUT if I have yet to input a date for C2, D2, E2 etc. it's still marking it as on time - is there a way it will read blank cells without entering an "On time" value. I've tried this but it doesn't work:

=IF(OR(B2=" ", " "),IF(A1>B2 "Ontime, "Overdue"))
and also;
=IF(A1>B2, "On time", "Overdue", " ")

Hope someone can help!
 

Answer:Solved: Excel - set zero value for blank cells in IF formula

Welcome to TSG Palmy, hope you find some help and provide others with help when you can.

Try this =IF(ISBLANK(B2),"Not Ready",IF(A1>B2,"Ontime", "Overdue"))
 

3 more replies
Relevance 54.94%

I have 2 PC's running XP and Office 2000, although the one I am having problems with is using Outlook 2003.

That PC also has my HP 6300 connected via USB and setup as a shared printer.

I ran office update and installed all updates, also ran the Office repair from the disc and the one on the Help menu.

So that is everything that I have done to try to resolve my problem.
The problem is that this PC prints a blank page when I print an Excel from an e-mail attachment, or saved from the e-mail. But not all the time??? If I send the spreadsheets to my other PC either by e-mail or to a shared folder the other PC can print it no problem.

So it is not something like the "print Area", the only other problem I see is it will pop up and say the office assistant can't be started and to run the repair option from the CD (which I've done).

Just wondering if anyone has had the same problem
 

Answer:Solved: Excel Attachments printing blank on one PC

Well ok, so I re-installed the printer drive and that appears to have worked. Still get the office assistant error though, I'll have to check that. I'll try turning it off as i don't need it anyways.
 

1 more replies
Relevance 54.94%

I've figured out this formula (with tons of help!) but the problem is that it is calculating blank cells as "0". Where a blank cell should get no calculation and a true zero would equal 22 in each IF statement. How can I fix that?
=IF(C5>-1,22-C5,0)+IF(C25>-1, 22-C25,0)+IF(C33>-1,22-C33,0)+IF(C43>-1,22-C43,0)+IF(C56>-1,22-C56,0)+IF(C61>-1,22-C61,0)
 

Answer:Solved: ignore blank cells in Excel

not elegant
does this help
=IF(AND(C5>-1,C5<>""),22-C5,0)+IF(AND(C25>-1,C25<>""), 22-C25,0)+IF(AND(C33>-1,C33<>""),22-C33,0)+IF(AND(C43>-1,C43<>""),22-C43,0)+IF(AND(C56>-1,C56<>""),22-C56,0)+IF(AND(C61>-1,C61<>""),22-C61,0)

you could also use isblank() - but thats just as long winded as the above
 

3 more replies
Relevance 54.94%

The formula:

='[Folder Worksheet.xlsx]QC!$E270

How would I make this cell read blank until something is put into QC!$E270?
 

Answer:Solved: Excel 2007 Help Cell Blank

=IF ( '[Folder Worksheet.xlsx]QC!$E270 ="", "" , '[Folder Worksheet.xlsx]QC!$E270)

I think you need
='Folder[Worksheet.xlsx]QC'!$E270
syntax
But the IF statement should work
 

3 more replies
Relevance 54.94%

I have a Dell desktop computer with a 3.8 ghz Pentium 4 processor.  All of my Hard Disk Drives are SATA type drives.  I have a 1TB HDD as my primary, and 250GB as a secondary hard disk installed on my computer.  On my Acer laptop, it came with a 160GB 2.5" HDD, split in half, 80GB on "C" and 80GB on "D".  To me that was an ineffective way to use the drive. In no time my C drive was crammed full, the D drive was less than 1/2 full and my laptop was beginning to have issues related to the full drive.  I did not know how to move the partition on the drive without losing all my data, so I bought a WD 500GB for a replacement. I went to Best Buy, and got a Thermaltake Black Widow Dual Hard Drive Docking Station, and hooked it up to my desktop computer. When I tried to use Windows System tools to clone the Acer drive onto the  WD 500GB replacement, I learned it would not make a true "clone" copy. So, I looked around and found that Norton Ghost would do what I needed to do. Upon further research  I read that I should get version 14, not 15; because 15 had issues copying SATA drives. So, now I have installed Norton Ghost V14 on my Dell desktop, have the docking station connected using USB, and the *censored* thing still will not copy onto the new drive.  *censored*.  Norton comes back with the error message that it  is unable to copy my drive because it has too many NTFS issues to deal with.  I h... Read more

Answer:Copy Contents of hdd to another hdd with Norton Ghost v14

You are not stupid, just inexperienced.Do not expect to make a true "clone" of a drive using and USB interface. The problem is tat the USB interface can not provide all of the blow level commands needed. No, I don't know why. I read that somewhere.The best way to copy all the data from a laptop drive is to put the drive in a desktop using and adapter that does a direct hardware conversion of the IDE PATA connections.Under $10 at Amazon and other major vendors. You need two to transfer from one laptop drive to another laptop drive.BTW, EASUS is every bit as useful as Norton for most  "clone" jobs. Still,  you should not have trouble with the adapter you are using. It is considered one of the best. Others report they work perfectly. Not like some of those cheap USB adapters you get on eBay.http://www.youtube.com/watch?v=mhLJ2OXYdL4This is a video of a happy user.

2 more replies
Relevance 54.94%

i have a 500 gb hdd .....but now i want to change in 1000 gb hdd .....so i want copy my 500gb hdd to 1000gb hdd very very fastly .............please help me........my gmail id -----edited by moderator: removed email addy to protect from spam

Answer:Fast copy contents of 500GB HDD to 1TB HDD

Hope you can solve it, good luck!

5 more replies
Relevance 54.94%

I have got two External HDs (HD_A and HD_B), I want to copy my work from HD_A to HD_B.(i.e if I have got 40 folders and 60 files on HD_A, I should be able to see 40 folders and 60 files on HD_B. I should be able to access (open , delete, modify) folders and files on HD_A as well HD_B).

Backup gives me one folder containing every thing. If I used backup, I will not able to access any file or folder on HD_B (which is I do not want this). I am looking access folders and files on HD_A as well on HD_B.

One week later I added another 10 folders and 13 files to HD_A.

How can I add these new folders and files to HD_B as well? (it is obvious I can added them manually, but it is not always easy to remember which folders or files are news ).

Therefore I am looking for a program to do that (not manually) for me, comparing between two HDs (my case HD_A and HD_B) and add the new folders and files to the one that it does not have (my case HD_B) them (only new folders and files)?

Note: Differential Backup is not the one I am looking for.

Answer:How to clone (copy) the contents from one HD to another (not backup)

What you need to do is sychronise.

9 more replies
Relevance 54.94%

HelloI have a win xp live cd. I would like to change something in this cd. The thing is I did an nrg image of this cd with nero and copied it into a hard disk. Then I converted this image into an iso file. After that, I extracted the iso file into a folder and added a new file in this folder by means of a windows explorer window. Then I used nero again to build a new data cd with the extracted content of the original cd that included the new file that I added. Why is the new cd non bootable? I hoped it would be bootable considering it was copied from a bootable one.Any idea?Thanks

Answer:copy & paste bootable cd's contents

coping does not place files in the correct locations. It takes boot files in the boot zone of the cd to boot. Nero has the option of making a bootable cd.

6 more replies
Relevance 54.94%

I'm looking for a program to copy contents of folders to clipboard to allow pasting to word or excel. Did once have Folder Scavenger but now not available to download. Any one know of similar stuff?

Answer:copy contents of folder to clipboard

click hereMaybe this will help.Cheers

2 more replies
Relevance 54.94%

copy contents from nokia mmc 256 to new 1gb card,tried it on card reader to copy direct to pc then to new card it comes up cant copy not enough space thats from the 256 card to 1 gb how can that be?have formated the new 1gb card.also from nokia pc suite to new card says not enough space...so how can a 256 card hold info but the 1gb card cant get it on help pleeeeeese running xp pro phone is nokia 6680 thanks

Answer:copy contents from nokia mmc 256 to new 1gb card

Can you MOVE (rather than copy) from one card to t'other?

10 more replies
Relevance 54.94%

How o I copy all of the excel files in the subdirectory on my G: drive to a subdirectory on my c: drive. I have Microsoft Excel 2007 and running Windows 7?

Answer:how do I copy contents of a windows 7 subdire

drag and drop usually works, so does copy paste...i hate computers!but cant help myself....

5 more replies
Relevance 54.94%

i have got A2 and e2 , if e2 is smith and red then a2 will also be red, if e2 is robb and green then a2 will also be green, not content nothing, just the cell color needs to be copied, i have written vba code for the drop down menu in E2 , with color codes and its perfectly ok, but i am stuck with this color copy.also when a2 is green in sheet 1 , c2:f2 of sheet 2 will also be green.can pls someone help me with that?...conditional formatting not goiung to help as i need five different colors and CF can only do 3, i am using mso 2003.cheersSENGUPTA

Answer:copy cell color not contents

This line will cause E2 to be filled with the same color as A2:Range("E2").Interior.ColorIndex = Range("A2").Interior.ColorIndex Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 54.53%

Hi everyone.

I'm using Word 2003 and I'm merging records from an Excel spreadsheet.

Does anyone know the field code that instructs Word to move to the next record if the next record is blank?

Any help would be appreciated.

Thank you.
 

Answer:Word field code for blank...

radar2ooo said:

Hi everyone.

I'm using Word 2003 and I'm merging records from an Excel spreadsheet.

Does anyone know the field code that instructs Word to move to the next record if the current record is blank?

Any help would be appreciated.

Thank you.Click to expand...

Anyone with any suggestions or recommendations?

Thank you.
 

1 more replies
Relevance 54.53%

Hi guys,

Something weird is happening. Some of my movie files (file type doesn't matter) became corrupted; when I play them in VLC they cause errors, they were just fine before and nothing has changed. I noticed in Explorer that these files have no Date Modified field, it's simply blank; I've never seen anything like that.

I did a chkdsk on the drive and see no errors. What could it be ?

Thanks.

Answer:Blank Date Modified Field ?

VLC should rebuild the Index, but that is a temporary fix. Depending on what format they are, there is "DIVFIX" and "Meteor MKV repair" you can try to run the faulty content through which of those is appropriate, you'll have to google it, cant remember the links.

3 more replies
Relevance 54.53%

Hi,

I have been working on a Macro in excel to take a specific criteria (cell B2, Sheet1) and search column A sheet3 for this criteria. If it is found paste that row (A-H) on sheet1 beginning at A:17. There is the possibility for 2+ rows of data with this specific criteria. I want to be able to type in cell B2 on sheet1 and have the macro lookup all rows on sheet3 and paste them beginning at A:17 on sheet1. Any help on this would be much appreciated.
 

Answer:Solved: Copy multiple rows in excel based on one criteria

9 more replies
Relevance 54.53%

Hi,

I have set conditional formatting to colour a cell if a corresponding cell is populated.
This works fine.
When I try and copy the formatting to other cells it does not use relative referencing but continues
to referene the first cell.
I have tried selecting the different 'copy' options to no avail.
can anybody explain what to do, please?
please see attached spreadsheet. I am using excel 2007.

Thank you..
 

Answer:Solved: Excel 2007 - conditional formatting copy to cells?!

Where you have

=NOT(ISBLANK($G$8))

remove the $

so it reads

=NOT(ISBLANK(G8))

press apply, press ok

and now when you drag this down it will work for all adjascent cells
 

3 more replies
Relevance 54.53%

Hi again

I don't know if this is possible or not but I'll lay it out there anyway. I have about 2000 Excel files in drive C:/Documents and Settings etc/. I have a workbook called WW Numbers.xls. I need to copy the file names only from C:\ drive into a workbook called WW Numbers.xls starting in Cell A2. For example, I have in drive C:\ the following files:

WW1.xls
WW2.xls
WW3.xls
.
.
.
WW2000.xls

In a workbook called WW Numbers I want only the file names WW1.xls, WW2.xls .....WW2000xls staring on Cell A2.

I don't want to type in all the 2000 file names so I'm wondering if there is a macro that can do that for me
 

Answer:Solved: Copy Excel file names from drive C to a workbook

You don't need a macro, you can use something like "FileList" http://www.jam-software.com/filelist/
You can generate a CSV with the file names in which can be opened in Excel, you might only need to insert a column to extract the file name from the full name and path
 

2 more replies
Relevance 54.53%

Hi,
I'm currently writing a macro, part of which necessitates a different fill colour being assigned to each cell in a range - from B28 to the last cell in column B where there is corresponding data in column C. This could potentially be up to 50 cells in any single worksheet (one month's Arrivals), so 50 different colours, but will more likely be somewhere between 15 and 30.

I found some code that randomly applies the fill colours, and modified it, as follows:

Dim r As Byte, g As Byte, b As Byte
Dim iRow As Integer, iCol As Integer
Dim iRows As Integer, iCols As Integer
Dim rng As Range, rngFill As Range
Dim strMsg As String
Dim iIcon As Integer, strTitle As String
Dim EOP as Integer

EOP = Cells(Rows.Count, "C").End(xlUp).Row

On Error GoTo ErrorHandler

iRows = EOP- 1
iCols = 0
Set rng = Range("B28")

For iCol = 0 To iCols
For iRow = 0 To iRows
r = WorksheetFunction.RandBetween(70, 255)
g = WorksheetFunction.RandBetween(70, 255)
b = WorksheetFunction.RandBetween(70, 255)
Set rngFill = rng.Offset(iRow, iCol)
With rngFill.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = RGB(r, g, b)
End With
Next iRow
Next iColClick to expand...

This works pretty well, but there's always the chance of 2 very similar colours appearing consecutively, which I could do with avoiding...

As mentioned these colours are for Arrivals. I also need to apply colours for Estimated Arrivals in column A. These should be lighter shades of their c... Read more

Answer:Solved: Excel VBA copy cell fill colours and modify

16 more replies
Relevance 54.53%

Just lately my installation of MS Excel 2010 (on windows Vista, service pack 2) will only copy the values in the cells thus making it impossible to copy formulas. I have tried repairing the installation, but no difference, then tried to uninstall and re install the whole MS office 2010, after which for some time this issue was not there, but has cropped up again. have not, to my knowledge, made any changes to the installation. Is there an option that might have been changed by mistake making this the default for copying cells?

Further when i select a cell(s) i want to copy, the flashing dotted line that should be around those cells is there for only a fraction of second and so is the text in the status bar saying " Go to destination and press ENTER" that comes just for a fraction of a second. When this happens, only values are copies not formulas or referances. Also during this period, if i use format painter, after clicking the format painter, when I move the cursor to the worksheet, the brush does not show, instead its the usual mouse icon and not format is copied to the destination cells.

Sometime when i restart the application, this issue is gone, and then the dotted line stays.. and everything is copied and formats are also painted, but restarting the application in middle of work is very funny ..

is there a setting triggered off ? or is there a fix available to this ? Been using the same installation for over 2years with no issue ..
 

Answer:Solved: Excel 2010 does not copy formulas only copies values

Have you gone to the Control Panel > Programs > Programs and Features > [select] Microsoft Office 2010 > then Change, and run the Repair Option?
 

3 more replies
Relevance 54.12%

Hello Macro Geniuses,

I am super new to VBA and I am sure this is a piece of cake. I need to create a button that copies that contents of say cell C3 and copies it to C4, if C4 is taken, I need it to find the next available cell.

Also, I have read in some of the other threads that access might be better but I don't have it so I would need it to be in excel.

Thanks in advance.
 

Answer:Solved: Excel Macro to Paste to blank cell

16 more replies
Relevance 54.12%

I have a range of data into which I need to insert a blank record wherever the value of a column changes, so that I can include totals for each data set in my worksheet. I have gotten to where I can copy the range to another sheet and sort it properly, but I can't compare each cell in a column to determine if a blank line should be inserted. I have attached the file for anyone who can help.

Thanks.

btw, this needs to be able to handle a variable number of records.
 

Answer:Solved: Inserting blank rows for totaling with Excel VBA

Hi, I don't do "proper" VBA. I couldn't get the way I'd normally do it to work in your file, so I copied Sheet1 out to a new file & added a new Sheet2. Then I used:

Sub Test()
Range("Sheet2!A:C").ClearContents
Range("Sheet1!A1").CurrentRegion.Copy Range("Sheet2!A1")
Range("Sheet2!A1").CurrentRegion.Sort Key1:=Range("Sheet2!B2"), Order1:=xlDescending, _
Key2:=Range("Sheet2!C2"), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom
For Each Cell In Sheets("Sheet2").Range("C3", Sheets("Sheet2").Range("C65536").End(xlUp))
If Cell <> Cell.Offset(-1, 0) Then
If Cell.Offset(-1, 0) <> "" Then
Cell.EntireRow.Insert
End If
End If
Next Cell
End Sub

In theory, this'll run from either sheet with no particular range selected.

HTH,
Andy
 

3 more replies
Relevance 54.12%

=IF(AND(H73>=(H9-H11),H74<=(H9+H10)),"OK","Not to Print")

Using the formula above, when all cells 9 thru 11 are blank, the formula is outputting OK as the solution. I would like the formula to output nothing in that situation and leave the cell blank. How do I achieve this?
Thanks in advance
 

Answer:Solved: Excel - need formula to leave cell blank

7 more replies