Free Microsoft Excel 2013 Quick Reference

[Solved] selecting items not next to each other

Hi Excel/Word forum,
I am working in Word 2000. Is there any way to select items that are not next to eachother? Say the first word in a sentence and the last word in a sentence?
I saw an article saying that you can do it in word 2002. Can you do it in Word 2000 some how?
Thanks for your time,

Post your answer or comment

comments powered by Disqus
I am trying to make a simple monthly budget calender. I want to be able to but 1 in one cell and have certain other cells count up in series for the dates in a certain order. they are not next to each other, so i cant grab the corner and drag. For instance if i put 1 in cell a1, then i want cell c1=2, e1=3, g1 =4 etc..... Thanks

Is there a way to take a bunch of cells that aren't next to each other and move them all to a different place?

Basically in column A I have a time or date in every third cell. I need to move every one of them one cell down and one cell right. Rather than right-click-copy-paste 3,000 times I'm hoping there's some way to take all of them and move them all down and right one cell. Is that possible?

This does not work as the cells are not next to one another. Can I name these cells "something" and make the copy paste work?
If yes how do I change this code?
Sub Macro1()


End Sub

I was wondering if it was possible to determine if for example.. 3347 or catt124 were in cells if you could extract those that have two values that are next to each other? Also if 1231 were in a cell I would not want that pulled, just those that had the same value next to each other.

If a column has the following for example.


I would like to know if you could use excel to extract those that values that are the same and are next to each other. So in my example I would want to know that row 1 and 3 have values that are the same AND are next to each other. Thanks.

I have a bunch of names with periods in different places all in a single column. Is there any way to filter the names to delete any that have 2 periods next to each other?

For example, if it was "" it would need to be deleted or at least flagged in a way to remove it.

I know there is conditional formatting and sorting options, but I'm not sure how to do this

How can I check in VBA if the userselection contains two different mergedareas next to each other?

I’m trying to find a way to Delete two cells in two columns next to each other on every other row but not the whole row, then shift the remaining cells up. Can anyone suggest some vba that will do this. I've found code to delete every other row, but I don't want to delete the whole row. Thanks for any help I can get.

I'm having a major blockage here, but then I'm an old man, so I need the
help every once in awhile. What is the sequence of menu commands to get 2
spreadsheets next to each other, but I need to manipulate them separately. I
need to cut and paste between them. Please let me know how to accomplish
that..............I'm using Win xp home and use Office 2003 Std

Dear All,

I have the following code on a very simple form:

Private Sub CommandButton1_Click()
    DataEntryForm1.increase (ValueEntryBox.Value)
    Range("VARVALUE").Value = "VALAUTUZE"
    Range("CARFUEL").Value = Range("CARFUEL").Value + ValueEntryBox.Value
End Sub

Private Sub UserForm_Activate()
    ValueEntryBox.Value = ""
The code should add up numbers
The problem is that it does the job well with integer numbers, but with decimal numbers it just keeps writing them next to each other instead of adding them

Could you please advise?
Many thanks in advance

Hello all,
I’ve been using a macro that someone on this site so graciously provided (sorry don’t remember who). It works great for combining cells that are adjacent to each but now I need add another that is not. For example, it currently combines cells P2, O2, N2, M2 together with a – in between. I Need it to combined P2, O2, N2, M2, and C2 and A2. All ending up in cell Q2 with a – between them.

    Const sSep As String = " - " ' change as desired
    Dim cell As Range 
    For Each cell In Intersect(Columns("Q"), ActiveSheet.UsedRange.EntireRow) 
        cell.Value = Cat(Range(cell.Offset(, -4), Cells(cell.Row, Columns.Count).End(xlToLeft)), sSep) 
    Next cell 
End Sub 
Function Cat(vInp As Variant, _ 
    Optional sSep As String = " - ", _ 
    Optional bCatEmpty As Boolean = False) As String 
     ' Catenates the elements of vInp separated by sSep
     ' Empty values and null strings are ignored unless bCatEmpty is True
    Dim vItem       As Variant 
    Dim sItem       As String 
    If bCatEmpty Then 
        For Each vItem In vInp 
            Cat = Cat & CStr(vItem) & sSep 
        Next vItem 
        For Each vItem In vInp 
            sItem = CStr(vItem) 
            If Len(sItem) Then Cat = Cat & sItem & sSep 
        Next vItem 
    End If 
    Cat = Left(Cat, Len(Cat) - Len(sSep)) 
End Function 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Hi there....

I have a raw report that I get, it's headers are always the same, but the order of the columns might not be the same everytime and the number of rows also could be different.

Anyways, I know what headers of the columns of interest that I want, I would like to copy the multiple columns and then paste them into a new sheet, please keep in mind that the columns are multiple and might not be next to each others, so:

Let's say that I have a sheet with Columns A through W

but I might only want 5 columns, A, C, R, P, W - just as as example:

The header name are always the same, say:

A - First Name
C - Last Name
R - Suffix
P - Home Phone
W - Spend Rank

I noticed that I could select multiple columns by using the Ctrl + and clicking on the columns, but I couldn't copy them or nothing, it wasn't allowed.

Please let me know how I can do this in VBA! that would be a great starting point for me, then I will need to learn how to place the columns in the order that I want and do some other things on them.


I have a CSV file with about 3,000 rows of data. I want to know if there is a function that will find all rows and list them with the data you are looking for, then where you then can select the results and past them into a new CSV file? For example if you use the find feature to search a whole spredsheet and hit find all it will bring up all instances in the bottom box. But I was wondierng if there was a way to select all the rows it fins to make it easier and quicker to do what i am doing.

I'am trying to write a code that copies specific cells from one workbook to another without overwriting existing data in the destinationbook. However, my codes fails. I want to do the same procedure for another six cells which are not next to each other in the sourcebook and are not going next to each other in the destinationbook
Here is my code, could somebody help to adjust?
Thank you!

    Dim b1 As Workbook 
    Dim b2 As Workbook 
    Dim w1 As Worksheet 
    Dim w2 As Worksheet 
    Set b1 = Workbooks("POForm") 
    Set b2 = Workbooks("DataBase") 
    Set w1 = b1.Worksheets("PurchaseOrder") 
    Set w2 = b2.Worksheets("SpareParts") 
    Dim sourcerange As Range 
    Dim destrange As Range 
    Set sourcerange = w1.Range("O4") 
    Set destrange = w2.Range("A3" & Rows.Count).End(xlUp).Offset(1) 
    sourcerange.copy destrange 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

In an attempt to optimize my macro, I want to set ranges equal to each other instead of copying and pasting values. Is this possible across 2 different worksheets?

I cannot determine why this code segment is not currently working:

Sheets("Open and Pending Issues").Range(Cells(1, 1), Cells(MyLastRow, 18)) = Sheets("All Issues").Range(Cells(1, 1),
Cells(MyLastRow, 18)).Value 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
If I substitute the following, the code works fine:

Sheets("Open and Pending Issues").Range("A1:S331") = Sheets("All Issues").Range(Cells(1, 1), Cells(MyLastRow,

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Thanks in advance!


Im writing a macro to create a barchart where the source data's row count will differ but the columns where the data is stored won't, but the columns are not next to each other.

The solution below selects data from my defined Range in columns A,B & C

Am I right that I cannot use .Columns to specify ONLY columns A & C?

Else I will use Cells and then selects values using offset and other such values.

On a related note I was unable to use an existing range to select data for a COUNTIF

I was unable to use RangeName.Columns("E") with the COUNTIF replacing C5:C5 

How is this possible?

Thanks and a big thanks to those who've helped on other posts!

Hi everyone,

I had a question about comparing it possible to compare
columns to each other. So, for example...

Column1 Column2

Apple Orange
Cherry Apple
Orange Grape
Melon Melon
Grape Strawberry

I want excel to compare the two columns and list me the ones that do not
match. So the results would be Cherry and Strawberry. I'm not concern on
how the out put looks. I just have to find out what dropped off from the
first column to the second and what was added on. Any help would be


I am trying to sum all numbers <0 using the SUMIF formula in Excel 2003.

FORMULA: =sumif(range,criteria,sum_range)

I got it to work, but I have cell ranges to total that are not next to each
other (such as A5:A15 and C5:C15).
When selecting the ranges for the formula, Excel writes them A5:A15,C5:C15

because of the comma (,) between the cell ranges Excel is reading the A5:A15
as the range and C5:C15 as the critera. How can I get this formula to allow
me to select multiple cell ranges?

All help is appreciated.

Thank you.

Hi there,

In a pie chart, with small pies stay next to each other, their data
labels display overlap each other.

Is there any obvious solution to this?


*** Sent via Developersdex ***


I use the Worksheet_Change-function for two cells to write to each other.
So, I have sheet_1 with cell B1 and sheet_2 with cell B1. Everytime, when
the user changes the content of one of them, the other cell changes it's
content too. That was easy. But now, the user should be able to insert
columns in sheet_1, so it could happen that cell B1 moves to cell C1. So the
function worksheet_change will not work correctly anymore. Is it possible to
handle this problem or is there no solution?

Thanks for your answers!

Christian Galbavy

I need to have three rows link to each other. The first column cell A is a paste link and is always changing. The second B is a vlookup referenceing A and finding it in a changing table...the source for the paste link. C needs to follow the other two cells and remain "attached" to it. However, C has to be a cell that is hardcoded somewhere, meaning that C is not found in the source data and must be determined by a person. I have tried to link the sheets through vlookups and other formulas, however, this only works when the data is sorted and nothing new is added. I need a static sheet that can take in new values. Any ideas would be extremely helpful. I need to create some sort of relationship between the cells.


I volunteer for a small non profit and we have a shop that we run where we sell about 100 products. The shop is staffed by volunteers. Here's what we are trying to do:

We want to keep one spreadsheet that has an inventory of our products so that we can see when we are low on items. We like for this sheet to automatically update from our sales worksheets. Each day, when a volunteer opens the shop, they open up an excel template that has a list of the products and their costs, where they record their daily sales by marking the number of each item that they sell (in the row for that item). At the top the spreadsheet has some tallies so they can see how much they sold for the day. Next to each item their is a column for cash, a column for credit, and a column for gift certificates. At the end of the day, they save the spreadsheet as a new file in a designated folder with the file name MM.DD.YY.DailySales.

What I am trying to work out is if there is a way to take the total numbers sold column from all the spreadsheets in the daily sales folder and automatically add a column for each one in the inventory spreadsheets (preferably with the date at the top) so that the inventory spreadsheet can stay up to date without anyone having to copy and paste the sales totals column into the inventory spreadsheet). Does anybody know if this is possible and how I might go about it.

It seems like it wouldn't be that hard if there was just one sales spreadsheet, but because we are creating a new one each day, it gets a little trickier. The staff wants us to continue making new ones each day since we are volunteers and then there is less risk of us screwing things up than if we were all working from the same spreadsheet.


Hey guys, I need some help.
I am trying to write some code to copy and paste values from columns in one worksheet to another, the thing is the columns are not next to each other.
I need to copy the data in each column up until the last row with entries in. This is what I have so far:

Range("B1:B,H1:H" & Range("H65536").End(xlUp).Row).Copy 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
But I get a Run-time error '1004': Method 'Range' of object '_Global' failed

I am guessing that the way I have assigned the range is wrong? Can anyone help me shed some light on this error and how to correct it?


Hi guys,

2 questions:

1) What would I write in the forumla section of the condition formatting to format cells equal to today's week number?

2) How could I have a sum of various cells (not next to each other) i.e. Y1,Y6,Y11 and Y16 (this is just an example, in reality I have alot more cells to refere to).
but ignoring all errors, at the moment if any one of them is an error it wont give me the sum of the others.


No luck finding an answer? You could always try Google.