Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by lshaw79
-
Copying Cells to new worksheet based on formatting using VBA
With regards to the structure of the data in the source worksheet it is laid out like so; "Main Type" "Device Type" "Device Description" "Device Description" "Device Description" "Device Type" "Device Description" "Device Description" "Main Type" "Device Type" "Device Description"...- lshaw79
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copying Cells to new worksheet based on formatting using VBA
Ok thanks.- lshaw79
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copying Cells to new worksheet based on formatting using VBA
Thanks for replying, though I'm afraid you will have to expand on your points a little more as I am having a little trouble understanding. 1. By this do you mean like a flowchart? In which case, no I don't. Simply it would be an If...Elseif...Else type statement, whereby if x is bold and not...- lshaw79
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Copying Cells to new worksheet based on formatting using VBA
Hi, I'm kinda new to this so please bear with and if you suspect I may have missed some information out please ask me to clarify and I will do the best I can. Basically my initial query is as follows. I have some information in an excel worksheet that needs to be copied into another worksheet...- lshaw79
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
