GOod am, i just want to ask how will i create a formula as follows on the same excel, 1. subtracting the date of admission to the current date 2....
Hello, please convert 12.01.2015 into words System Configuration: System Configuration: Windows / Chrome 55.0.2883.87
Hi All, Am new to macro, i have an excell file in which column A is having dates with formula....for example cell A1 is stored with 01/1/2017 and c...
Hello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...
Hello, I have a holiday home that I rent out and I am making a spreadsheet to control bookings, I have it set up so that the entry date and departur...
Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...
B2=Supermarket , C2=30$ B3=Fuel, C3=20$ B4=Fuel, C4=50$ if Bs="Fuel", i want to add the numbers in the adjacents cells together. but only if they c...
Hello, I have used 602 Office suite for several years and now I have 10 years of spread sheets that I cannot open with windows 10. Do I have to purch...
Hello, I want to transfer formulas only from one spreadsheet to another but I get all the data I even specify paste formulas
Hi All, I have very basic skills in excel - I'm trying to work through some data, and I have a long string of text - which has a common word "Naam:" ...
Hello, if cell contains text and date also for e.g 02-01-2017_Address Verified / 30/12/2016-Number busy / 28/12 Number busy. like this their no pro...
Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...
Hello, I'm trying to create a formula which would give me the total amount sold. So for example I'm trying to get a formula which would say if column...
how do I link text information from one worksheet to another?
desktop reminder with excel sheet and formula need please support.
Hello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...
Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
I cannot change the text colour in a spreadsheet and the cell borders do not print out although they are there on screen. I have the CD for Office Ho...
Hello, I am trying to find the sum of some numbers in a column in a maxro book. I make the formula of sum and the sum appears 0. In fakt, althout th...
Hello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...
My VBA is a bit rusty so hopefully I can get a little help. There is a report I need to create every week that I want to automate a bit. I have a ...
Hello, I have a spreadsheet with columns that have targets and results next to each other. If the target is reached (=) or exceeded (>) I want the r...
Hello, I am trying to collect budget request from different departments and if all approvals fields are Approved, I want all data to be collected in...
Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...
Hello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...
Hi, I want to combine dates from multiple cells into a single cell in the same row, with the result displayed in the format: dd/mmmm/yyyyy, dd/mmm...
Hello, I am trying to find out a formula to use. I have a lot of names and dates. and another tap has names with days worked. I am trying to find ...
Hello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...
I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell A - i will enter 123 cell B - will have result of Biju, Daisy, Mah...
I have a workbook with spread sheets wk End 1-15-2017, wk End 1-22-2017, wk End 1-29-2017 Looking for a way to have the row that is unfinished to mov...
I'm trying to figure out how to calculate a rate of payment based on two sets of date ranges: 3 days or less - $15 4 days or more -$10 How would I ...
Hello, I need the code which will create a new sheet in existing workbook if data are entered in a row. data generating should be in the format whic...
Hello, I usually search google for my excel questions, but this one is tricky! It may even be beyond the scope of Excel. In a nut shell, I'm design...
Hello, I'm curious if anyone knows of a way to have a master sheet/summary sheet only update with the most recent data entered on a different sheet?...
Hello, I need a excel Macro which contains separate sheets for each day in a month. By running the macro there should be auto sheets created in wor...
Good Day partners How do I copy files from Google Spreadsheet to Excell, or How do I merger files from Google SPreadsheets
Hi everyone, this is my first post so I hope I'll explain myself clearly! I have a spreadsheet with the following content: (Column I (in yel...
Hello, I need a formula that IF there is any data/text in the cell it will EQUAL another cell, BUT... I want the cell with the formula to display th...
Hello, Wanting to test row of numbers to a certain number and return pass, fail, or blank. =IF(AND(X7
Hello, if i have 2 sheets and i want to add 2 cells of the 1st sheet to the other one -- only if another 3rd cells has the text "Done" what should i...
Hello sir, . But its can't working why i dont know! Please find my attachedments. Regards, Bicky Das, bickydas00@gmail.com
Hello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...
Hi! I have this visual sheet (pic attached), and I would like to create a macro that would insert a picture from a folder on my computer in the cell ...
I have a workbook that we create service tickets from. The main sheet is used to enter information about the job. When complete I have a button that n...
Hello, I have a condition in my file such that =IF(C5=C4,D3+1,D5=1 ->>>> trying to add this andD4= D3+1) Basically this what I want to happen C...
Hi everyone! I'm trying to finish my financial sheet to work out where I am for this year. I need it so that when I type in the word "yes", It shows t...
Hello, sir Plz notice the formula =if(cell address >55%,"1st",if(cell address >50%,"2nd",if(cell address >45%,"3rd","Fall"))) is the correct answer? ...
Hello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...
Hi Everyone, I'm new to this forum. Thanks for the help and advise in advance. I'm a beginner to VBA. I have created a custom Quick Access Tool bar ...
hello, I would appreciate help on the following problem :- If cell R1equals any number in the range 12 to 31 then I wish cell b1 to equal 2. Is ther...
DON'T MISS