local

We have a file with 3000 employees called Database.xlsb thatstores employee ID in Column A. We also have Local files (i.e. local1.xlsb, local2.xlsbetc.). Each local file can hold up to 200 employees. We would like to transferdata from local files to Database.xlsb. i.e. in Local file we may...

Hi guys, I've been Googling this and can't seem to find an appropriate answer. What I am looking is for a way to bulk convert Times from Pacific Timezone (PST/PDT) into local UK time (GMT/BST). So what is needed to be known is whether the date is in Daylight Saving Time for one or both of the...

First time using dropbox for this. I want to create VLOOKUPs referencing several different files, but the problem is that everything is in Dropbox and I need to download the files to work on them. Is there any way to create the links without having to download all of the files onto my local drive?

I have created an Excel dashboard that uses VBA code to import data files in csv format. The data includes dates, and since I and other users are European I had to add the "Local:=True" parameter to my Workbooks.Open command to avoid certain European format dates being converted into US date...

i need some help , but here cant attached file or local image so i give a link . https://www.excelforum.com/excel-programming-vba-macros/1233216-excel-vba-how-to-use-macros-to-return-the-match-value.html#post4911438 Thanks!

Hi all, I am looking for some approach to my requirement. Hope will get some guidance from experts. I want my local excel with a command button which will connect to sharepoint once it clicked and then copy the content of the sharepoint excel to a mail and send this mail to the people mentioned...

Hello people, I am looking for a solution to save a file as CSV file with Always the same settings for list separator, decimal separator and thousand separator. If I run the macro from my computer the file will be as it should be because my local settings in Windows 10 are Decimal=, ...

im trying to calculate when a team has won the league it will return "c" and noting if its possible that a different team could win this is based on a 38 games (20 Teams in the league my first team is in A6:A25) - and vice versa for relegation "R" and blank if its possible they could...

Hi How can I get the string value of the current folder of a workbook i think i mean curdir() (by current folder, i mean the folder in which the workbook was just saved) written into Options->Save->Default Local File Location? What is the name of its Excel container and the property i need...

Hi all. This may not even be possible. However here is the question. I have a two files on a network share. Call them "Linked Data" and "Local Data". The "Local Data" has Linked rows from "Linked Data" and one column that data is entered. If I add rows into to the source file "Linked Data" it...

I have a spreadsheet where I am trying to populate positions from a lookup table on another sheet (LocalStateSCC Falcon positions) where all the source positions are in a single column. I have a column for Local, a column for State and a column for SCC in my destination sheet (the one which...

Instead of looping through one worksheet "RVP Local GAAP" how do I change the below code to loop through two worksheets along with two ranges? Not only "CurrentTaxPerLocalGAAP" but also a range called CurrentTaxPerGroupGAAP in WS2 and then also pasting values into not only RVP Local GAAP but...

Hi there, I trying to write a script to compare filesizes of local and remote (on a web server) files... I can get the local filesize by using: Dim localFileSize As Long localFileSize = FileLen(ThisWorkbook.Path & Filename) MsgBox "local - " & localFileSize I can check if my 'remote' file...

Hello All, Please can you assist me on the below issue I get frequently. I have an excel report which comes from a system. The data shows both Local Currency information and USD Currency information, across multiple tabs. In a separate excel workbook I copy and paste values all the Local...

Hello, I've been searching for a solution to this issue for the past year, but haven't quite found one. I have a local Pivot table with pivot charts in Excel 2013 that reference the columns of a large (A:CD, 140,000+ rows), sensitive data set within an Excel workbook on our corporate SharePoint...

Hello Again Mr and Mrs Excel, I had columns with Headings: Local Date, Local Time, UTC Date and UTC Time and a lot more columns to the right which I am not really concerned about. With a command button pressed, all the columns in a single row are filled from corresponding Textboxes in...

I need a solution to open an a specific pdf (Adobe Acrobat 9 Pro Extended) page in 2016 excel (workbook, sheet 3) in my own local drive. My PDF document is a sub-folder in my laptop. Please assist.

Hi All, I have most my local Access databases stored on the desktop, however I prefer to work with SQL Server Management Studio. Is there any way of connecting to local Access databases without admin rights? Best regards Sober

Morning all, I'm playing around with the Map graphing abilities of Excel within my Office365 subscription. I've managed to get it to plot some data for major European countries but not for towns local to my area in Cumbria, UK. Do I need an add-on? Anyway. An example of the (made up) data I'm...

Hello, My manager asked me to prepare a margin calculation sheet that contains confidential unit costs and limit its distribution to senior management only. The idea is to create an excel file where the cost is read via a Vlookup formula reading for a local file in drive C. So when a senior...