Excel Forum
-
Copy query from all worksheets of same workbook [Closed]
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 [Closed]
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 NEED A HELP IN VBA CODE [Closed]
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...
-
Attendance sheet [Closed]
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...
-
Change cell color based on another column [Solved/Closed]
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...
-
Default ´Value in a Cell for User to fill it [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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...
-
Best resources to learn about PowerPivot? [Solved/Closed]
Hello, I'm expected to use PowerPivot extensively - meaning with complex data models. What would you recommand for a newbie who wants to learn?
-
cond format for date column [Closed]
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 [Closed]
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. [Closed]
Dear valuable members, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cell...
-
Excel vba to work on ALL workbooks [Closed]
Hello, I have this code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Lastrow = ActiveSheet.Cells(Rows.Cou...
-
Find variable and paste name of sheet in another workbook [Closed]
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...
-
transfer specific data on to a second work sheet [Closed]
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...
-
covert the date format into text in excel [Closed]
How to convert birthdate in text format in excel
-
Append & Copy Data Automatically from Tab A to Tab B [Closed]
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...
-
Wildcards or values in a macro? [Closed]
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 [Solved/Closed]
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...
-
Macro to copy a sheet to a new sheet after a filter and sort [Closed]
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 ...
-
Macro to change the find option from 'workbook' to 'sheet' [Closed]
I cannot find a macro anywhere to change the find option from 'workbook' to 'sheet'? Any help greatly appreciated.
-
contain word, return value [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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. [Closed]
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 [Solved/Closed]
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...
-
Copy data from one sheet to a new workbook and save loop [Closed]
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? [Closed]
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 [Closed]
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 [Closed]
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...
-
can not open [Closed]
Hello, excel found unreadable content in 7iBfgO78r.894p do you want to recover the contents of this workbook? please i need solution how to ...
-
Autocopy selected content from 1 sheet to another sheet [Closed]
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 [Solved/Closed]
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...
-
how to save file in different name from folder by macro [Closed]
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...
-
Expenses tables [Closed]
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...
-
VBA Assistance - Excel [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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. [Closed]
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 [Closed]
Hello, I have one concern that I have to split one sheet data into multiples sheets. Based on condition as below. Main Sheet:"Employeedata" ...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire