The discussions
Copy query from all worksheets of same workbook
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...
Conditional formatting based on multiple values
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...
Change cell color based on another column
SolvedHi 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...
Default ´value in a cell for user to fill it
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 ...
Underlining a value in a variable
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...
Incorporating the text formating when formula in used
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...
Concatenating a variable.formula and variable.value
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...
Transfer data between excel sheets
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...
Cond format for date column
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...
In some cells dates format are changed
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...
Excel vba to work on all workbooks - please help.
Dear valuable members, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cell...
Wildcards or values in a macro?
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...
How to make an excel sheet equal to another
SolvedHi, 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...
Macro to change the find option from 'workbook' to 'sheet'
I cannot find a macro anywhere to change the find option from 'workbook' to 'sheet'? Any help greatly appreciated.
Contain word, return value
Hello, I would like some help. cell a1 contains London - abc cell a2 contains Tokyo - abcd cell a3 contains Singapore - abcde I would like...
Entering formulas for a master sheet
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 ...
Macro for creating new workbooks from existing source file(excel
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 ...
If/then question
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. ...
How to copy and paste entire rows into another worksheet automat
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 ...
Conditional formatting expert needed! comparing 2 arrays.
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... ...
Copy paste rename based on cell value
SolvedHello 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...
Copy data from one sheet to a new workbook and save loop
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...
What function do i use to pull data prior to a certain date?
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...
Changing date format into a text format
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...
Auto fill
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...
Autocopy selected content from 1 sheet to another sheet
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 ...
Searching for values and creating a list
SolvedHi 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...
Vba assistance - excel
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...
Dtabase building copy form master sheet to multiple other sheets
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...
Copy info from multiple worksheets to new worksheet, no macro
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...
How to connect db through input from userform
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...
Ms excel match an amount
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...
Copying data/table from one sheet to other
Hello, I have copied data from one sheet to another. When I deleted from first sheet this is automatically deleted from seecond sheet Configura...
Multi-worksheet recording
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...
Error in .selecteditems during file picking
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...
Name values
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 ...
Need to seperate data from one cell into multiple.
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...
Add data from one sheet to multiple sheet
ClosedHello, I have one concern that I have to split one sheet data into multiples sheets. Based on condition as below. Main Sheet:"Employeedata" ...
How to find value from a column with unique random values
SolvedHello, 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...
Creating macros in excel
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...
Moving a row in excel
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...
Macro for extracting row information into a new tab
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 ...
Generating and logging jobsheets
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...
Auto generate workwheet from a list and from a template workshee
SolvedHello 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...
Excel - a macro to rename existing worksheets based on a list
SolvedI 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 ...
Inserting a picture with path name in a variable
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...
Inserting image in a particular cell in vba
SolvedHello 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...
Merge cell
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...
Autoploting (master to other sheets)
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...
