Reputation
1,936
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
9 13
Impact
~276k people reached

Nov
1
comment Creating a macro to copy data and paste to another workbook
re: VLOOKUP; In the complete range of data the first column has to contain the values you are comparing your look up value against. if there are a total of 7 columns of data in the complete range of data and you want the values in the seventh column then change the 2 to a 7
Nov
1
comment Group By, Sort, Count functions to keep running total
i believe you would need to add (edit) it to your original question. when posting answers there is a button near the top to insert an image
Nov
1
comment Creating a macro to copy data and paste to another workbook
edited my answer to include the VLOOKUP
Nov
1
revised Creating a macro to copy data and paste to another workbook
included requested VLOOKUP code
Nov
1
answered Using the Transpose tool in Excel for a large column of values
Nov
1
answered Creating a macro to copy data and paste to another workbook
Nov
1
answered Group By, Sort, Count functions to keep running total
Nov
1
awarded  Supporter
Nov
1
revised How to split HDMI video and audio?
edited to included followup comment in answer
Nov
1
revised Looking for Fast RS-232 or RS-485 Interface Cards for Windows
added 481 characters in body
Nov
1
answered Looking for Fast RS-232 or RS-485 Interface Cards for Windows
Oct
30
awarded  Autobiographer
Oct
30
awarded  Editor
Oct
30
revised Using Macros with Word 2007
deleted 115 characters in body
Oct
30
comment How to split HDMI video and audio?
ok. after searching amazon.com for a couple minutes i found the following: tinyurl.com/2vqljhh :it shouldn't be too hard to convert that into whatever inputs your speaker system has (althought it does look like you'd loose any native surround signal). if you need to keep the HDMI video signal for your monitor then a simple 2 way split before the coverter would do the trick. something like this: tinyurl.com/33c7wwc
Oct
29
answered Using Macros with Word 2007
Oct
29
answered Excel lookup based on times
Oct
29
answered How to split HDMI video and audio?
Mar
19
awarded  Teacher