Hello,
I have users enter a four digit number on sheet2 cell I4, I need to take the left two digits and match it to a set of numbers located on sheet3 A80:A84, whichever number is closest, ...
I'm having difficulty converting a text string into a date, I want to be able to convert MMDDYYYY to MM/DD/YY, sounds easy but this is the format it's in:
11141969 = 11/14/1969
5311985 = 5...
hi - ive got the code to create a back up folder now (code below) but im not sure what the second part of the code does. if the computer is linked to a printer does it print out the the messag...
Hi
This part of the macro works but would like to quit excel and replace the existing file.
This is probably simple for you Excel gurus....but I haven't a clue.
Let's say I have a column.....
347
312
163
430
640
227
325
244
328
274
169
77
136
0
254
313
200
==...
I am trying to copy and paste a particular date/time from one excel file to another. The value in the first file is "4/12/2008 09:33" and it's displayed using a custom format (mm/dd/yyyy hh:m...
I have an Excel Workbook with multiple Worksheets. Each Worksheet has the data auto filtered. Is there a way that if I choose one Worksheet and choose one of the filters ("Yes" for example.) I...
I have a UserForm I use to input data in a sheet.
The userform has a frame with 3 option buttons that the value should populate column X. In the initialization of the form code I have this:
...
Hi all,
Can anyone suggest me a formula in the overview sheet. I was succeful in updating til 9 days in the overview sheet but got confused in 10+ column. I hop u wil understand once u ha...
This in continuation with this question
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23421058.html
Now I need to be able to capture the ro...
On a complex worksheet from our accountants, I am trying to identify where the current period is and then look for a specific column under that period and insert data based on that column. Wh...
I would like to add the sum of the number of bars (tasks) at the bottom of the generated graph. Just run the macro, and the spreadsheet generates a graph. I need the sum of the number of bars ...
Good Afternoon
I am looking to copy the contents of cells J8, S8, J15, J22 and S22 from a work book called Power into a workbook called Holder.
The code snippet is the current method I u...
I had a question which has been kindly answered by an expert on the site but i would now like to ask the question, is there a reason for setting the created objects to nothing at the end?
S...
I need to upgrade a workbook from Excel 2003 to 2007. It contains large amounts of VBA code to handle various funcitons such as creating small spreadsheets that are sent out to users who only ...
Hi
One of my colleages sometimes recive a attached invoice in Outlook. The invoice is a excel sheet but when he opens it, it takes about 30 sec and it is very slow to work in. Change font s...
see attached workbook and word document
Hi Experts
When the user clicks the Grey ADD/REMOVE Supplier buttons (ROW 4) the macro deletes and runs the code fine........when the user trys to ...
Hi,
I have copied and paste (embedded) an excel chart in Powerpoint. When double-clicking on the chart in powerpoint, I can see the file with the chart and the data etc. basically I can modi...
Hi Experts
How would you make the current macro delete on extra row......in addtion to its current functionality..
here is the VBA Code:
Private Sub CommandButton1_Click()
Dim ws As...
I am developing an error tracking report. This report looks at series of files and checks for various logic errors and when it finds an error it reports this along with the location of the pr...
I'd like to apply conditional foramtting with two colors as highlights. I'd like the highlight color to switch whenever the value in column A is different from A in the previous row. The goa...
I have a sheet filled with A2:N+lastrow
In column D are present many cells filled with value.
Now, i know the way :
for i to rng cell to step-1
delere entire row in in D are present "v...
When client goes to launch MS Excel, she automatically gets a Microsoft Visual Basic Run-time error '5': Invalid prcedure call or argument. When she clicks on Debug.. it opens up Visual Basic...
Hello Experts,
Getting stuck on an if (iserror formula:
if(iserror((SUM(B19/SUM(E19/D19+G19/F19+I19/H19+L19/K19+N19/M19+P19/O19+S19/R19+U19/T19+W19/V19+Y19)))," ",((SUM(B19/SUM(E19/D19+G...
One of the owners of my company had been working on an Excel document for a couple of hours. He has auto save enabled and said he could see it auto saving ever 10 minutes or so. He received ...
