Hi,
I have need to import marketing information into the SQL 2005 from an Excel sheet..
Currently I am using DTS Wizard to import them..
But everytime i do this its a nightmare to get i...
hi i have three colums in a spread sheet the first tow have numbers in example
a b c
12563.2...
I would like to export/link a pdf document that is posted on the web (e.g. a daily report) into excel so i can use the data from the PDF. I am unable to run a web query from these PDFs even t...
Whever I open up a CSV file with other sheets in the backgrond with large amount of formulas in them Excel will seem to calculate the entire sheet. is there anyway to disable this? I already...
We are trying to create an Excel column chart depicting how many days it took to close a particular sale. Our CEO wants the column's height to indicate the amount of the sale, and the column'...
I have a template workbook used to collect various data.
All the sheets are protected with input cells specifically set to allow users to input data.
Once completed and authorised the workbo...
I have a worksheet with several columns. I want to add a column that "RECORDS" the date and time when adding a new raw. For eample: im adding urls for blog sits and im collaborating with my fr...
I want to enter text into a cell and if the text is too large have it automatically flow into the next cell. Some of my excel workbooks do this and others don't. Sometimes the text is just c...
We have a macro set up to change the value of a cell, then print the worksheet. The problem is that we are wanting to print it to Adobe and everytime it prints...it ask for a file name which ...
I am reposting this question. I am trying to set the same thing up on a different user's PC, but I am not getting it to work. Thanks.
I have two things that I would love to do automatica...
See Attached Workbook
Hi Experts
Need a extra step to the current macro button (Grey Add Supplier button).....
Need the same macro button to add a formula in each row so the format of ...
The sum below does all numbers between 40001 and 40006, how do I do the sum 40001 to 40006 + 40008 to 40009 please?
=SUMPRODUCT(('Trial Balance'!$A$2:$A$1052>="40001")*('Trial Balance'!$A$2...
I create an Excel file on the client machine with certain formatting and data included. The user can then add data to this file and save it. Later, that file is read and the data uploaded to a...
I have searched the DB of questions here and found only help on how to remove duplicate data. I am in need of scanning all 65k lines and delete all Unique rows. I am interested only in keepi...
I tried to write the following code and it didn't work and so I just "recorded" it. Which is always messy? Is there a shorter/cleaner way to do what I am asking it to do?
I am just trying t...
I have a code that will ask user to select 2 sheets, compare and throw differences between two sheets but currently it is calculatiing only for 2 columns I want the same to calculate for all 2...
