I have an office that has 10 administrative users and a small retail showroom With 3 sales people. I would like to be able to have my sales people be able to fill out an Invoice in MS Excel an...
Hi,
I'm trying to create a function that returns a recordset. I'm having issues where because I close the recordset before the function passes the value, the error that says that: "the ope...
Hi Experts,
Please view the attached Excel File. In summary, it contains:
" Actual Orders (Dummy Numbers)
" Moving Average Smoothing Out Peaks
" 4th Order Polynomial Curve, forecasting o...
I am looking for a snippet showing how to copy a worksheet from a file to the current workbook that is executing the vba code in question.
Probably already answered but I didn't find it: how can I format a number in a textbox so that when it appears in a textbox form it's formatted as number with 1000 separator? It should be easy...
Hi Experts,
So far, I'm using Microsoft Excel 2007 to keep track of the total sales, cost of goods sold, and gross profit for a specific period, which can be used to keep track of individu...
I have a PivotTable and PivotChart I'm trying to add a ComboBox to allow a user to select a date range by Quarter to display.
The date data is in the format "2009-11" for November '09. I n...
Hi All,
With the code below I have created a resizable two dimensional array i.e. initially 1 row by 2 columns. The procedure is an attempt to store cell values in row 1, column 1 & 2, row ...
I'm trying to create a stacked bar graph to track my on-time delivery. My boss wants it to show a stacked bar graph for each month in the year. What he's looking for is each stacked bar to sho...
We are importing an *.xls file from a GPS tracking program that we would like to use in a GIS program to map vehicle activity. The file comes across with the date & time in a single field. I h...
Hi All-
I need some help with code. I have an active worksheet that I need to copy information to another worksheet. Below are the steps I need the code to take:
1) Copy a range (columns...
Experts,
I have this lingering issue that I though I solved. If there is no match in vlookup then I thought the below formula would return a " " but it does not. Are there any suggestions ...
I would like a formual that would strip out the value between two $'s
Cell Value: DealerMaster_Level3!$Scott$2
I have a from sheet that I found somewhere (been on my desktop for a while).
What I would like is for the user to select a cell and then run this from, and the first block be the value of t...
Pulled from cpearson:
http://www.cpearson.com/excel/FirstLast.htm
I am using vba to break down full names into separate components. I have modified it to look like this so I can control wh...
In the attached file, I need a formula that will make values in column G negative where the values in column C match the values in column F.
Let me see if can give an example.
In column ...
Hi Experts,
I am using the following code to filter the unique entries in a Database. I need to delete all the entries which are not unique (i.e., hidden in the present case). Need a macro ...
i want a macro that calculates elapsed business time between a start date and end date in dd:hh:mm:ss format in MS EXCEL keeping the following parameters in mind
1) should exclude lunch bre...
Please see the code below. I ran this code with excel 2003 and run fine, however, when I run this in excel 2007 it gave me the error message below 'Run-time error'
When I clicked on debug, th...
I have a workbook that I need to mail sheets to different users. Each sheet goes to 1 different user. Each sheet (tab) is named SB01-SB25. The email list will be contained in the tab named ...
Hi,
This is step 2 to my earlier question. In step 1weI created a macro that takes a spreadsheet and adds new columns to it. The new columns all end in "_OR_HALF_DL". Now for step 2.
...
I have 14 level nested if statement (see attached). Excel 2003 will only let me use 8 levels. What is another way I can still retun this desired value and or change the max number of allowed ...
Hi all. I'm having an issue in Excel 2007 when using a pivot table that has a conditional format. Basically every time I refresh the data I lose all of the formats. From what I'm reading I nee...
I have a 50 sheet Excel WB. I need certain ranges (some of varying sizes) on each sheet to go to a word doc. 1 Sheet in Excel:1Page in Word Doc. On each excel sheet, I need to take:
Sheet N...
I pieced together this code to populate 2 list boxes. I really need either to link the two so that if I select 'number' the corresponding 'name' is selected in the other box or vice versa. I...
