The next few paragraphs describe how to do this in a neat and organized way. First, open all the workbooks you will need. Tip To open more than one workbook at a time, select the Office button → Open…, press the Ctrl key (⌘ key on the Mac) while selecting the workbooks you ...
A major part of creating a strong brand identity is figuring out where your place is in the market, and knowing if there’s a demand for what you offer. Once you have an idea of this, take a look at your competitors and figure out what they’re doing, and how you can do it bette...
If .Sheet1.Cells(i, 1) = SSearch Or _ .Sheet1.Cells(i, 2) = SSearch Or _ .Sheet1.Cells(i, 3) = SSearch Or _ .Sheet1.Cells(i, 4) = SSearch Then Wb2.Range(.Sheet1.Cells(i, 1), .Sheet1.Cells(i, 18)).Copy ThisWorkbook.Sheets("DailySearch").Range("A200"...
im a excel noob trying to use vba to copy certain data to another worksheet.i have been trying all the vba line on the internet, and i cant seem to make it work like it suppose to. so Im stuck!! please help me based on the picture i shared, local date dictate ...
Minnie wanted to make a multi colored lava lamp. Instead of explaining why it wouldn’t work (the colors would all mix together in the water to make black) I decided to just let her test her hypothesis. We added several different colored drops and tested it out. While her hypothesis was...
Thanks for all your help. I binned the original code and solved the issue with SQL. Now on to the next problem...! In case it'll help anyone else, here's my solution. Private Sub cmbSearch_Click()Dim cn As ADODB.Connection
im a excel noob trying to use vba to copy certain data to another worksheet.i have been trying all the vba line on the internet, and i cant seem to make it work like it suppose to. so Im stuck!! please help me based on the picture i shared, local d...