I have an Access database that is being converted to another language and I need to know all the various pieces and parts to create an SQL script that creates a table. So, I need to know the column's parameters (data type, data type, etc.). I really don't want to do that for hundreds of...
I was looking to do a Power Bi but the excel file that I am using has data in an unfriendly way for Power Bi
Current data structure
I am looking for code that would be able to scrape a link like this ?
There would be multiple links that it would have to run through that would have the same structure.
The prefix would always be...
I have a set of docs in a folder that is used as a template. Our people Copy template into a different location. Everything works but a macro that opens files.
Below is my template location and name. How do I structure the Macro to adjust to new location?
Workbooks.Open Filename:= _...
Please can you assist with the following problem that I have. I am trying to bring back a value based on three scenarios.
The current formula I have is quite simple SUMIF($AZ3,BE$2,$BW3) but I would now like to add to this for two further scenarios. I think it would be something like...
Hi Community! I need some assistance please. I am trying to create an Excel file that will help me calculate my commissions, but there's an error in the formula I created.
Here's our structure:
# of Members
Commission Per Member
I have this bit of code that finds a word then removes other parts from the sentance in the cell, but I need it to find all of them not just one.
here is the code:
Set rngX11 = ActiveSheet.Cells.Find("Structure", lookat:=xlPart)
I'm looking for a macro to split the data up into different sheets,
The problem I have is there is no set number of rows between data so we have to find a word and use this word as the break for each new sheet, so I'm hoping someone can help me deal with this.
Heres what I have...
I have a workbook with three tabs
Original - The original version of the data
New - The same structure but with update
Results - Id like this be a macro that uses a key to the values in each row and the new rows not in original an the rows from original not in results
I'm just trying to develop a logic / approach in Excel, which cleans up my bad bookings and corrections.
The data records have the following structure (table above)following structure (table above)
If there is a number in column XX, it is a correction. This means that this line, and...
I've got a question on how to create a summary workbook
Here is what I have.
- about 15 files, all with 20 sheets
- all with different content, but exactly the same structure
Here is what I need:
- 1 file with the same 20 sheets and the same structure but all the cells are...
I'm having an issue that I hoping someone can help me out. I've posted on this issue before but I cannot seem to make it work.
Here is the URL to the other string: https://www.mrexcel.com/forum/excel-questions/1062784-protect-workbook-structure-issue.html#post5109213
I have a...
I have an Excel file with roughly 20 sheets. There is a fair amount of linking between the sheets etc. However the file is not large (less than 3 MB).
File -> Info says "The structure of the workbook has been locked to prevent unwanted changes ...."
This looks like it might be why I can't...
I am trying to get commission values to generate based upon three criteria's:
So, I'm having an issue and from the research I've done, I don't think there is solution but I will pose the question to the experts here!
I have a workbook that I have password protected each sheet. I also have the code below integrated on one sheet that triggers a name change and color...
In excel 2016 would it be possible to use all the functionality of a workbook ->protect ->structure yet keep the hide and unhide of sheets unprotected for the end-user.
Thank you and will appreciate.
I need help understanding this data structure. I've looked through it and I understand how it works but I don't know exactly what it is called (I am a novice when it comes to databases). Therefor, I am in the dark on finding solutions to work with it and manipulate it. I need to break it down...
I have a requirement for an excel sheet to be formatted from a flat structure to a stacked structure. I'll try to explain:
In the flat structure has a number of basic columns, some of these columns repeat multiple times ('Transaction1', 'Transaction2', 'Transaction3'). some of the items will...
I have 5 excel files. All files have same structure.
These files are prepared on daily basis.
So, structure for 9-Apr-2018 and 10-Apr-2018 will be the same.
Only difference will be between number of records each file.
How to I import all these 5 excel files in one single table of access...