Excel Help and Problems

[Jkhein]

I'm having a autofill problem, when trying to drag down a formula, it is only copying the value not the formula.
Calculations are set to automatic,
Anybody knows how to solve?

[myb821]

I'm having a autofill problem, when trying to drag down a formula, it is only copying the value not the formula.
Calculations are set to automatic,
Anybody knows how to solve?

try copy paste special formula

[Jkhein]

try copy paste special formula

just tried it, now it pastes the exact formula of the original cell formulas info (does not update to this new row's column cells info) so it doesnt do anything

[skyguy918]

just tried it, now it pastes the exact formula of the original cell formulas info (does not update to this new row's column cells info) so it doesnt do anything

Ie you have relative cell references that are behaving like absolute references when you copy/paste formulas?

ETA: Might be a corrupted workbook. Try saving in another format (eg .xlsx to .xlb and back again).

[Jkhein]

Ie you have relative cell references that are behaving like absolute references when you copy/paste formulas?

ETA: Might be a corrupted workbook. Try saving in another format (eg .xlsx to .xlb and back again).

I'm a total excel newbie but that might be the term.

When doing what myb821 advised, and pasting special formula into the next row it still stays with the original formula of A1:B1 instead of updating to A2:B2

[jackofall]

Need help to write a Macro. This is the requirement.
There is a data set in Column C and D. Check column D for "X", if a row has an "X" in column D delete all data in Column C.

Thanks in advance.

[etech0]

Need help to write a Macro. This is the requirement.
There is a data set in Column C and D. Check column D for "X", if a row has an "X" in column D delete all data in Column C.

Thanks in advance.

you could just use functions = much easier
put this in E1:

=if(d1="x","delete","")
and copy it to the whole column

Then sort by column E, select all the corresponding cells in column C, and press delete on the keyboard.

Presto!

[jackofall]

you could just use functions = much easier
put this in E1:

=if(d1="x","delete","")
and copy it to the whole column

Then sort by column E, select all the corresponding cells in column C, and press delete on the keyboard.

Presto!

Nice! Thanks. But I need it to be a constant, I dont want to have continue to sort and delete etc.

[etech0]

Nice! Thanks. But I need it to be a constant, I dont want to have continue to sort and delete etc.

Ah, ok. I'll throw something together - give me a minute.

[etech0]

Nice! Thanks. But I need it to be a constant, I dont want to have continue to sort and delete etc.

How's this?

Code: [Select]

Sub DeleteX()

For Each cell In Range([C2], [C2].End(xlDown)).Cells
    If cell.Offset(0, 1).Value = "x" Then cell.Clear
Next

End Sub


[jackofall]

How's this?

Code: [Select]

Sub DeleteX()

For Each cell In Range([C2], [C2].End(xlDown)).Cells
    If cell.Offset(0, 1).Value = "x" Then cell.Clear
Next

End Sub


Wow! Thanks! Perfect!

[etech0]

Wow! Thanks! Perfect!

Pleasure!

[churnbabychurn]

I have a workbook with only a handful of rows, but with massive megilas of text in them.

Is there a way to make that I can scroll through this slowly? Currently when I spin the wheel of the mouse it zooms through the rows as if they were regular sized rows... I want to change settings just for this workbook..

[smurf]

I have a workbook with only a handful of rows, but with massive megilas of text in them.

Is there a way to make that I can scroll through this slowly? Currently when I spin the wheel of the mouse it zooms through the rows as if they were regular sized rows... I want to change settings just for this workbook..

try setting word wrap. Then click the top left corner to highlight the whole workbook, then double click the line between any row, that should snap them all to size

[skyguy918]

try setting word wrap. Then click the top left corner to highlight the whole workbook, then double click the line between any row, that should snap them all to size

That won't help. Scrolling still treats any given row as a unit, and therefore it doesn't scroll through the contents of a given row, rather it scrolls through the rows.

In short, you're out of luck cbc. You're gonna have to manipulate the text if you want to read it within Excel.

[joshnuss]

Does anybody know how to insert a picture in a cell and then press equal that cell in a different cell and the picture will appear? I am not asking for a fancy function on a picture just a equal sign on it.

[churnbabychurn]

Does anybody know how to insert a picture in a cell and then press equal that cell in a different cell and the picture will appear? I am not asking for a fancy function on a picture just a equal sign on it.

Copy and paste?

[joshnuss]

I need it automatically to populate 10 other pages

[aygart]

Does it work to do this
http://trumpexcel.com/2013/05/insert-picture-into-excel-cell/

and then this?
http://chandoo.org/wp/2010/10/19/how-to-use-picture-links/

[etech0]

I need it automatically to populate 10 other pages

Look into the Excel Camera http://www.dummies.com/how-to/content/adding-the-excel-camera-tool-to-the-quick-access-t.html

It's not exactly what you asked for, but it might do the trick anyways.