Robuta

Hello, I would like to import a long list of photos into a spread sheet using excell 2003 to make a product catalog. in column F I have the path to the photo...

Hi, Is there any way I can debug the sentence highlighted in yellow ? Thanks!...

Hi. Thanks for welcoming me to this forum. I have a problem and I am hoping someone here can help me. The problem is as follows: I have 2 worksheets. There are...

Questions and answers about Microsoft Excel

Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007...

I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours (7 AM until 1...

Hi There, my excel has been doing some funny things lately. 1. When I copy a formula from one worksheet to another, the actual formula does not copy, just the...

Hello, I would need your help to create a notification on excel. I've got a row of date's and when the date is 90 days prior to the expiry date on another cell...

Best answer: In conditional format for A1, you can write =COUNTIF(B2:J2,"Yes")>0...

Best answer: It will delete duplicate row (when item and price is same) and will delete the lower prices If ActiveSheet.AutoFilterMode Then Cells.Select...

=IF(B3="",09-01-2014,)*DATE(YEAR(B3)+G3,MONTH(B3),DAY(B3)) This is my failed furmula. I am trying to write a formula that will take the date in B3 and add 5...

Hello, I'm trying to create a formula if I input an age range ex. 17-24 in one column then write a price, if another age range is entered ex. 25-29 then write...

Best answer: Hi Zonda, So basically you are asking how to nest to IF functions, right? =IF(T1>T5,U5,IF(T1>T4,U4)) Best regards, Trowa...

Hello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cell. Say A1 I...

Hello, please convert 12.01.2015 into words System Configuration: System Configuration: Windows / Chrome 55.0.2883.87...

Hello, Hello, I have a project and I am using drop down buttons (by using validation). How can I get the arrow to stay there even if the cell is not selected....

Hello, I am looking for some help, I am wanting my workbook to auto create a new sheet at the begging of every month and that when it makes the new sheet that...

Best answer: Hi before pasting to a new sheet, just put the row and column number to variables and after pasting retrieve them...

Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with its formulas...

Addressing contemporary challenges ranging from community-based development to climate action, AUC faculty and students from various disciplines actively...

Hi, I need a macro that create some new file (txt or xls it doesen't matter) starting from an existing xls. The existing xls named "Arretrati" has data from...

Hello, Im trying to conditionally format the results in I19:I44 for all duplicates although I want the first one to be an exception. How do I specify the...

Hello, Please, kindly send me how to use opera mini on my laptop to browse for free. This is because I need it for my project research work. I will appreciate...

Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a prompt instruction...

Best answer: NOT CLEAR. If URL is in A1 . the formula in an empty cell =right(a1,4) will give you the four numbers ....

Hi, I need a formula to sum the values in a column but only for the cells in the next column that have a specific value. In my case I have range of rainfall...

A progressive international conference in Cleveland, Ohio, this fall will explore how cutting-edge innovators and forward-thinking leaders are moving ...

I am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after...

Hello, I need help copying the names from the master cell (A), if the other cell's (B) given names exist from the master cell, then copy to next cell (C)....

Hello, Can you help me with this data. What formula can I use? If 18:00 to 18:59 = 1 If 19:00 to 19:59 = 2 If 19:00 to 19:59 = 3 If 20:00 to 20:59 = 4...

Hi thanks for getting back to me. I think my brain may be a little frazzled but I could not get it to work. Also I may not have explained what I was trying to...

Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have sheet 1 that i...

Best answer: Option Explicit Sub GLLoadDataGenerator() 'Write GL Test Data to a tab delimited .TXT file Dim NumberofRecords As Variant, i As Variant Dim myPath...

Hi, I need a help to match values in a column from other two columns. I have two columns with some values on them. I have another column [third] with some more...

Hello, I have a worksheet with a several columns (example): PP DR MM SS 5 3 2 7 4 9 2 1 2 9 4 4 I want to create a formula in another worksheet that finds and...

Hello guys! I have been writing a vba code for a while and I cant find the mistake that I am making... I have a big table and I am comparing the values between...

Hi folks, Recently started working on vba's and am a new user in this forum. I need help with 3 issues I have in a vba and if possible ASAP. 1. Delete first...

Hello, Please help me how to copy one data row from one sheet to another. Here's the link of the screenshot:...

Hello, in VBA, I want to do conditional formatting of cells in a column with below background & font colours. Below 25: (RED Background-RGB-255-199-206)...

WINDOWS 7 EXCEL 2007 Hello, I would like to make a macro that would convert the data below to (See-Below) LIFETIME RECORD STARTS WINS 2NDS 3RDS WINNINGS...

Hello, I would be very grateful if someone can help me in the following issue. I have excel sheet with almost 300 rows. One of the columns I fill it through...

In Word 2003 I had a macro and put it on toobar to select table row, copy it, paste it so I got a new row below current one, in a flash. Highly repetetive...

I am using the following code: Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show UserForm1.PrintForm End Sub I can show all of the...

Best answer: sample trivial data sheet1 enter A1 1 a2 2 highlight A1:a2 and drag down upto about 108 rows (more ok) it will 1,2,3,4,5, etc copy sheet1 data in...

Hello, I have a spreadsheet (d2:d7) with 2012 prices in column D2 and 2013 prices in column D3 for the same product...what i want is if D2 is bigger than D3...

Best answer: Just replace the Oz with millimeters ......................... or you want something else ...........

Hello, i have an excell book open with multipule sheets. the 1st sheet has all the master info, the other sheets are cells for production. on the master sheet...

Hello everyone, I'm new to the forum and VBA and would like to thank you in advance for your assistance. I have received a spreadsheet that contains several...

Best answer: Hello Amanda, There are a number of ways of doing what you would like but just so that we are all on the same page, could you please upload a...

Hello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the run button....

Hello, I have two excel sheets. A and B A has two columns col1 ,col2 B has two columns col1 and col3 i want create new sheet which has col1 , col2, col3.. how...

Respected Sir/Madam, This is regarding a query that i have in MsEXCEL. I would like to know is there any formula or script so that i can get the below output...

Best answer: hey there, try to see the help on the forum abour macros you might be able to do it through macros...

Hello, My name is amit and i am having problem with creating a excel sheet which has three columns stating date , service and amount. and now i want to buil it...

Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than using the pulldown) it...

Hi, is it possible to get output as below where original in sheet1 and sheet2 will added 1 then in sheet3 it will sum the qty which previous qty is 2 then we...

Hello, Can somebody help me out with this objective.I would like to have the Staff Number which I'd search and found base on the code below to have the person...

Best answer: Create a new column for the results wherever you want. Use vlookup - =VLOOKUP(A19,E19:F31,2,FALSE) then copy down to all the appropriate cells....

Microsoft Excel courses, excel forum, excel help, excel tutorials, free macros, and more.

Best answer: conditional format all possible rows...

Accounting professionals who believe in working smart, not hard!

I need to count column C if cell equals "medicare" only on the same line column A has text. Column a is made up of names. I just don't need it to count...

Hello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly copy and...

Hello, please advise on the code for adding a certain number of rows in the excel data at a change in value. I want to add 12 blank rows between the data...

Hello friends, Please help me for following issue. I have created an attendance sheet in excel having 12 sheets (for all months like Jan, Feb, etc). in each...

Can somebody provide me the VBA code for the following samples Before VBA code A B B A C A C A After VBA code 1A 1B 2B 2A 1C 3A 2C 4A Thanks...

Hello, can anyone help me determine a formula that will give me a percentage? If N11 is 2500 and I11 is 84, I need a formula that will help me determine what...

Hello, I have about 100 sheets with different names in my excel document. I am trying to extract two numbers for each sheet into a summary sheet. I also want...

Hi There. I've spent about 4 hours trying to work out the formula or what I'm doing wrong to no avail, please help me before I lose my mind. I need to bold a...

Best answer: I spent a lot of time trying to figure this out and finally got the correct Macro. All you have to do is highlight the information in the column...

Hello, I have two columns of IDs. Column A is the bigger of the two. Column B has IDs that are part of Column A. How to produce all IDs that are not in Column...

Hi I am writing a spreadsheet for my ward for TCI list which has admissions, discharges and transfers. I want to be able to save then clear the contents of the...

Hello, I have a file with 42 worksheets, all the same format (kind of "entry screens"). I need to create a summary table listing the data from all of these...

Hello, I need a macro to do the following: Look for the word prod in column C (500 rows). When it finds it, replace it with 814, 815,816 - three rows replace 1...

Hello, I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each worksheet has...

Best answer: Hello QuertyAlex, Perhaps the following code may help:- Sub Transfer() Dim ws As Worksheet Application.ScreenUpdating = False...

Hello, Is there an Excel Formula that can be used for the following: If Column F = Name and Column G and/or Column H Does NOT = Name or is NOT Blank, then...

Hello, I am looking for a small help. I have 2 columns A and B, I have text written in A and numbers in % in B. Based on value in B, i want to add color...

Hello, I want my macro to 1) create a new sheet and 2) copy data from another sheet onto the new sheet. For some reason it (my macro) will create the sheet but...

Hello, labels that must have same V33j on all as well as another group of numbers usually 3 or 4more that would increase or advance by 1 number as each label...

Hi I have a spreadsheet that is entered into daily a list of actions taken in a department. This needs to be printed weekly and displayed. Obviously this will...