data import

Hello, i have a data like below in Sheet 1 for 12 months .. I need " New PO" Colum from sheet 1 to Sheet 2 WRT month like below screenshot. But it should be dynamic. means whenever i change / modify the "new po" column in sheet 1 , it should automatically update in sheet 2.

Hi all, I am new to power query, I'm currently having a problem importing data from PDF files.( i.e. the imported text has skipped all the spacing and output one string) What I get from import: | Description | PLASTERINGANDPAVING;Applyingwhitepaint; NipponPaintZeroTecPaint; | green...

Hello, I am wondering if anyone can help. I am looking to do a data import from an excel csv. I want to use this for a table seating plan. On the plan, there will be upto 50 tables. Each table will have a title (table 1, table 2, table 3 etc). Under each table there will be upto 15 guests...

Hi, Thank you very much for taking out time and trying to help me out. Here is what I am stuck with : 1. I have a list of around 4000 companies 2. Each of those companies have three financial statements (two of them enclosed for reference) 3. Therefore I have around 12000 sheets to work with...

Hi everyone, I will begin by apologizing for the lengthy post, but I wanted to make sure I included enough details to get the correct help. I am a long time Excel user, but fairly new to VBA. I have been trying to teach myself how to write a bit of VBA code to import data from text files...

Happy New Year all. Anyone done data import from Panorama Necto? Or run queries from excel in Necto? Just started a new role and want to drop some steps (too much copying and pasting for my liking) from the reporting process.

I am in need of help to write a macro for importing data from a txt file automatically, and to separate the data into multiple columns by a specific cell input. The only problem is that my txt file imports as a single column and the data isn't exact same amount of rows. So I would like the VBA...

Hi friends, I need to import all the data for various companies in each state, each region and their details in excel. Unfortunately the data is not in tabular form (unlike other threads were tabular data import codes are mentioned). https://pin-code.org.in/companies/listing I do not know...

I consider myself relatively dangerous in regards to VBA, Access and Excel. I have a simple table in Access that feeds a Dashboard and PivotTables in my Excel project. Monthly I receive a new spreadsheet of data that has to be imported into my database in Access. Here lies the problem...

Good afternoon, I get an email in this format based on how many fields a person fills out in a questionnaire First_Name: jim Last_Name: bond Address: 820 west City: mytown State: al Zip: 11111 Email: myname@gmail.com Height: 6'3" Weight: 210 Date_of_Birth: 3/31/95 Married: no Father_Name: Roy...

Hi, i have a list in sharepoint which acts as my datasource for the application am working on, i can get data feed (OData) in the browser but when i try to import the data in powerpivot model it fails with the below error message. Please help me fix it. ============================ Error...

I have a program that creates an .mdb file. I can import that file into Excel 2007 via the >Data>From Access menu chain. When I try to do the same thing in Excel 2013 I am presented with a Data Link Properties box with the connection tab selected. In Box 1 - The Data Source information appears...

Hey all, Need some advice/help. Conceptually, it is not too difficult, it's just a matter of straightening out the code a little bit. I've created a file that will serve as a master workbook; it has a basic format of headings for columns A to BB (1 to 54) such as date, velocity, averages, etc...

Hello, I'm new to the forums and although I've used excel for quite awhile, I've never actually had a reason or need to use macros for data import or manipulation. At the moment I'm trying to work on a modeling problem which will output the data in the form of a large text file. The data is...

I need to import data from the census.gov website, specifically historical data. Building Permits Survey > Permits by Metropolitan Area This is the query interface for the website. It creates data sets that look like this. http://www.census.gov/construction/bps/txt/tb3v201401.txt I noticed that...

Hi everyone out there in Excel help land. After a hard day trying and failing to get some-where with some VBA code I was hoping for some advice. My VBA coding ability is intermediate at best and in a previous life I used to get by simply walking across the office to troubleshoot with some...

What I would like to do is fairly straight forward, but I am having difficulty finding an answer that suits my needs. There have been replies to this question in other places, but they have not worked. So this is what I would like to do. Background: I have built a spreadsheet that analyzes data...

I am trying to code a macro to import selected data from one excel workbook into another excel workbook. I'm using the following code: Sub IMPORT_DATA() Dim wkbCrntWorkBook As Workbook Dim wkbSourceBook As Workbook Dim rngSourceRange As Range Dim rngDestination As Range...

Hi All, I am trying to import data from a web page with a standard web address with an incremental number that identifies the web page required (weather data from a web page). However, the macro I have at the moment is not copying in the web page. I think that the issue is that the web address...

Hi All I would really love it if I could get some help importing data into excel. Basically I would like to click a button and an import screen pops up (browser). When I select the excel file I would like that data to be placed in a separate tab. The file that I import changes every month...