Hello,
I am trying to copy data from a worksheet populated by equation cells and insert it into another, alphabetical database. When I do a regular "Copy" then "Insert", the equation cells appear as zeros.
When I "Copy" then "Paste Special" and check to paste the Values, the data pastes over the existing data, though I just want it to push the other information down a row.
I am wondering if there is an Insert Special option where I can copy the equation data, and insert it into the database while maintaining the original values.
I hope there is enough information here, any help is appreciated.
Thank you,
Alex
thanks in advance...
is there a special "operator" or character indicater i can use to keep one aspect of a formula static?
ie this was copy from L8
=(((C8*(100%-J8))-C12)*B8)-K8
for pastin special purpose i would like to keep cell c12 "static"
if i move up a row the c12 changes to c11 and down it changes to c13-
thanks again
I have Data in Column A and Column B. For example:
A B
1 1
3 1
1 3
4 8
9 5
Both Column's A and B both have repeats. I want to find the row in which, for example, Column A has a 3 and Column B has a 1. I was looking for a non-vba method.
I suspect this problem has been covered but I'm not sure what keywords to enter for a search of the subject. Any help would be appreciated.
Thanks.
Anybody knows how can I add a special Bar in excel like a "volume bar".
I pretend to substitute that the user enter a number between 1 and 100 with this bar, I do not know how to do it.
Thanks in advance for your assistance.
I have a spreadsheet containing data on radio signals. There are 13 columns and over 1500 rows and each row contains a unique set of data. I need a macro which would be accesible from a rt mouse click. The macro should enable me to select a cell in any column (say d1234) and with a rt mouse click, display all rows of data which include identical data to that in d1234. So, for example if a cell contained "Radio Monaco" I need to see all rows of data where column C contined "Radio Monaco"
A further click of the mouse would cancel the filter. Hope this is enough to explain what I need.
Peter
Hello,
This should be an easy one. How would I modify the following to paste Values & Formats? I dont know why but it has been kicking my butt.
Range("K1").PasteSpecial Paste:=xlPasteValues
Thank you,
Joe
Hi,
I'm pretty new to excel and i've googled my question but i couldn't find an answer. Please help me in a special transpose question.
I have the following data set:
year article name1 name2 name3 name4 name5....
2005 a1 n1 n2 n3 n4 n5
2005 a2 n1 n6 n9
2005 a3 n2 n20 n30
(a data set composed of publication year, article name and author names). I would like this data transposed in a normalized (relational) way: year, article, name, so the example above becomes:
year article name1
2005 a1 n1
2005 a1 n2
2005 a1 n3
2005 a1 n4
2005 a1 n5
2005 a2 n1
2005 a2 n6
2005 a2 n9
2005 a3 n2
2005 a3 n20
2005 a3 n30
Please help.
Thank you,
Catalin
Hi.
I need to add a "tab" as text in a cell. So when i save a file in text,
each line has an additional "tab" imbeded. How can I do it?
Thanks!
Dear Friends
Suppose if I have different values in cell A1:A100 and I want to divide all
of them by 10 and get the result rounded to 2 decimal place . how can I do
that by using paste special commend
regards
