I am using Cell 2 and cell 3 of Column A Column B and Column C Column B is the Profit % and Column C is the Selling Price cell 2 of column A is my **search box** where I want to enter Selling Price. Presently, with the help of lookup formula, When I entered the Cost Price in search box, the relevant cell which matches the value in column C is highlited in Red Text. which is OK. Now I want the excel formula with the help of which the value in Column B, (corresponding to the highlighted text …

Member Avatar
Member Avatar
+0 forum 1

Several people have asked how to export data to Excel. This code snippet shows how to export the data from a listview in details mode to a new Excel spreadsheet. Take note of the comments in the header to avoid having orphaned Excel.exe tasks eat up your system memory.

Member Avatar
Member Avatar
+7 forum 15

Dim Values As Range Dim CurrentSheet As Worksheet Set CurrentSheet = ActiveWorkbook.ActiveSheet Set Values = Rows(5) For j = 0 To 20 For i = 1 To Values.Cells.Count - 1 Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _ Formula1:="=Delimit2!$A$" & i, Formula2:="=Delimit2!$B$" & i Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font Color = -16383844 TintAndShade = 0 End With With Selection.FormatConditions(1).Interior PatternColorIndex = xlAutomatic Color = 13551615 intAndShade = 0 End With Next i Next j In this I code, I would like to increment column A to C and B to D after For loop of i gets over.

Member Avatar
+0 forum 0

Hi Everyone I am trying to achieve a cell that is dependent on two different cells. Basically what I want to do is: *Item 1* If the contents of Cell U20 equals the contents of W12 or W13 the cell will equal a certain value. *Item 2*Depending on the date that a task was set, the status will change. Item 1 is the priority. This is what I have tried so far, but still drawing a blank: =IF(U20=W13,"C",IF(U20=W12,"On Hold"))+IF(K20>TODAY(),"G",IF(K20=TODAY(),"A",IF(K20<TODAY(),"R"))) =IF(AND(U20=W13,"C",IF(U20=W12,"On Hold")),IF(K20>TODAY(),"G",IF(K20=TODAY(),"A",IF(K20<TODAY(),"R")))) Any help would be appreciated.

Member Avatar
Member Avatar
+0 forum 2

Hi all, Now I have no programing experience, I know very little about this, so please bear in mind. I am trying to turn a particular excel spreadsheet I have made (the user inputs information and it creates a final answer(result)) and I want to be able to turn this simply into an application. So it is a seperate peice of software to excel. Can anyone suggest how I can do this? Thanks

Member Avatar
Member Avatar
+1 forum 25

I have about 15,000 emails in google that were sent from a wordpress webform. I need to be able to extract data from that email and export to excel. Are there any suggestions? I have started using Parseur. But I need to be able to foward all 15,000 emails but Google is only allowing 100 per day. Also Parseur has a fee.

Member Avatar
Member Avatar
+0 forum 1

The following works to calculated the date for Easter any given year. I don't understand why it works ... =FLOOR.XCL("5/"&DAY(MINUTE(YEAR("1/1/2017")/38)/2+56)&"/"&YEAR("1/1/2017"),7)-34 I'm a novice - in the above, "1/1/2017" is used to provide a year. That could be done a number of ways, and is not the same way I have the formula stored in a Libreoffice Calc spreadsheet.

Member Avatar
Member Avatar
+0 forum 1

How to restore the corrupted *.xlsx file? At me installed Office 2007. I created the file in Excel. And then saved its as usually. Everything was normal, but now the file don't want to open. error: not found.

Member Avatar
Member Avatar
+0 forum 4

I have 2 sheets in same Excel. First excel sheet contains the following fields No Material 10th july 11th july 1 DATUM DCP ESD Black 2 DATUM DCP ESD Blue My second worksheet contains the following fields No Date Material Stock size+Wastage 1 10th july DATUM DCP ESD Black 283.47 2 10th july DATUM DCP ESD Black 661.6 3 11th july DATUM DCP ESD Blue 665.6 4 11th july DATUM DCP ESD Black 50.8 I want the following Expected result in the first worksheet:- No Material 10th july 11th july 1 DATUM DCP ESD Black 945.07 50.8 2 DATUM DCP …

Member Avatar
Member Avatar
+0 forum 1

To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard) Error 0xc020902a: Data Flow Task 1: The "output column "Description" (21)" failed because truncation occurred, and the truncation row disposition …

Member Avatar
Member Avatar
+0 forum 14

Hi, I really need help and this is my first time of trying to link 20 sheets into a survey chart (Chart 1). How to do that? The chart in "Chart 1" is only based on sheet 1. Excel file: https://1drv.ms/x/s!AqKGcmac7PpVz2StIkZ445NRYVat

Member Avatar
Member Avatar
+0 forum 2

I am using visual studio 2008 (vb.net). I have a long list of file names in column A on an excel sheet. These files are located in a directory on my network drive. I have to copy these files over to another folder. I know how to copy files in vb.net, however, I need to copy the files listed on column A. (example: column A has - 453245435.tif, 43453345.tif, american justice.tif etc....) Right now, I am doing this with a macro in excel, but need to switch it over to a windows form and still keep column A with the …

Member Avatar
Member Avatar
+0 forum 29

Hi, I am trying to open a large excel file (.xlsx) to ad some rows of data from another excel file. However, due to the size of the destination file i am getting the memory error. I tried the below, however when i create the worksheet object it is creating a readonly worksheet and i am unable to add data. wb=load_workbook('Test.xlsx',{'constant_memory': True}) Can someone tell me how to open the large excel file using openpyxl load_workbook method in write only mode? Regards, Dinil Karun E

Member Avatar
Member Avatar
+0 forum 5

I have checked everywhere in Daniweb to see if this has been asked before but could not find the question. Forgive me if this is too simple an issue and it is my hope that my question is clear. I have an excel worksheet (see attached) with 4 columns. Column A is the ID, Column B is title A, column C is title B and column C is count. Column A and B are related in that each title A has a unique ID. Column C and D are related and each Title B has a unique count. Column A …

Member Avatar
Member Avatar
+0 forum 1

Hi, I need to write a macro that has one row of dates. Row D. I need the macro to go down row and depending on the date I need to input a number to the cell to the right of that date. Example. If date < 12/22/16 insert value 0 if date >12/22/16 but < 12/31/16 insert value 1..... and so on. I am not sure much about code so please help me out thank you so much!

Member Avatar
Member Avatar
+0 forum 2

Hello. Please help me to stop an Excel error message. Every time I try to open the file, I get this error: "The file is unknown". Has anyone any experience in this and if so could you help point me in the right direction? How to repair Excel file? Any help/advice would be appreciated.

Member Avatar
Member Avatar
+0 forum 7

I prepare a table in Excel within a Using () statetement. At the end I UsedRange.Copy() to what I understand is the clipboard. Then I Selection.PasteExcelTable in a Word document. I get an COM Exception "command failed". When I activate the word document and press Ctrl+V the table gets copied. I wonder if that has something to do with the fact that maybe I must reactivate the Word document in code. The word document gets created also within a Using() statement. I execute the Excel procedure from within the Using(Word) statement.

Member Avatar
+0 forum 0

Hey guys, I have a code on excel, that will count the critera if there is more than one box filled out. =COUNTIF(C5:D14,"<>0") But now i am converting this code to jquery and i cannot figure it out. on my page, there is a toggle button, yes/no selector for autopay, <td><input name="autopay" type="radio" value="y" />Y<input type="radio" name="autopay" value="n" />N</td> The input fields are labelled as such: <td><input type="text" name="laccess1" id="laccess1" class="form-control" value="0.00" /></td> <td><input type="text" name="laccess2" id="laccess2" class="form-control" value="0.00" /></td> I am trying to get it to count them if they have a value in it, like 25.00 or more …

Member Avatar
Member Avatar
+0 forum 14

Hello Group! I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office which means we are moving to Office 2016. I'm finding that my application doesn't behave well with Excel 2016. It stops part of the way through and simply won't finish. The original application was built in Visual Studio 2010. It is using .NET Framework 4.5 and references Microsoft Excel 14.0 …

Member Avatar
Member Avatar
+0 forum 1

Hi group, I'm discovering that my Excel spreadsheets that are being created by a VB.net app I've written isn't completely closing them as they should be. I'm struggling to understand why and how to fix this. Here is the code for the portion of the app that creates the workbook, inserts the data and closes the workbook (or it should be). Do you see some commands that I may be missing (they are at the bottom of the code)? xlApp = New Excel.Application xlApp.Visible = False ' Add a new workbook. xlWorkBook = xlApp.Workbooks.Add xlWorkSheet = CType(xlWorkBook.ActiveSheet, Worksheet) If System.IO.File.Exists(DASRPTFileName) …

Member Avatar
Member Avatar
+0 forum 12

hi, I have an excel sheet and the is a row filled with data the row starts from B5 everytime, what i want to do it to read the values of the cell until the row comes to an empty cell how do i do it, thanks appreciate a reply, thanks

Member Avatar
Member Avatar
+0 forum 13

Trying to get the last row inserted from a Excel sheet. The sheet is called clientes. I have id, name, description Since ID is auto incremental, I can sort by ID: My idea is: oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; but it does not work. Any tips?

Member Avatar
Member Avatar
+0 forum 2

I have the following: string oledbcmd = ""; string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Excel.xls;@Extended Properties='Excel 8.0;HDR=Yes;"; oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; OleDbCommand oconn = new OleDbCommand(oledbcmd, con); OleDbDataAdapter sda = new OleDbDataAdapter(oconn); DataTable data = new DataTable(); sda.Fill(data); It fails. What is wrong with that query? I want to get the last row that was inserted.

Member Avatar
Member Avatar
+0 forum 2

Good day I am experiencing issues with Microsoft Excel 2013 32- bit running on Windows 7 Ultimate 64-bit. Whenever I start Excel or switch to it from another program the following error message pops up: "An unexpected error occured: Object reference not set to an instance of an object" To the best of my knowledge, this started after a failed export of a Sage Pastel's Intelligence Center report. Please advise on how to address this. Many thanks Etienne

Member Avatar
Member Avatar
+0 forum 2

Hey Guys, So using a webform textarea I am passing some data into PHP. This data is basically 4 columns of an excel sheet and potentially unlimited rows. Now I want to be able to go through this data, select each of the four individual elements from each row, insert these as a new row into a MySQL database and do this for each row pasted into the original textarea. I was told that Excel separates new lines with a '\n' character and each column with a '\t' separator. So my approach was to use `$rows=explode('\n',$data)` and then explode each …

Member Avatar
Member Avatar
+0 forum 6

Hi All, I have an excel file containg chart.I am able to read the chart from excel file using POI XSSF. But I am not able to save the XSSFChart as an image.I want the chart to be stored in my harddrive as an image(.jpg or .png).Please find my code fragment below. FileInputStream file = new FileInputStream(new File("C:\\chart.xlsx")); XSSFWorkbook workbook = new XSSFWorkbook (file); XSSFSheet sheet = workbook.getSheetAt(0); XSSFDrawing drawing = sheet.createDrawingPatriarch(); List<XSSFChart> listChart=drawing.getCharts(); System.out.println(listChart.size()); Please help.

Member Avatar
Member Avatar
+0 forum 8

Hello, guys i am having a problem with the Printing some tickets i need to print each ticket in a different page beacause the printer i'm using can only print the size you customize it to print and my program can have different variations knwint that i import an Excel file and dependinf on its content the tickets are generated. * I already tried to print using an offset that increments but i still have the same problem [Capture 1] . (offsetTicket +=300;) * Knowing that i only have a printer that can only print according to the size we …

Member Avatar
+0 forum 0

Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it can be easily inserted into the sql table. Should the EXCEL column be formated as a 'Date'? If so, in what format ('mm/dd/yyyy', 'yyyy/mm/dd', 'mmddyyyy', 'yyyymmdd', etc.)? In advance, thanks for all the help. Don

Member Avatar
Member Avatar
+0 forum 4

I have created an Macro-enabled Excel file using Excel 2013, and I wanna integrate it with Visual Studio 2015. I've created forms in VS 2015, and in that form, I have created several numeric textboxes. So my question is, how can I export all those values in the textboxes, to specific cells in the workbook that I've created, so that the workbook can compute its results, and then, extract those results back to VS 2015 forms. I've searched and searched but most of the codes are related to either VBA, or VB.net or C#. (I've noticed that there are some …

Member Avatar
Member Avatar
+0 forum 1

Total VBA novice, trying to do some simple file modifications in excel via access. I need help navigating to the bottom row in excel to do some copy/pasting. Getting an "application defined or object defined error", marked by the "#" below. Please help! Sub MRFDATAIMPORT() Set xlApp = CreateObject("Excel.Application") With xlApp xlApp.workbooks.Open "C:\Users\xxxxx\Desktop\Account Book\ACCESS Version\Test Folder\Book1.xlsx" xlApp.Visible = True xlApp.Sheets("Sheet1").Select xlApp.Columns("A:A").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("C:C").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("F:G").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("G:M").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("H:I").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("I:M").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("K:M").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("L:AG").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("A:A").Select xlApp.Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove xlApp.Columns("H:H").Select xlApp.Selection.Cut xlApp.Columns("A:A").Select xlApp.Activesheet.Paste xlApp.Columns("C:C").Select xlApp.Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove xlApp.Columns("C:C").Select xlApp.Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove …

Member Avatar
+0 forum 0

The End.