• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Trouble rearranging data

D

David gonzalez

New Member
Hi all,

My Name is David, i'm a retired old crazy men that decide to learn some computers and i would like do some stuff in excel,

i've been research the internet, but is kind of difficult because it came across a lot of terms like scrip,macros and code that confuse me a bit...

To be honest, this excel programming thingui is lill hard, but i think i can do it..


I need some help, Please if some one can give me a hand, i'll appreciated a lot..


on 1st Step : Cell A1 and B1.

A1 I'll name it "DATA-1" In B1 I'll paste 10 #s from 01 to 36


on 2st Step : Cell A2 and B2.

A1 I'll name it "DATA-2" In B2 I'll paste 10 #s from 01 to 36


on 3rd Step : Cell A3 and B3.

A1 I'll name it "DATA-3" In B3 I'll paste 10 #s from 01 to 36


on 4th Step : Cell A4 and B4.

A1 I'll name it "DATA-4" In B4 I'll paste 10 #s from 01 to 36


on 5th Step : Cell A5 and B5.

A1 I'll name it "DATA-5" In B5 I'll paste 10 #s from 01 to 36


Step 6

======

On Different cells over the sheet i'll want to have at least 5 times each of the DATA (DATA1 TO DATA5)


What I would like to accomplish via (macro, i supposed?) is that when Paste the Set of 10 Numbers for DATA1,( cell B1) the Pasted numbers get copy in the other cell that appear DATA1 over the the sheet (at least 5 times spreaded in the sheet)


If i paste another set of numbers in DATA2 (B2), Then the Pasted numbers get copy in the other cell that appear DATA2 spreaded in the sheet..


if any one can tell me on how to do just for DATA1, i'll figure it out the rest..


Best regards from Miami


David
 
Hello David,

The great thing about learning is that one is never too old for it! Congratulations on your new adventure with Excel!


You will find lots of tutorials and articles on this and other sites to teach you everything about Excel. If you haven't tried out some of the menus on top of this screen, I would encourage you to explore them.


Regarding your question, I am not completely clear on what you are attempting to do. Are you wanting to copy a single value to 5 other cells? Also, I am not clear on what you mean by "paste 10 #s in B1".


In any case, I would encourage you to read some of the articles and tutorials on this site, and then you would be able to do what you are attempting to do, and much more.

Since you are starting out with Excel, I would suggest starting with the "Welcome" menu page.


Enjoy your retirement and your journey with Excel!


Regards,

Sajan.
 
David


Firstly, Welcome to the Chandoo.org forums.


Can you post a sample file, Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

add any instructions and a sample output if that is possible
 
Wow,!! what a warm welcome... Thank you mr Sajan and mr Hui,

Mr Sajan, i was reading some tutorials and i know is matter to learn some functions like pivot, or templates and hang in there.


Yes mr Hui, in a bit i'll post a sample work sheet of what i need (of course, it will be with no function..)


Thank you Very Much..!!!!


David
 
Hi Mr. Hui,


I'm not sure if i posted the sample file correctly,

Please let me know..


p.s,

i just need a the jump about this help..


Apreciated a Lot


https://dl.dropbox.com/u/70638562/davidg.xls


Best Regards from Miami


David
 
Hi David,


Can you please download the below file and try:

(use Control+q to run the report. First it will look for C1 value if true then it will not looks for remaining cells)


http://www.2shared.com/document/j6g9m8Pc/davidg1.html


Thanks,

Suresh Kumar S
 
Hi Mr Suresh Kumar,

Thank you !!,


i downloaded the file,


-I run OpenOffice

then Open file -> davidg1.xls

Once is Open, i pasted a 10 numbers (between 01 to 36) in cell C1

Then Press Ctrl+q to Run report


And don't do anything, OpenOffice close (quit) instead..


Question : do i have to use MS-Office in order to work fine?


please i wait for your response


Thank you,


Best regards from Miami


David
 
Hi Suresh,


I haved install the MS OFFICE 2007, and i see that recognize e macro installed..


Unfortunately doesn't work, let me tell you what i did.


1-.Run excel, Open Davidg1.xls (at this point i enable Macro)

and minimize excel

2-.In window Desktop i choose a txt program,

3-.i Right click and Copy a 10 numbers (from that TXT Program)

THEN

4-.Maximize excel.

At this Point

5. I Paste the 10 Numbers at Input cell ( which is cell C1, named DATA1 )


AND

Press Control+q (to Run Report)

I check if the New Set of 10 that i pasted in Input cell C1(DATA1) got Pasted in cell F3, F8, F13 and no...nothing happen, (numbers Not get pasted F3.F8,F13.)


As i said : i just need 1 macro or example on how to do it for DATA1 in C1, THEN I figure the rest.


P.S : Sorry to bother, but some time i'm a bit dummy..(just a bit)

:(


Thank you !


Best Regards from Miami


David
 
Hi, !!


Ok, i'm learning lil by lil..


Mr Suresh, with all respect, i know you're a master in excel (i'm a beginner..jiji)

i saw the macro you done, and i think why the code is not doing what i need..


for short explanation i'm going to use Only the Macro with Input C1 (DATA1)

Note that the Numbers that i wrote in C1 (01 tru 10) It just was for Ilustration when Mr Hui ask me for a sample sheet, in C1 it will be empty cell, until i use the Copy/paste function from external TXT program in windows) Then Paste 10 set of Numbers in C1, (note: numbers can be any from 01 to 36)


such new 10 set of numbers pasted in C1 Then have to be pasted in Cell "F3,F8,F13," after Press Control+q to run the Report,


Now, i ask my self :

in the macro of C1, what is supposed to have the spot right after "Value = " that have the numbers with in parenthesis " " , due that is suppose to be empty or hold old numbers before Paste the new ones..

?? --> ( If Range("C1").Value = "01-02-03-04-05-06-07-08-09-10" )


the macro for C1 :


Sub copydata()

If Range("C1").Value = "01-02-03-04-05-06-07-08-09-10"

Range("F3,F8,F13").Select

Selection.Copy

End If

End Sub

---------------------------------------------------------------------

Sub copyinfo()

' Keyboard Shortcut: Ctrl+q

If Range("c1").Value = "01-02-03-04-05-06-07-08-09-10" Then

Range("F3,F8,F13").Select

Selection.Copy

End If


End Sub


I'm so glad, learn something new... ^_^


Best regards from Miami


David
 
David


When posting at Chandoo.org can you please use more descriptive names for the posts than

"Hello from miami.... Please i need some advice... please??"


We have a specific forum for saying hello and introducing yourself.

http://chandoo.org/forums/topic/welcome-to-phd-forums


Obviously everyone posting needs advice, so generally just state the nature of your problem.

In your case a title may have been "Trouble rearranging data"


Using good descriptions does tow things

1. Makes searches more targeted

2. Attracts solutions from people who have specialties in that area

For example I don't read certain posts if I know I don't have expertise in the area, but I also do read posts where I do have expertise.


Now that were getting 30 or 40 posts a day, a Good Title increases the chance you'll get a swift solution.
 
Hi David,


I am also a learner not a master has you said in your comments and this "CHANDOO" site have thought somemany things to somemany people. So i request you to wait for any other EXCEL NINJA who can happily assist you.

Related to my macro:

As soon as you opened the file you have to enable the macro which will display in the message bar.And also I would like to share you that I have written the macro which will work in first-cum-first basis.Suppose if the value matches in the first cell then it will not go to the second option.


Thanks,

Suresh Kumar S
 
You must log in or register to reply here.
Back
Top