I have some data and i want to paste some excel code underneath each row
hsa05212:Pancreatic cancer E2F2 E2F3 BCL2L1 ACVR1C ACVR1B
hsa04910:Insulin signaling pathway GRB2 PRKAG1 HK2 FOXO1 RPS6KB1
hsa04916:Melanogenesis WNT5A ADCY1 GNAI3 ADCY6 EDN1
hsa04720:Long-term potentiation ADCY1 PPP3R1 PRKX KRAS PLCB4
so that it looks like
hsa05212:Pancreatic cancer E2F2 E2F3 BCL2L1 ACVR1C ACVR1B
4 6 3 2 1
4 6 3 2 1
4 6 3 2 1
hsa04910:Insulin signaling pathway GRB2 PRKAG1 HK2 FOXO1 RPS6KB1
4 6 3 2 1
4 6 3 2 1
4 6 3 2 1
hsa04916:Melanogenesis WNT5A ADCY1 GNAI3 ADCY6 EDN1
4 6 3 2 1
4 6 3 2 1
4 6 3 2 1
hsa04720:Long-term potentiation ADCY1 PPP3R1 PRKX KRAS PLCB4
4 6 3 2 1
4 6 3 2 1
4 6 3 2 1
The numbers are just to represent the excel code. I already have the code formatted, and i can just select each row individually and select "Insert Copied Cells" but it doesn't let me select multiple cells and then do the insert.
Is there an easier way of doing this?
thanks
code
? Are you trying to paste VBA code into the cells? Or are you referring toformulas
?Insert Copied Cells
-> forgot, that this is a menu-function too. Ok, then I just would like to know a bit more, how your data is organized. Do you have csv-file of data? xls-files? can you give an example? are there only those 4 headline you provided or are there more?