Hello, Please help me with below, I have 600 worksheets file, out of which i want to add only fiest column of all sheets in one master file and th...
Hello, I want to color my cell if one of few drop down list is picked for example: if appe or orange are getting picked, it needs to color it in gr...
i'm trying to create stock inventory by 3 userform in different worksheet is Stock Inwards, Outwards and Sales Return but i transfer qtys to last wor...
Hello, i am using excel for attendance card scanning, in that sheet i have applied v lookup formula for getting the employee name and other informa...
Hi All, I am not very good at excel, however I am looking for a solution for the following problem. There are two columns (Column A and Column B...
Hello Guys, I would like to know if there is a way to input a default value in a cell so that it can indicate the user about the information to ...
Hello Guys, I have a variable which contains some value. I would like to underline it before printing it into a cell. I have used the following lin...
Hello Guys, In Cell A1, the text is "abc" (Note that "abc" is underlined). If i choose cell B1 and apply a formula as "=A1", the cell B1 shows "ab...
Hello Guys, I would like to know if there is a way to concatenate a variable.formula and variable.value. I have written the following lines of...
Hello. I have converted pdf files into excel. So each pdf file presents sheets in a single workbook. Now the issue is I have around 100 sheets. But...
Hello, I'm expected to use PowerPivot extensively - meaning with complex data models. What would you recommand for a newbie who wants to learn?
Hello, I am trying to apply cond. format to a date colunm to change color according to todays date +30, +60, and +90...all being different color fi...
Hello, the prblem is that when i upgraded to office 10 then formate of dates are changed in some cells of the worksheets and whn i changed the forma...
Dear valuable members, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cell...
Hello, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cells(Rows.Cou...
hello, i need to search a variable in an existing workbook and then copy the name of the sheet in which it si contained and paste it against the varia...
WORKBOOK 1 Services ALL - contains columns A-F (a- Qtr, b-Locality, c-Date, d- first name, e- surname, f- Comments) I have a WORKBOOK 2 with work...
How to convert birthdate in text format in excel
I'm trying to automatically append any new data from one excel tab (ReportExport) to another tab (MappingTool) if the vlookup on the MappingTool tab i...
Hello, I created a macro (by recording) that looks at the names and picks them based on the full name. Is there a way to just use a wildcard? Instea...
Hi, I'm new in Excel, and what I'm trying to do is this: I want to make an entire sheet equal to another, except for one cell, so if I change somethi...
Hello, I have a recorded macro that picks specific values in a list and sorts them to display only ones with those values. What I would like to do ...
I cannot find a macro anywhere to change the find option from 'workbook' to 'sheet'? Any help greatly appreciated.
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" ...
DON'T MISS