main

Hi, I've been scratching my head on a problem which I can't figure out a nice solution to. I hope an expert can give me a steer on the steps I should take! I have a main parent model file which needs to import data from child models. The folder containing the input modules is on the same path...

Hi there, What I am looking to do is move 5 workbooks from our main server (original files) and create one workbook on my pc so I don't have to go back and fourth and all over the place to grab the info I need from the main server. The catch is, I would like them to sync each way. Meaning, if...

Hey, I'm new to VBA and I'm wanting to transfer data from a number of workbooks (Sub Workbook 1, Sub Workbook 2, Sub Workbook 3 etc) to a main workbook (Database). The location of the data contained within all the Sub Workbooks is the same (Sheet1 & A4:A52). I'm wanting to paste this data into...

So I have been doing a lot of searching to no avail. I need to transfer data from one sheet to another sheet, by filters each night, then clear the data. I want to transfer the data from the main sheet below to the breakdown sheet separated by machine f4 to the Fadel table, h6 to the Haas ect...

Anyone How to to display the Following in XML with Following <co name=""><add1><add2><PHP> <a1><b1><city><Header>Co Name</Header> <Address>Add1</Address> <Address>Add2</Address> <A1> <B1> <customer>ABC Co</customer> <address>123 Main</address> <city>Salem</city> </B1>...

I have a userform in a workbook called frmSelectFile with the workbook named Main. The userform opens other workbooks. Once those other workbooks are open, they are considered the Activeworkbook. So I had to Load frmSelectFile so workbook Main now is the Activeworkbook. So my question is how can...

Hello, Thanks in advance for your help. I realize the formula below may have other issues that could be corrected and I appreciate any tips or suggestions given. But my main problem is I want this to be an OR statement and not sum the two together. I'll try and show it below...

I have a spreadsheet that In Column A, I want to Look up instances where the cell has a value of ABC123 and then run a Copy Data Code and return to look up the next instance of ABC123, but the code is loosing ABC123 and not going through all instances of it. I made some comments in my code below...

Hello, I have a workbook that is a main tracking workbook that needs to look up data from a user selected workbook. What I need it to do is to loop through column B in the Main tracking workbook, look up the value from column b in the user selected workbook and copy/paste data over to the main...

Hello I am in need of help, :( This is the story: I have a main sheet where I add information daily. We work with Macros, where there are 3 vlookup formulas looking at the information I add on the main sheet, so if someone else have the same Item, they know it is a duplicate and we don't use...

My initial problem was this: Ihave a coworker that maintains a spreadsheet comprised of several tabs, thefirst is the main and contains all the information about each business partnerwith columns showing their 1st choice wholesaler, 2nd choice, 3rd choice and soon. And then there's a tab for...

Hi All, I hope someone can help me.. My problem is, I have Report in MS Access with Main form and subform on which subform linked to main form. How can I export to excel the main and subform altogether, because as of now I can't export both. I have found a code below on the net but I don't know...

I have a form with a navigation control. How do i tell the childform in my navigation control to go to the same record ID that i have open and showing in my mainform? i want both my child form to open the same record (based on ID number) as my main form have open. and when i change to a new...

Worksheet1 <tbody> LastName FirstName Code ID E Group Address H Group2 Address2 K Group3 Address3 Smith John 01, 03 123456 Place1 123 Main St. Jones Fred 06 852547 Place1 123 Main St. Place2 345 Water St. Place3 567 High St. White Barb 03, 123, 04 258787 Place1 123 Main St...

I have searched quite a bit and can't put the answer to this one together. I have a spreadsheet similar to this: <tbody> Group Built Price Fee Main Group 1 Abcdefg 426 $ 903.58 $ 2.12 Subcategory A 157 $ 277.58 $ 1.77 Subcategory B 125 $...

Hi, For the coming world cup, me and some friends have filled in our forecast in an excel file. Al morning i am trying to find a good way for handing out points so we can have a ranking based on the score of our forecasts. Although we are trying to keep it simple, it seems not so easy to...

Hi, I am looking to copy values from a specific range in a closed workbook/worksheet into a specific worksheet in the main workbook. The closed workbook is not in the same folder path. I am looking for the user to select the file. The workbook name that has the values is named MTD with...

Sheet 1 has a column with a number of values selected from a drop down list (This 'Main' list is defined on a separate sheet 3) Sheet 2 column A reflects the 'Main' list then column B uses a countif statement to count how many times the value in A appears. (See below) <tbody> a b 1...

Hello, I have 6 Excels files. I am using one file as the main file, and the other five I am using as data connections for the main file. My code is as follows Sub DataRefresh() Dim wkb as Workbook Set wkb = Workbooks.Open("filepath") wkb.RefreshAll (This is where the debugger says the error...

Good Day Community, I am looking for VBA Code on a project where i can use buttons to move between sheets. While moving between sheets i'll like only one sheet visible at any given time and use buttons to unhide and hide other sheets based on user action(button click) Lets assume i have 4...