database creation

I have data that I want to extract for the daily analysis of our lab, our lab is generating three excel sheets per day for three shifts. Each excel file name is saved as ShiftName+Date ShiftName(M:morning, A:afternoon, N:night). Each excel file has three sheets with the names CGPI, CGPII...

Cross-posted at: https://www.excelforum.com/excel-programming-vba-macros/1355803-update-data-to-match-worksheets-instead-of-deleting-entire-workbook.html Reason: It has been up there for a few days now but no reply apart from my own replies. Link to work books...

I am trying to build a database for my customers, where I can sort by very detailed info. I might have a customer (name - contact - address) all identical, entered 20 times, with one column (product) different in each row. I need to be able to sort the database by product - so as far as I can...

Hi, I currently have data entered in report format (full of colours, logos, various formatting - pleasant on the eye). I'd like to copy the data from this report, and subsequent reports that are entered into the same template, and form a database. So far I've figured out (correct me if I'm...

INTRODUCTION This is an attempt at creating an excel database for work that will allow employees to identify who is handling a particular task for a given client. Excel is pretty much the only option since most employees are familiar with the application and almost no one knows how to use MS...

I an new to Visual Basic but cannot seem to get this code to populate the form data onto the spreadsheet. First row is fine but then wont add further data. Think that issue is in the 'RowCount' function... any help appreciated! Private Sub cmdClose_Click() Unload Me End Sub Private Sub...

Hi Guy & Girls, Have a current situation with an alarms list from DCS system at work output file is .CSV. Each alarm has specific tag and all have priority ratings What I would like is a template type WorkSheet with possibly some code/VBA where by when the alarms list in copied and pasted...

I have a database that contains many different worksheets that all are organized identically. I want to create a summary worksheet that compiles data from multiple cells (20 pieces of data, each scattered around the worksheet) from each worksheet into a database to automate my data analysis...