I need help writing a VBA application to add print numbers to worksheet in an Excel workbook. The workbook will have many sheets. Most sheets are only one page, but this is not always the ca...
I looked up the previous answer from Zorvek which was at:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21633283.html
He recommended using:...
Hello,
I have two dropdown boxes with the second being dependent on the first choice. Before I only had two outcomes and so was able to use the code below.
if(F9="Package",INDIRECT("P3:P6...
Good Morning All. Can someone help me convert a calendar date to a calendar quarter? For instance, 03/25/2008 to 1QTR/2008 or 12/22/2007 to 4QTR/2007?
I have a macro running the following code to dynamically populate a column with a VLOOKUP against another table for each row. A lot of the columns in the looked up table have empty date fields...
Hi all,
I have an Excel worksheet that has cells A21:M36 merged and text wrapped. There are approximately 3000 characters of text type in, but only 1200 +/- are visible. I can come up wit...
4 data columns - Time Slot, Device, AvWait & AvService
The time slots are 2 minute intervals across a 24 hour period.
We have 18 Devices in each Time Slot.
I need to plot the AvWait & Av...
Ok What I need as changed abit, as I am now looking at having two different workbooks (Two files).
One that is just the fround page 'Enter' Tab, and then another that holds the 'Pending' an...
I have hiddened some worksheets and would like to prevent the user (except me) from unhiding it. How can it be done? Thanks.
Hi,
I am running an SQL query which is fetching data from Quickbooks a bit earlier then defined starting date limit and a bit further from defined ending date.
Could it be a problem in q...
I need to select and separate out every 12th row entry in an address list. I need the final sort/filter to pull the rows into a separate file or sheet.
I have a macro that creates a 'CommandBar' object. But when trying to add the 'OnAction' method to a 'CommandBarButton' I recieve following error:
Runtime Error -2147467259 (80004005)
Method...
Hi all experts.
I have a macro that is designed to copy cells based on a cell value. I need help to select the range of what needs to be copied. Now it only copies content from column "F". ...
Hi,
I am having some problem using the VLOOKUP function. Could someone help me out. I have a lookup table having five(5) columns. In the main spreadsheet I have to compare one column from the...
I have a macro that works with a range. The range variable. Since the macro has to run on worksheets with the same column names, but different number of records, how do I adjust my macro cod...
I need to pull in data from multiple files. I would like an input box to prompt the user to browse to the workbooks that will be referenced. The user will be able to select as many workbooks...
This isn't my expertise. I do know VB to a certain extent but not in relation to MS Office Apps. Trying to use VB in Excel to get rid of some blocks of rows. My sheet has 13K+ of data but e...
Hi,
I have a spreadsheet with Case_ID (column C) and Agent_Notes (Column S) columns.
The agent notes columns contain all notes from multiple interactions in a single cell, separated by p...
Morning,
I have done a search and cannot find anything on this, I have an issue where we have set Excel to save as .xls however when it auto saves documents it is saving them as .xlsx I can...
Hi there,
I'm looking for some VBA code to help me add two cells in two columns together which look like this:
Current Week Hours | Total Week Hours
4 | ...
I use the Indirect function in a data validation dropdown. But I also need to prevent duplicates in the same worksheet column. Can I perform the duplicate testing in VBA?
I want to have free of charge dashboard (by Excel, Access, java, vb), if anyone had it, pls help to send me source code of URL to download.
I appologize if this has been covered before. I looked in the Knowledge base, but could not find an answer that applied.
I have an excel 2000 spreadsheet, and quite simply whenever a user cl...
i have an excel spread sheet with 6 columns
I would like to return a value in the 7th column that is based on whether any columnshave values that are greater than the value in the 6th colu...
I have a workbook That is open at the beginning of the day shift and stays open all day by a user inputting data every 5-10 minutes. I wanted to open this workbook and keep it open all day to...
