I have a problem in my Excel 2007 worksheet. When I highlight all my cells and sort, all my rows get jumbled up. I think my problem has to do with one of my cells containing paragraph long tex...
I have some code which apparenlty keeps 2 cells in synchronisation between 2 worksheets; so, if I change the value of cell A1 on sheet1, cell A1 on sheet2 will update with the same value. It ...
Hi
A couple of years ago some v helpful people on here helped me to create a form on my workbook with an accept and reject button on it. When the accept button was pressed this then led to al...
Hi,
I am looking for a way to build a spreadsheet or access report that will return data based on the current logged on users ID. We need a secure way of displaying vacation data for an in...
Hello,
In Excel Using VB Unprotect 5 tabs, Copy and Move them to new File and Reprotect those Tabs from the previous file.. Thanks in advance...
Best Regads,
AY
Hi,
In column W I have a bunch of values listed. There could be repeating values too. In column I have values that could be repeated and sometimes will match whats in column W. I need a ...
hello to the expert again on this issue,
I have a connection that work for load data, addnew & edit but not for delete.
see attached error file
Dim sql As String
Dim DBcn As ADODB.Conn...
Hi Experts,
Is there a way to call udfs saved in personal.xls without having to use the whole prefix:
=personal.xls!myudf(parameters)
Thanks,
Thomas
Hi there,
I have an if-statment solution I need corrected please. The If statement for your information is in cell I6
=IF(E6>0,E6*52)=IF(F6>0,F6*12)=IF(G6>0,G6*4)=IF(H6>0,H6*1),""))))
What...
I need to make a dynamic range chart that allows me to select between three types of data:
1. Date
2. Site
3. A value
Ok, I can clean up my excel spreadsheet so the data imports with nor problems as long as I leave the Databe fields as F1. F2, F3 and so on. Once I change the filed names to what they really a...
What is the formula to do lookup using the header and Row label with Index and Match. I am using excel 2007.
Hi,
I am companring two spreadsheets in excel. the only matching column I have is "Name" column. The problem is there may be mismatch in names for eg. Prem Kripalani may be typed as kripalani...
I would like to be able to find out the path of the Excel program that is running the macro. Is there a command in the VBA to do this?
In the attached spreadsheet i Have two sheets in the first one i have highlighted the
price of fuel per week in california
$4.964
$5.026
$5.001
$4.928
$4.922
$4.969
$4.99...
Hi,
My staff are currently using a excel sheet to eneter data and they need to obtain ref numbers to each batch of work they do.
Currently I provide them with numbers and they enter the ...
Dear experts,
I have an array as follows:
DATE T_START T_END HOURS ORDER NUMBER EMPLOYEE
12.07.2008 08:00 12:00 4 200803120-0...
My question regards a process I am trying to develop for an excercise that must be performed 3-25 times per day. Basically we track approx 2200 stock using Excel's RTD functionality. At spor...
I currently have a project that requires the use of Excel Workbooks to be sent to employees to work from. Currently I am protecting the worksheets from being manipulated, however, the employe...
I use the code below code to build a combined range of values looking in all B columns of all sheets except the one named "Master". However if you look at this line :
Sheets("MASTER").Cells(i...
Hi,
I was hoping someone could write a quick macro for Excel 2007 to perform the following function; 'Copy the first whole word from the data values in column A and paste it into column B'....
Hi experts,
I have an excel document with a column of sensitive data (11 digit number). To declassify the document, i need to replace twe last to digits of each number in the column with an...
I have a question that I have been trying to google all night. We have several offices that have put their software inventory lists up on our SharePoint site and I am trying to clean it up a l...
I'm representing an entire column in a formula like $A:$A. But in A1, I have the name of the column so I don't want to include that in my formula. The only thing I can think of is doing $A2:$A...
Hello again,
I now need to go from 1 to 300 with this same repeating format (on every 7th row, the number should jump) and I can't figure out what the formula is doing to make it work. Tha...
