Excel Forum
-
I want to validate the data format [Closed]
Hi I need to verify/validate the data in a column, it should be "AAAA-16-0001" format. If the data is not in the specified format, i need to have a...
-
automatilcally transfer to data to other spreadsheet [Closed]
Hello, I have one master sheet and 12 monthly sheets, I want to transfer the data from Master sheet to all the respective monthly sheet, automatical...
-
Excel formula query [Closed]
Hello, If I enter 1 in column A1 I want column C1 to equal the content of column C2 Configuration: iPad / Safari 9.0
-
Verify data format in all rows for a column [Closed]
Hello, I have 2 worksheets (sheet1, sheet2) which has about 50 columns each. The sheet has customer informations for the company for 2 different yea...
-
Transferring data between sheets [Closed]
Hello, Thanks in advance for reading my question. I am have two excel sheets. The first sheet contains the columns: first name, last name and i...
-
coloring line indicated the name, by the table where there is th [Closed]
Hello, I have four tables with four different colors, are 4 different categories of staff. First with font color blue Second with font color red...
-
Autofill based on filename in same/different folder. [Closed]
Hello, I'm looking for a way to pretty much automate part of my job, which is creating manhole sheets. In folder there are 10 files, each is calle...
-
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...
