imported

I have a spreadsheet that has a query attached to refresh data from a ms access table. Each month it brings in one more tow of data from access. This part works fine. There are formulas in the columns next to the data that is imported. Here is what the formula in the row next to last row of...

I'm back again on bended knee. Thank you to FormR for their help previously with renaming sheets. Today's issue is slightly different however it encompasses some of the same problems. So, my workbook currently comprises of 3 sheets Main, Imported, Data Main is the Main Menu Imported is a...

I have a spreadsheet (sheet2) that is linked to sheet (sheet1) that is imported from our database. I would like a message alert to pop up to notify me that I have less data on the linked sheet (sheet2) than the sheet that was just imported. Sheet2 is linked to an Access database to run a report...

Hi All, I need a VBA solution which will perform a sheet to sheet range copy function using dynamic sheet name references. The current template that I'm working with uses the indirect and concatenate functions to perform the same thing, but since this template will be expanded to import dozens...

I have imported a table from https://www.investing.com/crypto/currencies. The table on the site contains 1621 records, however after importing the table with Power Query it only shows 100 records. Does anyone know if I can adjust the query so that I can Import all records? Thank you

I imported a form from one db to another and I seemed to have lost some of the form functionality. Before the form was imported (in the original DB) all the fields would update when I selected a member from a combo box. However, the imported form doesn't do this. None of the fields respond to...

Hi I have cells that have been imported from the net. In the webpage there are values for heights that appear as follows "6-3" for 6 feet 3 inches, but when imported into Excel the cell reads "3-jun". How could i copy that cell into another cell with the correct format? So lets say I have...

Hi all, In need of some help. I have a main workbook which I use to generate costing sheets. These sheets are generated with macro button in for navigation. The costing sheet when completed is then exported from the main workbook and saved as it's own workbook for users to reference . However at...

Hello, I have imported an OLAP data cube into Power Pivot which has imported OK bit the field list that I see in Diagram View or in pivot tables is very small, too small to read. As is any context menu. I'm new to Power Pivot so I may be doing something stupid here, can anyone help please? Thanks

This one is not going to be easy! I need some help to know if what I'm doing is even possible. I have a lot of files that create a tab that needs to be imported into a table in access. The code I have so far imports the data into the access table, and works like a charm. The issue is that...

I am trying to create a pivot table from an external data file. The data file is an .xls file with whole bunch of numerical laboratory results in it. The thing is, not every product is tested for everything, so it's natural that some fields are left blank. I've figured out that the problem...

I'm not sure how to do this, but I have an imported file from text, and I need to make sure that the last modified date isn't older then 5days and if it is I need some text box that says "file too old" or something like that.

So I have a pricelist on one sheet and I'm looking to make it my master sheet. Then I'd like to import it to another sheet, so any time I make a change on my master sheet, it changes my imported sheet. I'd then like to put certain ranges, like if under $10, subtract 20%, if under $20 subtract...

I have imported 5000+ lines of data which was copied from a .pdf - unfortunately although it was laid out in the .pdf in 4 columns, it has imported into Excel all in one column e.g. A1=Title 1 A2=Title 2 A3=Title 3 A4=Title 4 A5=Data 1 A6=Data 2 A7=Data 3 A8=Data 4 I need it to be: A1=Title...

Hi, I have imported multiple excel files into one master workbook but also want imported files to have its actual name instead of Sheet1..2.. and so on. e.g I have imported two files named "Customer name" and "Quantity" but in master workbook these can be seen as Sheet1 and sheet 2. Please...

<tbody> Excel 2007 <tbody> Row\Col A B C D E F G H I J K L 1 1 2 3 GrandTotals 2 Qty Value Qty Value Quantity Value Quantity extend Value GrandTotals 3 ------------ ---------------- ------------ ---------------- ------------ ----------------...

I am VBA noob extraordinaire. I am merging data from multiple WBs. The Source WBs and destination WB are .xls. In all the source WBs, the D column contains hyperlinks that work in the source but after copy in the destination the Address is missing from the Hyperlink properties. Here is...