Search results for query: *

Hello, i have excel document containing 2 columns.. AAA, 123 AAA, 234 BBB, 345 CCC, 456 DDD, 567 DDD, 678 DDD, 789 ETC.. Need to convert the rows to columns but preserve the first row.. So would need it to look like.. AAA, 123, 234 BBB, 345 CCC, 456 DDD, 567, 678, 789 ETC.. I can find...

hello, please can anyone assist with my request for college. I am trying to write a program on php which does the following and then I can use on a html drop down For the Alphabet letters.. A,B,C,D - I want to create a loop that creates the following A-L-01 A-R-01 A-R-01 A-L-02 A-M-02 A-R-02...

HI, how can i create simple sql pivot to do this.. [current output] NAME, VALUE JOHN, 10 JOHN, 12 JOHN, 15 PAUL, 8 PAUL, 10 SARAH, 1 SARAH, 2 SARAH, 3 SARAH, 4 SARAH, 5 etc... [new output] NAME, VALUE1, VALUE2 JOHN, 10, 12, 14 PAUL, 8, 10 SARAH, 1, 2, 3, 4, 5 etc... Many thanks Brian

hello, i have data that is returned on mssql but i need to remove the rows where there are multiple positions this is what i currently get... oem, position ABC123, LHF ABC124, RHF ABC124, LHF ABC125, LHR ABC126, RHF ABC127, LHF ABC128, LHF ABC128, RHF ABC128, RHR ABC129, LHR i need the data to...

Hello, i am looking to create a vba file that can be run from desktop to do the following.. Please can someone assist? 1) copy a text file locally that is on a server. Will need to pass server address and location and username/password 2) display contents of text file with "ok" button...

Hi, i have an excel spreadsheet with data that looks like below... REF, VALUE, QTY 0414701006, 0414701053/084, 2 0414720088, 0414720018/029/038, 80 i need to be able to seperate the values to new rows but preserve the Ref and Qty. In addition to this, if there are /xxx numbers i need to...

Hello, I need to write some php code to display all images that are in a folder. For each image, I need to display certain information against each image... Fir example, I have images that are named as follows... SO12345_BOX01_LAYER_01_DT20201016155402.jpg I need to separate the values out of...

Hi, is it possible to rank the Price in ascending order but have all 0 Prices still ranked last? At the moment the 0 Prices are returning as Rank 1 as they are the lowest value? Example Data User,Price,Rank abc,0,5 def,0,5 ghi,1,1 jkl,4,4 mno,5,3 pqr,3,2 Many thanks Brian

Good Morning, i am looking for some sample code which i can adapt to do the following in php... 1) Open a source.csv file and fetch the data from row 1 2) the data from row 1 is to be passed into a variable which i then use as part of an api 3) the result from the api is to be written to...

Hello, please can anyone assist me in the following.. I am looking to create in html a 4 column spreadsheet / data grid where a user can copy and paste excel data (column at a time) into. Or rows of data from an email. Column one = OEM Column two = reference Column three = qty Column four =...

Hello, i have an excel document in the following format.. ColA, ColB Apple, 123 Apple, 345 Pear, 678 Grape, 890 Orange, 111 Orange, 222 Orange, 333 Etc.. I need to convert to ColA, ColB, ColC Apple, 123, 345 Pear, 678 Grape, 890 Orange, 111, 222, 333 Please can anyone help? Many thanks, Brian

Hello, i have an csv document with 2 columns that have the following example data:- REF OEM 987392405 DSB52402402404240 / LR2401240574 / SOB52402402404240 / SOB524024024042 987246240 1240240196240 / 1H240615423A / 1H240615423B / 1H240615423D / 1H240615423DX / 6K240615423B /...

Hello, i have an excel document with 2 columns that have the following example data:- REF OEM 987392405 DSB52402402404240 / LR2401240574 / SOB52402402404240 / SOB524024024042 987246240 1240240196240 / 1H240615423A / 1H240615423B / 1H240615423D / 1H240615423DX / 6K240615423B /...

Hello, i am looking to create an sql query or an sql view that calculates a Target Value that increases throughout the year depending on what month you are in. For example:- The year start date is 2018-07-01 - there has currently been 8 days elapsed. In July i want each day to have a value of...

Hello, i would like to have a php page that will read another page and convert to an xml file. I can then send as an attachment on an email and the receiver will see all the data & formatting.. Is there a tool that can do this, where i just pass an url into it and it creates this file...

Hello, I have a series of php pages which refresh to each other every 10 seconds (in a loop) is it possible to delay the header refresh if a mouse is moved? kindest thanks Brian

Hi, i am looking for some VBA code to resolve an url image name in CELL A1 to A1000 and place the image in a new cell next to it. If the image does not exist then no image is displayed. This is what i have so far.. Sub Test() Dim objPicture As Picture For i = 2 To 100 With...

Hi, when i open an excel template from an Access button the user can overwrite the data and save over the file. How can i get the template to open as a new file (like it i open it from windows explorer?) This is my code.. Private Sub Command1_Click() 'Open Enquiry Excel Template Dim...

Hello, i have table in Access 2013 (Enquiry) to which i need to resolve an OEM against in another table. Some of the Enquiry data might already be in the correct format but other rows might not. I need some code that when i select a button on a form it automatically looks up the OEM to see if it...

thread68-1732600 Hi I am using this macro again for a new project but i keep getting the same problem with... cl2.Resize(10 ^ coun - 1).Insert Shift:=xlDown, CopyOrigin:=cl.Copy() I do not understand what is causing the problem. The macro works and populates the data? Please can anyone...