Hello, I would like some help. cell a1 contains London - abc cell a2 contains Tokyo - abcd cell a3 contains Singapore - abcde I would like...
I want to track who has borrowed materials from a library. I have each resource on a separate sheet with information about the date borrowed, contact ...
Please provide the macro code for the following data source - 1 siddhesh 100000 09/02/1989 2 amol 100000 08/01/1991 3 siddhesh 150000 ...
Hello, If a cell contains any text except for one specific word, I want to return that exact text. If a cell is empty I want to return nothing. ...
Hi! I need to know the code I use to copy and paste entire rows into another worksheet automatically. The conditional value is in column A and row ...
Hi all, I apologize for the vague title. but I could not think of a way to properly explain the problem in a single line with so few characters... ...
Hello I have a worksheet named template. I need a VBA code which would copy "template" automatically into a new worksheet and rename the new wor...
Hello, I have a sheet with multiple values which I want to copy into a new workbook, in a certain format, save as a certain name and then repeat f...
Hello, I have a database that is organized quarterly. I would like to save myself from having to manually move data onto a new sheet after 3 month...
Hello, I need to change a date format like 2/1/16 into a text number formatted like this 02/01/2016 or like this 020116? Is there a way to do thi...
Hi, May you help me on my excel using vba. I want to use the AUTO FILL function in excel to automatically fill different rows whenever the other row...
Hello, excel found unreadable content in 7iBfgO78r.894p do you want to recover the contents of this workbook? please i need solution how to ...
Hello, I am creating a little database and I have several sheets called "Main", "study1", "study 2" and "study 3' I am only entering data into ...
Hi there, I hope you can help me, so far I have managed to create a formula which searches a range of data (SKU’s) and returns a count of the occurr...
i want to save a workbook from a worksheet in different folder every time i run a solver a solution is created that workbook file should be saved in...
Hello, I am trying to build a table that lets me compare expenses over a period of 6 months in a small area. What I want to do, is input transactio...
Hi, I could really use some help. I currently run a monthly exercise through excel which is a bit laborious and time consuming due to the volume of...
Hi, I am after some help. A bit new to Excel and only have basic skills. I am currently setting a database up and need the data on my main workshe...
Hello, I need to use conditional formatting/formulas to import cells of a certain value from multiple worksheets, into a new worksheet. I don't th...
Hello, i need to connect to db server with the inputs from the userform. here is the code. Please correct/add if any. user = Val(REPORT.TextBox...
hi, In Ms Excel Work book, I need to match an amount of more than one presented cheqs , which are cleared today, I want to lookup the exact total of...
Hello, I have copied data from one sheet to another. When I deleted from first sheet this is automatically deleted from seecond sheet Configura...
Hey gang, Long time reader, first time poster. I'm trying to create an excel file to help me stay organized. I know how to pull data from one wor...
Hello Guys, I am trying to save a file path in a variable using .SelectedItems but the code is showing "Runtime Error 450". Kindly help me by rec...
Hi I have a sheet of people's names in C8 : C59 and D8 : D59. I would like a formula that can check these ranges and if it sees a specific name it ...
Hello, I want to seperate and pull numbers from a paragraph in one cell. Eg: Temp: 35, rain: 2.56, humidity: 80% I want to seperate into se...
Hello, I have one concern that I have to split one sheet data into multiples sheets. Based on condition as below. Main Sheet:"Employeedata" ...
Hello, I need a formula that can get me a value from a column that has unique values and return another cell from that row, can someone help me? e...
I need to create a macro in Excel to produce values with two demical places and a dollar sign in the personal macro workbook. I have no idea how to d...
Hello, I need to move a row completely from spreadsheet 1 to Spreadsheet 2, which has same rows and columns. Can anyone explain me step-by- step a...
Hello I am in need of a macro that will find a name in one column and copy the entire row into a new tab on the same work book. Ex. For every ...
Hi, Is there a way of worksheets being generated by end users (for example, workers filling in a worksheet which generates the worksheet number seq...
Hello, Suppose 5 students mark distribition is given bellow CODE STUDENT NAME SUBJECT: ENG 1 BAN 2 G.MATH ENG 2 TOTAL ...
Hello, I wonder if anyone out there can help, since upgrading (?) to Windows 10, cell borders do not print and the cell colour fill does not work. I a...
Hello All, At the moment, I found out how to auto generate worksheet from a list. However, the generated ones are blank worksheets. May I ask ho...
Since upgrading (?) to Windows 10, cell borders do not print. I also cannot change the text colour. Spreadsheets built before the update also have ...
I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just renumber ...
Hello Guys, I am getting an "Error 1004: unable to get insert property of Picture class" with the following code. Looking forward for your guidan...
Hello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this...
Hello, How to create new excel worksheet in a same workbook and names of sheets should be same like form1,form2,form3....... Configuration: W...
Hello, What if the compared cell is a merged cell. Example, comparing the values in column C with the merged cell values in Column A, expectin...
Hello, To find position class of the student in Mark card
Hello, I have a workbook with three tabs. I would like to create a macro for a command button that will create a duplicate workbook named "Current...
Hello, I have a master file for all the transactions in one financial year. This file currently has 4 sheets: EGC,SSM,RSL,MF. The first three are...
Hi all, I'm a new comer here, but looking forwards to learning and helping others!. I am trying to create a macro that will: 1. create a new s...
Hello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set of En...
Hello, I am trying to add a picture to an inventory list. It is made to just write the item code and the details would be generated into other field...
Hello, Hello, Example, comparing the values in column C with the merged cell values in Column A, expecting the result of the values from col...
Hello, Is there a way for me to have the Date, time (if the box says YES) next to someone's name? http://imgur.com/a/SYpcV For example if s...
Hello, I am a beginner at Excel. Trying to figure out formula for: IF DATE in column A is greater than DATE in column B, highlight. Configur...