10 Visitor Messages

  1. View Conversation
    Dear Mrice are you there?
  2. View Conversation
    Apologies, yes that did work

    Thank you again, your service has been extremely helpful!
  3. It should already cope with this, have you tried it?
  4. View Conversation
    mrice, you are very helpful and for that I thank you; however not to keep bothering you about this topic, is it possible to expand on this i.e. if there are multiple IDs:


    if....
    ID.....Region 1.....Region 2.....Region 3.....Channel 1.....Channel 2
    1...........X...........................................X.....................X......................X
    2..................................X....................X.....................X

    then...
    ID Region Channel
    1 Region 1 Channel 1
    1 Region 1 Channel 2
    1 Region 3 Channel 1
    1 Region 3 Channel 2
    2 Region 2 Channel 1
    2 Region 3 Channel 1


    And so on if additional IDs are added
  5. Will post example to Forum
  6. View Conversation
    Thank you for the response

    http://www.excelforum.com/excel-prog...ml#post2436458

    However I am having difficulty executing the macro, could you please help?

    I have the initial table beginning in cell a1 (entire table: 2r x 6c)

    Thank you,

    John
  7. View Conversation
    Nvm, I messed around a bit with it and figured it out. Thanks again a ton though, this macro is kicking *** on this project.
  8. View Conversation
    Hey you helped me out with some recent code to fill a master sheet with info from various other sheets.

    For N = 2 To SourceWorkSheet.Cells(SourceWorkSheet.Rows.Count, 1).End(xlUp).Row
    For M = 3 To Cells(Rows.Count, 1).End(xlUp).Row
    If Cells(M, 1) = SourceWorkSheet.Cells(N, 1) And Cells(M, 2) = Condition Then
    SourceWorkSheet.Range(SourceWorkSheet.Cells(N, 3), SourceWorkSheet.Cells(N, 12)).Copy Destination:=Cells(M, 4)
    End If
    Next M
    Next N
    End Sub

    Anyway I'm doing the same thing but with a slightly different layout now for a different set of data on the same project. I'm assuming I could restructure this macro slightly and make it work for my new task as well. Do you think you could explain the logic to me for what is happening in the portion I posted above? If i can better understand it I'm sure I could restructure this macro for my current task and the future ones I have with this project.
  9. View Conversation
    Sir,

    I have a excel file containing data records continuously in rows. I would like to convert it into columns.

    Col A Col B
    Row 1 ID 30159
    Row 2 Name Bala
    Row 3 Design TO
    Row 4 Respon Emails
    Row 5 Fax
    Row 6 Computer
    Row 7 HRD
    Row 8 JDate 20/04/2010
    Row 9 <Blank>
    Row 10 ID 30160
    Row 11 Name Balamurugan
    Row 12 Design SO
    Row 13 Respon Shorthand
    Row 14 Data Entry
    Row 15 JDate 20/04/2010
    Row 16 <Blank>
    Row 17 [Next record]...

    As you can see from the data above, the data in the field 'Respon" is not of fixed size. It may increase of decrease (in terms of rows). Also after a blank row the next record starts therefore there should be a line break after every blank row.

    Could you please help me by the way of a macro to solve the above?
    Thanks a lot!
    Bala
  10. View Conversation
    Helped me with a complex excel issue. Created a perfect soloution extemely rapidly. As a new member to the forums I found his help most beneficial. Thank you.
Showing Visitor Messages 1 to 10 of 10
About mrice

Basic Information


About mrice
Biography:
Research Scientist with many years of spreadsheet development experience
Location:
Surrey, England
Interests:
Computing, long distance running, playing guitar
Occupation:
Research scientist
My Microsoft Office Version:
Excel 2007/2010

Signature


Martin

Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.

If my solution has saved you time and/or money, please consider donating to Cancer Research UK.

Statistics


Total Posts
Total Posts
2,810
Posts Per Day
1.01
Last Post
Loop to find, copy and paste data doesn't work Today 02:52 PM
Visitor Messages
Total Messages
10
Most Recent Message
01-28-2012 05:52 PM
General Information
Last Activity
Today 02:52 PM
Join Date
06-22-2004

2 Friends

  1. leo73pk leo73pk is offline

    Forum Contributor

    leo73pk
  2. pike pike is offline

    Forum Moderator

    pike
Showing Friends 1 to 2 of 2

Search Engine Friendly URLs by vBSEO 3.2.0