Office Software Forum
- Excel (9,842)
- Open Office (114)
- Outlook (647)
- PDF (334)
- PowerPoint (183)
- Word (2,189)
-
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...
-
How do I get my old inbox back? Solved/Closed
My computer had some network difficulty. After shutting down I noticed my Outlook Express inbox was empty. When browsing to my OE folder I see two i...
-
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...
-
My iPod won't let me use apps Closed
Hello, I got a brand new iPod touch 2nd generation as a gift for Christmas. I synced it with my mac and every song/video/app downloaded with no probl...
-
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, ...
-
SHORT CUT TO CAPS WHILE TYPING. Closed
Hi, I would kindly like to inquire whether it is possible to highlight a given group of words or sentences that are in small letters and turn them in...
-
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...
-
allow my outgoing mail Closed
Hello, I have tried 465 and 587 and 25 all do not allow my outgoing mail can some help me with my problem
-
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.
-
security code Closed
Hello, Please consider using the below codes in order to have the phone restored to factory settings and hence get the present difficulty expe...
-
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...