Hello - I have a spreadsheet that is an export from another system, and need to write a Macro to insert several SUM formulas in specific places in one of the columns. The trick I can't figure...
I create numerous files using macros in a workbook.
The files are in a separate folder in the Excel file directory ActiveWorkbook.Path
Is it possible to zip these file into a zipped folder u...
Hi,
Check colum excel that has the data and get that into a format in word. Attached are the samples
I need to convert them into labels. Is there a way i get the data thats in the excel to...
I've got a text file on my computer that is MASSIVE. It's got dictionary words ranging from 3 to 24 characters in length. I need to trim this down - I'd like only words from 3-13 characters ...
Hi,
Excel Macro that moves rows as per the data entered in colum "Q" and does many more things need a change.
this code is from Albert and Rob.
When i copy the machine name from "Deskto...
I am converting data using copy and paste from an html to an excel spreadsheet... I want to delete the hyperlinks and check boxes automatically without disturbing my columns. Is there a way to...
I have two spread sheets I am working with. (Seperate Workbooks)
1. Corporate employees and their respective cost centers
2. PC Inventory with cost centers and an additional 5 columns of i...
Experts,
I have =IF(D9>C9,"â","á") and I want to have it display a green up arrow or a red down arrow. I have arrows in the sybols that work but can't color them. Is it possible to use imag...
I have two sheets (Sheet 1 and Sheet 2)
Sheet 1 contains Emp ID and Tag ID as the column (Duplicate entries are also there for EmpID meaning 1 tag ID may contain )
Sheet 2 contains Emp ID...
each day, i add a worksheet to the workbook and paste in my daily pipeline. it makes it hard to track my notes from previous days. my solution to that is to highlight all the files that i ha...
Hi,
Send mails to users in the excel with the data below.
very identical to this post
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23843771...
Is there a better formula for doing a three way table lookup then the combination of vlookup formulas I am using? I have a table or matrix that I need to extract a single value out of. It re...
let's say I have 2 worksheets.
on one worksheet I have a list of numbers in column a. I scan these in with a scanner.
on the second worksheet I have a list of the same numbers in colum ...
I have a VB code and I applied it in an excel worksheet. It was working perfectly during the time I entered it in ThisWorkbook and then saved it. However, after closing and reopening the sai...
This seems simple, but i can't quite make it work. I have an equation, y=5x+20, that I would like to draw a chart for. Since I don't have any actual data, my first attempt at this was to man...
I have an Excel 2003 spreadsheet with a standard table and columns (attached).
Columns: ID, Status, Assignees, Date Entered, Date Due, Current Date
Rows: Each row signifies a specific inci...
I am using visual basic within Excel to write a macro that will automatically populate the left footer with the file path and file name once the users goes to print the spreadsheet. The code h...
Hi - I have a spreadsheet that uses a table of customers. (The table is on a different sheet called Tables in this workbook and the table has Customer name, Customer address columns). In my...
I have a bunch of entries in excel and I would like to get the average price of "56K Desktop" entries
What excel function should I use?
A B C ...
I am copying a sheet from 1 workbook to another workbook.
the sheet im copying contains some formulas wich becomes static to sheet that it was copied from
How i make the fomulas relative ?
...
Hi,
I have a worksheet for which I have defined a number of ranges that can be changed. However, I'd like only certain ranges to be user-definable; the rest of the ranges must be locked to...
Hi Experts
This is a excel question and not MSP..... i am also trying to do this in excel also
How would i amend the snippet code to make the macro work so that it automatically changes ...
First off, I use excel quite a bit, but never more than the most basic features.
Ok what I've got an excel table that was exported from a mysql database.
It's 3 columns of usernames abou...
I have a very long string of values delimited by a semicolon. Is there a way to do text to row?
Example:
string "aaa;bbb;ccc;ddd"
Need:
aaa
bbb
ccc
ddd
in Excel or with SQL, please.
I have an Excel database where every row is a new data entry. (I'll simplify my database by using an equivalent version here.) Say Aaron and Jonny are collecting coloured marbles on different ...
