Excel Forum
-
want to get some specific text from one sheet to another Closed
Hello I have some data in sheet 1 of 140 lines and have some name in coulmn b and have some reference data in column h And also have data in colu...
-
Data Transffering Closed
Good Morning. I am new to the forum thing so any help would be great. I am not sure if this is possible but I am looking to see if I can automatical...
-
copy values from a table to another tab Closed
Hello, I have an excel spreadsheet. How can I copy values from a table to another tab by placing an "x" in the right column. I only want th...
-
How To number Convert In to Word In Excel Closed
Hello, Configuration: Windows 8 / Chrome 37.0.2062.120 How To number Convert In to Word In Excel.... PlZ Say me Only totaly Formula .....
-
Drag Formula Horizontally with Macro Closed
Hello, Just new to Excel. I have a problem and request if anyone can help me out. I recorded a macro to paste column names in a formatted tab...
-
Date format Closed
Hello, Hello, I have changed the date format to dd/mm/yy. I tried to enter 9th of january as 09/01/15. whn i used filter option it showi...
-
Trying to have select info automatically copy to a new sheet Closed
Hello, I am reworking our cash sheet at my new job. I have been learning more about excel in the last few weeks than I have in many years prior. ...
-
get max value Closed
Col A Col B Col C Row 1 A A 110 Row 2 A A 200 Row 3 C C 199 Row 4 A A 92 Row 5 C C 85 Row 6 D D 172 Row 7 D D 150 Row 8 E E 177 Row 9 E E 199...
-
VBA, Move specific cells to another page Closed
Hi, I have one page for every month. On each page there will be button that runs the VBA code. The VBA code shall look for text in cells O7:037 in the...
-
copying unlimited data from on excel to another excel.. Closed
Hi All, I want to copy all the data from one excel sheet to another excel on load event (when I open) of destination excel. could you please hel...
-
Lists and If Formula Closed
Hi there, Bit of a strange request: I am attempting to create a costing list and require a series of lists on an If formula. Basically if B6 con...
-
Excel Formula for - Number to Text Closed
Hello, I want to know how to convert any number into Text format ( Indian Rs. INR) in Excel without using of coding (Macro). Its like the uses of ...
-
setting due dates Closed
I already have half of the formula needed.. d2=text, leave it blank =if(istext(D2),"","") I need a formula for this: d2=date, then add 14 day...
-
Looking at one cell if contains number returning text... Closed
Hello, I am trying to figure out a way to streamline a huge excel spreadsheet we have at work. I am trying to return text in a cell if there is...
-
Copy across conditional Formats Closed
Hello All ok I have 20 colomns of data the first 2 rows contain the upper and lower limits(all of which are different) the following 3 rows ...
-
Compare two sheets based on a common ID in both sheets in col A Solved/Closed
Greetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...
-
Vlookup for mutiple shel Closed
Hi , I have requirement as below There is excel sheet 1 with column A with some text say xxx, yyy , xyz and coresponding numeric values in colum...
-
Transferring Data Closed
I am not sure if this is possible but I am looking to see if I can automatically get data I enter on a spreadsheet to transfer to the appropriate tab ...
-
VBA to assign a counter to a constant Closed
Can somebody provide me the VBA code for the following samples Before VBA code A B B A C A C A After VBA code 1A 1B 2B 2A 1C 3A 2C 4...
-
How to Convert DD/MM/YYYY to MM/DD/YYYY Closed
Hi All, Kindly help to convert DD/MM/YYYY to MM/DD/YYYY for the following examples. Thanks in advance, 19/08/2014 13/08/2014 13/08/2014 4/08...
-
copy and paste macro Closed
hello, I am new to the vba programming for excel 2010 but what I have been able to ascertain has helped me tremendously at work, however I am having ...
-
Converting numbers to alpha Closed
I need a simple way to convert a price to an alpha code, for instance Graystoke = 1,2,3,4,5,6,7,8,9,0 so if a price is $5.66 it appears as s.tt I n...
-
Percentage Work Solved/Closed
Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...
-
Formula for something that is probably easy Closed
This is for a project I'm working on and it's just trying to figure out how many variations there are going to be, so I'll ask using a basic setup. ...
-
I need a macro please Closed
Hello, I have 70,000 lines of data. I need to make 1400 files of 50 lines each from the original 70,000. So I'm hoping there is a macro that can p...
-
Recurring weekly date Closed
Hi, I'm wanting to set up a weekly review date for a number of rows on a spreadsheet. Each row has a different start date. I've tried WORKDAY.INTL wit...
-
Text label and value if value in other worksheet is > 0 Solved/Closed
Hello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...
-
copy from previous sheets Closed
'd like to know if there's some way to automate this process, such that if I duplicate a sheet, it will update its references to the previous sheet in...
-
copy and paste rows from one sheet to another by their count Closed
Hello, Using VBA how to copy and paste rows from one sheet to another by their count. Please help me out. Configuration: Windows 7 / Chr...
-
conditional formatting based on other conditional formatting Closed
I have several coloumns in a spreadsheet, 3 of which which contain dates, and these have conditional formatting to show if that date has expired or is...
-
Question with IF Function Closed
Hello, I was wondering, if I have for example in C2, C3, C4 the next info: "Tableta Onda V989 Allwinner A80 Octa Core 9.7 Inch Sistem Operare A...
-
about auto change row hight Closed
when I select any cell I want that excel auto change row hight to 30 of related row and when i select another cell previous cell(row) will retur...
-
Auto-Fill Excel Columns Closed
Hello friends, I am new to Excel. Got a problem and request if anyone has a solution to this. I recorded a macro to paste column names in a f...
-
copy rows and insert nth times then edit cells Closed
Hello, i need a VBA macro to do the following i have a variant number of rows, i want to copy and then insert the row n times depend on a value, ...
-
Take Reference from previous sheet automatically Closed
Hello, I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i...
-
Auto fill columns Closed
Hi, Just new to Excel. I recorded a macro to paste column names in a formatted table and want the formula in first cell to be applied automatical...
-
Excel - To generate unique ID Solved
Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...
-
decrease the value first by 10% and then increase the value by 5 Closed
I want to decrease the value first by 10% and then increase the value by 5%. What is the formula in Ms excel.
-
I need a macro please Solved/Closed
Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...
-
trying to base format on date in cells Closed
Good morning all, I have a worksheet that formats the cell containing the last date an item was issued when it is within 30, 60 or 90 days of ...
-
Want to add to Excel Macro, unsure how to do what I want Closed
Hello, I have the following Excel Macro that counts the amount of times a specific campaign value is present in a column. I would like to add on to th...
-
Excel using date range and formula on separate sheets Closed
I'm creating a bank register with the dates in column A. Values are in columns C and D. The title of my first page is 'Register' What I'm trying ...
-
Copy daily cost entries into the particular ledgers Solved/Closed
Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...
-
Brijesh Parmar Closed
Hello, how to count job dates for in column if dates are repeated. report no Date 5462 21.12.14 5463 22.12.14 10134 21.12.14 20354 22.12.14...
-
Need MSExcel 2007 Formula Closed
Hello, Masters of Excel. I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief. T...
-
Change General data into date format Closed
Hello, I have a date format in excel like 28/04/2014 00:00:00. I am unable to convert into date format. if i enter formula like date(A1) it is s...
-
Excel cell equal another cell only if its a certain percentage Closed
Hello, I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its ...
-
Excel 2010 format rows with a related cells rule based formattin Closed
I have a worksheet that formats the cell containing the last date an item was issued when it is within 30, 60 or 90 days of the annual issue date. Ho...
-
I need help, a macro that will filter, copy, and then paste. Closed
Hello, Hi there, thank you for opening this. I really need some help. I began working at a hotel and lets just say that they need some help. I've ...
-
A macro to copy data into new worksheets Closed
Hello, I am looking to write a macro to copy information in rows, and paste them into new worksheets by columns e.g DataSheet: Name¦ Country¦ City...