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...
I have a workbook that has a tab for each week of the month. At the end I have a budget tab that I want certain information to auto populate into the ...
Hello, I am having trouble coming up with an Excel formula that will provide conditional highlighting to a cell whose corresponding cell is not fil...
Hello, I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column bas...
Hello, I have a workbook divided in 12 tabs (12 month), each tab have exactly the same charts and cells.In other words, each tab are copy paste from...
How can I write into a macro how to find a specific row and column from 2 input boxes? One input box identifies a number located in a row. The other...
I run a golf league excel program. I would like to place a golfers score into a specific row(golfer name) in a certain row(week). I would use an inp...
Hello, how to change the date format to 19-july-09 19.7.2009 23.04.2008 26.07.2010 System Configuration: Windows / Chrome 55.0.2883.87
Hi Guys, Can anyone help with a problem I have. I need to increase a cell count by 1 or 0.5 based on the fill colour of the cell. I am using the foll...
Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the d...
Hello, i have 50 Excel work Sheets named Probe 1, Probe 2, Probe 3.............Probe 50. Now i have another worksheet (called Tabelle 1) which has...
I have an Excel File with a tab named Ledger. I want to copy a row if it contains a specific word (Pets, Entertainment, Dry Cleaning, etc) and add th...
Hi, I am finding out solution on how I can make the Importrange formula continuous on the google spreadsheet. Currently, I am manually changing the ...
Hello, =IF(I20=0,0,IF(I20-M20-P20-'Rate '!$D$9
Hello, need a code to copy a column from one sheet to another based on the heading name
Hello, I have numbers in columns A through C that are input manually row by row, and column D provides a sum of each row's numbers and adds the prev...
Can someone please help me out with this? I am trying to create a macro that will: 1. Find the cell to the right of where there is an ‘AE’ in colum...
well here's to hoping someone can help, this is far beyond any ability that I have, so my apologies in advance! I have included a picture so that you...
sir i want show only a specific column on another sheet.for example i have A-Z column with data and i want to print only specific column means show da...
Hello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...
I have three columns related to the prices of equities. Column A is for the name of individual equity, Column B is for the individual equity price of ...
Im trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...
Master sheet if first tab in workbook containing following: Case # Case Name Open date Atty Destroy Box # All rows in numerical orde...
I am trying to create a macro that will: 1. Find the cell to the right of where there is an ‘AE’ in column B 2. Copy that cell (example: C1 (218453...
Hello, In the following macro, I don't want it to remember the number 100004 which is a number I scanned in after performing Control Find. I wan...
if i8 of worksheet a is yes then copy c8:e8 of worksheet a to worksheet b in location c8:e8
Hello, in column 1 i have entered one subject mark and in column 2 i have entered another subject marks , if both the subject marks are greater than...
Please help me out, an example of data I have on sheet two Name bio Chem phy lug John 40 60 50 20 Luke 70 50 30 77 Eric 80 90 89 60 I want to c...
an example of data I have on sheet two Name bio Chem phy lug John 40 60 50 20 Luke 70 50 30 77 Eric 80 90 89 60 I want to create a workbook per n...
Hi all, I have a problem with CSV files or with Excel, Excel only places quotes around certain fields, how do I force excel to save a CSV file with q...
i am looking after purchase dept. kindly send us formula that one column contains text"BUY" and i want paste some columns in other sheet. Means cell ...
Hello, I have a data sheet showing names , numbers and date of termination in different columns. I would like to copy the details of the members in ...
I have a data sheet showing names , numbers and date of termination in different columns. I would like to copy the details of the members in a row ,w...
HI, I NEED HELP WITH CREATING A FORMULA FOR A SPREAD SHEET. THE WORK BOOK HAS THREE SHEETS (UNITS, COMPONENTS, LOADLIST). IN THE UNITS SHEET SETS OF ...
I wish to populate $values in f14 by choosing a name in a drop down list located on the same worksheet Qty Unit Price Price YT004-Oscar Terr...