I use Google Spreadsheet to feed some data online. Later on I use Excel to import this data that it is hosted at Google to do a better handling (reports, charts, etc). However when I import the data from Google, the contents of 1 row is splitted on 4 in Excel.
Are there any way to keep the same formatting from the original ?
[URL]
I'd like to be able to find a location on a map and have this location automatically fed to my spreadsheet. The location info I need is the Latitude/Longitude.
Seems like this would be a piece of cake with Mappoint? Is there an automatic way to do with with Google Earth?
I have a CSV file and the first field is date. I'm imprting this csv file using Data->Import from Text When I do that it's adding an additional column at the left. I do not want it to add additional column what should I do?
View 1 Replies View RelatedAny way for an excel spreadsheet to automatically feed into or sync to a Google doc.
Unfortunately I have a dashboard which can only use a Google doc spreadsheet, so uploading the excel spreadsheet into Google drive wouldn't work. Nor vice versa as we have a Cube which feeds into Excel.
So the only way around this is for the excel spreadsheet to sync to a Google doc.
I have an excel sheet which has a column containing data only for the month of January 2014. The date format used is dd-mm-yyyy hh:mm All the data must be something like dd-01-2014. But, the excel sheet is interpeting like it has data for Feb, March, April, June etc...
The data in the sheet is getting miscalculated like it has data for rest of the month also.
Lets take an example of 01-02-2014 09:22:16. Actually its 2nd Jan 2014 but excel sheet misenterpretes as 1st February 2014. 01-04-2014 07:49:51 is being taken as 1st April 2014.
I have tried using text-to-columns - next next date. But still no luck.
There is a huge data which i wanted to work upon but due to this i am unable to.
I would simply like to know how to create a basic ranked leaderboard through EXCEL or Google Spreadsheet, which i will later on implement on a community forum. I would like 2 entries for the leaderboard column titles, being:
Column A: PLAYERS
Column B: POINTS
Then under A i will be typing all players manually, and similarly for B with points.
i have an excel file with hundreds of rows of product codes which i need to download images for. is there a way this can be done directly from excel? basically if cell A1 has product name and Cell B1 have product code, id like Cell C1 to generate a link that will use the contents of B1 as the basis of my google image search. can this be created using a macro?
View 9 Replies View RelatedI want to be able to run a macro that will export some of the data from a worksheet called Generated Report into another worksheet called Matrix. The data will be taken Generated REport and grouped into sections of the worksheet. These sections will be defined by the BRID value.
The Data that i want to export will be from the first 5 columns within the Generated Report(note there are other columns which data is not required from).
The following columns will be exported from Generated Report -
BRID,Requirement, Bug Description, Bug ID and Alt Bug ID.
BRIDRequirement Bug DescriptionBUG ID Alt Bug ID
PQ115 PQ115-Login Bug Description text xihllloloj43712 123
PQ116PQ116-Landing Bug Description text ghghghgoot 43713 126
For Matrix
The data will be imported into Matrix worksheet into the following columns as part of the row headings
- Requirement, Description, Bug ID and VF Bug ID.There will also be other columns (outlined below) which i will use to manually enter data
The data will be grouped and imported into the relevant section by its BRID eg PQ115, PQ116 etc.
I want each section (marked by BRID number)to be separated by row headings.
These row headings are to be generated after populating all data within each BRID number.
When the data has been populated in each row there is a column called 'Status' which contains drop down list boxes which can be assigned.
The default status will be set to 'To Do'. The complete row headings are displayed with Output from Generated Report underneath
BRID Priority Requirment Description BugID Alt Bug ID PC UpdateNotes Actual Result Type of DEfect Test Status Tested by
PQ115 PQ115-Login Bug Description text xihllloloj43712 123 To Do
BRID Priority Requirment Description BugID Alt Bug ID QC UpdateNotes Actual Result Type of DEfect Test Status Tested by
PQ116 PQ116-Landing Bug Description text ghghghgoot43713 126 To Do
So far the macro that i have been using allows me to locate the data for each specific BRID in Generated Report and copy into the corresponding BRID section within the Matrix. I have to repeat this step for each new BRID and i want to be able to whole automate this process.
So basically I have an Excel sheet which has keywords that need to be entered in Google search. I need the URL of the first page of the search result that appears after that keyword is entered. IS there a macro for the same?
View 3 Replies View RelatedI would like to extract some text from a word file and transfert it into an excel spreadsheet.
My text is always presented in the same way. First there is a line with some data (see exemple bellow). I have no problem to extract them using the macro bellow even it's not perfect.
My problem is on the main text. I weed to keep the format or at least the different paragraphes as when you copy text in word and past it in the formula bar (or press F2).
Here is an exemple of my word file
Code : XXX1- Abrege : DGS45 - Type : D - ADICAP : PHXT5847
TITRE
Text Paragraph 1
Text Paragraph 2
[Code].....
I would like to import all data from a workbook (only 1 sheet), which the user must select from a file dialog, into a spesific sheet in the active workbook.
View 5 Replies View RelatedI have a tedious task of copy/paste from our website. have a look at below sample data. I have around 1500 rows of data like this.
Sheet1
A
B
[Code]....
Column A has input data which i need to copy and paste in a web form. Column B will have results scrapped form webpage[ URL]. This webpage will need login details
If a code can be written which take value form column A of spreadsheet and paste in webpage like shown in above image and hit search button. Next webpage will be loaded with number of results like shown in below. Take the number of results and paste in column B of spreadsheet.
Retrieving the names of all places in excel sheet as per Google maps or visible in google maps for a selected District / State / Country.
View 9 Replies View RelatedOK, I have a spreadsheet that looks like this:
File is in .csv format
HTML Code:
Timestamp,Choice,
1/10/2013,B,
1/15/2013,A,
1/15/2013,A,
1/16/2013,B,
1/17/2013,A,
1/19/2013,A,
1/26/2013,A,
Any way to compile data into a table that looks like this:
HTML Code:
Timestamp,A,B,
1/10/2013,0,1,
1/15/2013,2,0,
1/16/2013,0,1,
1/17/2013,1,0,
1/19/2013,1,0,
1/26/2013,1,0,
I have a googlespreadsheet with 4 columns. date, id, name, positive/negative.
What I would like to be able to do is to call a procedure from an excel document to copy/retrieve all of the information between specified dates on the google spreadsheet and place into another worksheet in the excel document.
The spreadsheet is hosted in my googledrive and is confidential (i.e. I cannot publish it), so I am assuming I will need to add password credentials into the code, which will be an added complication.
I found a good piece of code to import data from text files into excel. they are delimited
I keep getting an overflow error, and then I get the error that the file is already open?
Option Explicit
Sub OpenTextFiles()
Dim strFiles() As String
Dim strFName As String
Dim strFPath As String
Dim IntFile As Integer
Dim sep As String
'define the directory
strFPath = "C:UsersXXXXXDesktopHOLDINGTEXT into Excel"
[Code] ..........
I want to import data from 1 excel sheet to another sheet in excel 2007 by clicking the button which i was created through.
Developer>insert>forum control>button
I am using Excel 2013, and I am following the example here: VBScript Scripting Techniques: Read Excel files without using Excel that reads in Excel data as an ADO record set to a classic ASP file using VBScript. I am not able to import all the Excel data successfully, and I need to know what I'm doing wrong. Note that in all these samples cell A1 is the heading text "Column1" and the main data starts on cell A2 (consistent with the example code).
When my source Excel data looks like the following:
Code:
Column1
1
2
3
4
5
6
7
X
9
10
It imports everything OK. However, if I move the X to the next row:
Code:
Column1
1
2
3
4
5
6
7
8
X
10
...the "X" cell gets imported as an empty string. So the imported array looks like this:
Code:
arrSheet[0][0]: Column1
arrSheet[1][0]: 1
arrSheet[2][0]: 2
arrSheet[3][0]: 3
[Code] ....
But if I add another X to an earlier row in the source worksheet, like so:
Code:
Column1
1
2
3
4
5
X
7
8
X
10
...this gets imported OK.
I currently have a userform, and on commandbutton_click, it performs
the following code that adds a column in a access table to a combobox(cbList)
Private Sub CmdName_Click()
Dim rstName As ADODB.Recordset
Dim strClientDatabase As String, strConnectionString As String
strClientDatabase = ActiveWorkbook.Path & "9001.mdb"......
After its listed on the combo box, upon commandbutton_click on another button, i wish to extract a particular record, based on the selection made on the combobox(cbList). This is where im having problems caused i have no idea how to do so. I just want it to extract the particular record row, based on cbList, and insert it into range A100:D100 in a particular worksheet. It is then updated and added to a listbox which ive already done the coding for, and with another button click it would add the details in the listbox into the appropriate location i wish to.. The only place im stuck is with extracting the data from access into a A100:D100 range in any worksheet. what ive come up with, but is incomplete is :
Private Sub CmdImport_Click()
Dim adoRS As ADODB.Recordset
Dim strSQL As String
Dim strClientDatabase As String, strConnectionString As String
strClientDatabase = ActiveWorkbook.Path & "9001mdb"
.........
I have a data file saved as csv like this:
Risk Postcode,Effective Year Month,Written Premium,Written Units,Earned Premium,Earned Units,Claim Cost,Claim Count,Glass Manufacture Decade,
2600,200507,0,0,5.7354,0.0765,0,0,1920,
2600,200508,0,0,5.7354,0.0765,0,0,1920,
2600,200509,0,0,7.1693,0.09563,0,0,1920,
2700,200510,0,0,5.7354,0.0765,0,0,1920,
2700,200507,0,0,5.7756,0.0885,0,0,1930
what i want to do is to group the record with the same postcode together and just return one record for each postcode in excel.
so the output will have the postcode, the sum of written premium, written units.
I understand i can use Access to do it, but I want just to use excel for this task.
importing some selective data from txt file to excel. Only the following rows I need to pull out from text file into the Excel i.e. Project row, installation row, and two rows immediately below the installation row. This is my logical procedure..
1. Macro look for the rows that contains the word "PROJECT"
2. Open an excel file
3. Pull the row from txt file to this new excel file.
4. Macro look for the rows that contains the word "INSTALLATION"
3. Pull that row with INSTALLATION AS WELL AS Two rows immediately below the INSTALLATION row.
I'm trying to see if there is a way to speed up the process of doing multiple Google searches to see if I can find a website attached to a text. I have a list of websites, and am trying to update the list to remove dead/inactive sites, and also find the URLs for the live sites.
The list looks like this (sample):
Comstock, Inc.
ConNuestroPeru
Contacto Latino
contentSutra
Core States
Crains Chicago
Crains Chicago Business
Crains Detroit
Crains Detroit Business
Credential
Crescent-News.com
Crowell Weedon
Thus there's no website attached, and I need to manually find the URL myself. There are over a thousand cells in the list.
How to speed up the process of finding a url for these websites?
I am trying to import competitor data into excel using google finance, but when I try to run the web query I get the message that "this web query returned no data." I have no problems when using yahoo finance and other websites so I think it has something to do with google, but I don't know what it is. I have been searching for some time now without any luck. My end goal is to make this a dynamic web query and incorporate it into a VBA code, but I need to get the web query to work first. Below is the text of the web query.
WEB
1
http://www.google.com/finance?q=COH#
Selection=cc-table
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
When I export data from .csv or .tsv file to .excel file then all the preceding zero's disappear and the code 0010 display's like 10.
I know I can manually import data from csv to text(option "fromtext" in excel) but i want to do it automatically.
I have a workbook which, amongst several worksheets, also includes 12 blank worksheets (one for each month of the year).
Is it possible to have a macro that will (a) first prompt the user to select an excel file to import (the excel files to import are provided each month and only have one tab); then (b) select which worksheet to import the data (values only) from the selected file into.
I am importing data into an Excel 2007 worksheet from an online form. They are answers to 30 questions for up to 250 respondents. I was expecting to import one row of data for each respondent however the data is importing in a step like manner as below
Q1Q2Q3
AF169856 Y
AF169856N
AF169856N
AF145723 N
AF145723Y
AF145723N
Any formula/solution to bring all of these responses into one line for each respondent ?
I'm using excel 2007 and I'm trying to import data from a .txt file into excel and analyze the data. One of the columns in the .txt file contains descriptions for each row and its in multiple rows. Is there a way to import the .txt file so that it will show a description for each row in one cell?
I imported the data into excel but the issue is the description.
Is it possible to disable Import Data Dialog box in Excel 2010? I have a web query file. I want to copy its content and paste in a new worksheet under an existing workbook. I have a macro which does that but I get Import Data dialog box when I tried to paste the copied content from test.iqy file to new sheet. The dialog box has
Select how you want to view this data in your workbook?
By default Table is selected, which is fine.
Where do you want to put the data?
By default New workbook is selected. I want to have Existing worksheet selected by default.
Is there a way to set these requirements into vba code and make this dialog box not appear at all?
I am using Excel 2010 and I want to import data from a text file, but the problem is that the data is more than 1048576 rows of excel. Is there any solution though codes if one sheet fills up and import remaining data to other sheets ?
View 2 Replies View RelatedI have small bit of import code (below), that I am looking to modify. The data that I am importing is for an inventory tool that determine optimal on hand quantities and alerts to any issues. In the past there had been one inventory source (one .csv data file). So I populate that to one sheet and modify the data on that sheet. I now have multiple data sources that I need to address.
There are two things that I would like to add/be able to do.
1) I would like to add a dropdown or set of multiple buttons to the popup window that says "Select the OnHand Report". Previously I only had one report source which I posted to sheet "orow0205". I have 2 other data files now that I have to import and they need to go to sheets "orow0206" and "orow2144". I am grabbing the data the same way on each sheet so that doesnt need to change I just need the option on the pop up window to determine the sheet name I want the import to go to.
2) The files that come from the sources above have a file name like "20121213_00000_groupstatistics.csv". Where the first eight digits represent the date the file was generated. If possible, after I select the sheet via the popup solve above, I would like to have the date populated in "MM/DD/YYYY" format in the last column of the imported data (the same date for each row of data imported). The file imported has no date data on it and can represent any day (which is why I am not using some form of TODAY formula).
I am currently using Excel 2010.
Sub AddData()
' Import_New_data
'
'Open Datafile
[Code]....
