Hello,
I am looking for some help with my little challenge.
I am trying to combine data from 2 different sheets in an automated way, but I don't know VBA and macro well enough to get this to work without help.
I have 2 sheets and I want all the combinations from the to sheets to be copied to...
Hello Friends
Could you please help me with VBA Code for joining two tables on a common column and then generate a third table. Both the tables are on a separate worksheet and the result table needs to be on a separate sheet as well. I can easily do this using Access but my requirement is to...
Hi All,
You have helped me out tons in the past with some of my Excel mindbenders and here is another one if anyone can help!
I have 100+ worksheets spread across about nine workbooks with data that needs aggregated together. Each workbook has identical fields between its own worksheets, but...
(Access 2007)
I have three tables in a database: tblClients, tblOfficeVisits and tblData
tblClients has a primary key CaseID. This is joined (inner, 1-Many) to CaseID in tblOfficeVisits which contains only three fields (CaseID, VisitNumber and VisitDate). The purpose is to list every time a...
Hi...I am trying to query data from 4 different tables. I originally tried the code below but it did not work:
Sub SQLQuery1()
Uname = sheetMain.txtUNAME
Pword = sheetMain.txtPWORD
DBASE = "ZET"
Sheets("Bill Determinant").Activate
Range("A3").Select
SQL1 = "BD.CALC_LEVEL...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.