Timeline for Copying from sheet to sheet if column headings match
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Jun 25, 2015 at 13:04 | history | suggested | Suresh Kumar Veluswamy | CC BY-SA 3.0 |
formatted question to make it more readable
|
| Jun 25, 2015 at 12:46 | review | Suggested edits | |||
| S Jun 25, 2015 at 13:04 | |||||
| Jun 14, 2015 at 20:48 | answer | added | ChipsLetten | timeline score: 3 | |
| Jun 14, 2015 at 16:53 | history | edited | Jamal | CC BY-SA 3.0 |
deleted 67 characters in body
|
| Jun 14, 2015 at 10:14 | comment | added | ChipsLetten | Can you clarify why you have the long list of strings? Your description says that you are matching column headings from the second sheet with those in the third sheet, so can I replace the array (collection in rubberduck's answer) of string values with code that reads from the second sheet? | |
| Jun 1, 2015 at 20:33 | history | tweeted | twitter.com/#!/StackCodeReview/status/605472339824930816 | ||
| Jun 1, 2015 at 17:38 | answer | added | RubberDuck | timeline score: 5 | |
| Jun 1, 2015 at 16:06 | comment | added | Phrancis | @BLkrn I have added this detail into your question, thanks for explaining | |
| Jun 1, 2015 at 16:05 | history | edited | Phrancis | CC BY-SA 3.0 |
Added detail from comments into question, adapted title accordingly
|
| Jun 1, 2015 at 15:55 | comment | added | BLkrn | Basically, I have three sheets in my workbook where only the second and third worksheets are being used. I want to copy columns from the second sheet to the third sheet only if the column headings match. For example, the code will check the first row of sheet2 to check if it matches any of strings in an array and if it matches, it will copy the entire column to the third sheet under the same heading. | |
| Jun 1, 2015 at 15:50 | comment | added | RubberDuck | It might help if you can describe a little more in plain english what this code does. | |
| Jun 1, 2015 at 15:48 | comment | added | Phrancis | Welcome to Code Review! I'm sure there are ways this can be improved; I hope you get some good answers from our VBA pros! | |
| Jun 1, 2015 at 15:45 | history | edited | RubberDuck | CC BY-SA 3.0 |
added 4 characters in body; edited title
|
| Jun 1, 2015 at 15:43 | review | First posts | |||
| Jun 1, 2015 at 15:44 | |||||
| Jun 1, 2015 at 15:40 | history | asked | BLkrn | CC BY-SA 3.0 |