I am a design engineer working in Oil and Gas construction industry. I am working on a personal project where i have an excel sheet (call it input sheet) with 4 columns and several rows (not fixed). I need a program which on click can sort out rows in desired order (based on a key word in second column e.g. 'Design', Test', 'Material' etc. and desired format. Results shall...
1. Check Consolidated file range "L5" : "AO5" are matching. if not make it matching by adding the missing data. (Related charts and tables should be automatically updated) 2. Insert new entries in TBT Register from weekly submission workbook. Should not paste if the data is existing in Main Reg(Related charts and tables should be automatically updated)
Hi... We would like to design a front end user form using the existing excel sheet. We have done all the formulae and calculations. You must able to convert this set of info using vba and design the form. Its manufacturing parts assembly form. Data will be shared during our discussion.
I have an Access database with tables, queries, forms (with vba code sometimes) and reports. This database now is sepparated by 2 access files. One with tables, and other with all rest, because we need to work some persons with this database. But some tables are very big, and queries sometimes are slow to load. Now only one person work on database
Hi We have a small scraping macro written in VBA which takes [login to view URL] game ID from column D and scrapes data to Excel for respective cells (so for example for ID 1402510 it will scrape data from [login to view URL]) However there are some minor issues with this macro. One of them is scraping data when betting market was
I need EXCEL VBA format for quotation mak8ng with product images and specs i need it for quotation and my all product want to add in database and during making quotation i want only input model no. and other details visible automatically like discription product image Please check attachment for sample ...there is need one extra column for hsn code
I need you to develop some software for me. I would like this software to be developed for Windows using .NET. Re-write a Microsoft Access VBA Application in C# using SQL...Application has approximately 12 forms and 12 small to medium sized reports. Access database need to be designed using SQL.
Our contact info (name, email, personalization data...) is in a Worksheet in Excel. We want to be able to click on a row, have VBA create a personalized email body, Stop and let us check the email and maybe add additional personalizaton, then Send. Then, track an open, click thrus to various links, forwards...
i have xls wanted it open in excel file with groups and with sub totals and with design
Need to convert data contained in array into tabular format. 1st row is the header row and in the output date column names would become the row values in a column called Date and the integer values would come under a column called Hours. Integer value would move to row corresponding to date. See Raw to Clean tabs in file attached. Desire VBA macro solution