# Tagged Questions

**-2**

votes

**0**answers

29 views

### Search entire row for specific number and if found copy data from adjacent cell to the right

I can use Microsoft Excel or OpenOffice.
I have one row of cells with 20 columns. I want to write down formula that searches entire row for number 38 (match case). If found, copy the data from ...

**1**

vote

**1**answer

54 views

### Dragging a cell reference in intervals

I have data as follows (simplified) in two worksheets on a document:
Sheet 1 data:
A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3 ...
Sheet 2 data:
A1='Stage ...

**1**

vote

**1**answer

179 views

### Excel 2010 VBA only affecting last row in range

I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code:
Private Sub ...

**0**

votes

**1**answer

44 views

### How to have excel paste a value in a specific cell according to another data table

I'm working with excel 2010,
I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.
The numeric ...

**0**

votes

**1**answer

236 views

### Updating another Excel spreadsheet from current spreadsheet

I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...

**0**

votes

**1**answer

163 views

### Formula to display text from multiple cells from one sheet in another

I have a list of sales reps and the names of the customers they've sold product to, on one sheet. I have tried VLOOKUP, but it will only return one set of text from the cells. I would like to know, ...

**0**

votes

**0**answers

57 views

### Hold cell spacing when copy/paste

I need to copy only certain cells, example.
A1, D1, G1, J1, M1
To:
A6, D6, G6, J6, M6 or H6, K6, N6, etc
(Notice the equal spacing between the cells to copy and where to paste.)
But when i paste ...

**0**

votes

**0**answers

27 views

### How to use the Integer i.e. currentregion's row from the macro in a cell's formula

How do I use the row from the current cell, in another Cell's Formula on another sheet?
I created this Macro, but don't know how to use the Integer from the macro in a cell's formula.
In a macro I ...

**0**

votes

**1**answer

431 views

### How to bulk replace links that are embed to words in Excel cells

I have a huge list of words that have links. All the URLs have text that repeats. I want to mass replace this text with another. Right now, "Replace all" only searches between words, not through the ...

**0**

votes

**2**answers

16k views

### How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...

**0**

votes

**3**answers

4k views

### How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...

**4**

votes

**1**answer

2k views

### How do I copy the results of a calculation without copying the formula behind it? Open Office Calc

How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...

**0**

votes

**1**answer

71 views

### Excel Formula For Re-arranging Numbers

I have got a bit stuck with trying to make a formula in Excel, and last time I asked a question here I got great help, I have come back again. At the moment I have column A with sets of product id's. ...

**1**

vote

**3**answers

900 views

### Create a hyperlink from URL and title in Excel

I'm trying to construct a hyperlink from a URL and a name in different cells.
a1 = http://www.example.com/
b1 = example
c1 = <a href="http://www.example.com/">example</a>
What I want ...

**0**

votes

**1**answer

1k views

### Excel - Displaying a value in a cell dependent on another cell having text

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport ...

**0**

votes

**4**answers

2k views

### Excel - Smooth a curve by calculating / interpolating source missing values

I have a table of values like this one :
18
18
18
46
46
46
46
46
57
57
57
57
57
57
69
69
69
69
69
69
64
64
64
64
64
64
56
56
56
48
48
48
44
or if you prefer :
18
0
0
46
0
0
0
0
57
0
0
0
0
0
69
0
0
...

**1**

vote

**1**answer

3k views

### Excel cell references not updating when referenced cells are sorted

There are two tables, each with 75 entries. Each entry in the 2nd table calls an entry in the first table a parent. One of my 2nd table columns contains the "Parent Price", referencing the Price ...