Over 1 million tech questions and answers.

Solved: VBA in Excel: Automatically paint borders on data entry

Q: Solved: VBA in Excel: Automatically paint borders on data entry

Afternoon everyone!

I am trying to get a little bit of code working such that when a user enters in some data in column A, it triggers code in VBA to paint a simple surround black border over the whole row, from column A to M. Here is what I have so far, but it doesn't seem to be working. I know I am missing something (if not a lot).
Code:

Dim i As String

If ActiveCell.Column = 1 Then
If ActiveCell.Value <> "" Then
Range(Cells(i, 1),Cells(i, 13)).Borders.LineStyle = Excel.xlLineStyle.xlContinuous
Else
End
Else
End

I appreciate any help! Thank you in advance!

RELEVANCY SCORE 200
Preferred Solution: Solved: VBA in Excel: Automatically paint borders on data entry

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: VBA in Excel: Automatically paint borders on data entry

Hi Maxx, you shouldn't forget to mention the version of Excel you're using

Place this code in the sheet
Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <= 13 Then
If Target.Value <> "" Then
Range("A" & Target.Row & ":M" & Target.Row).Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
Target.Offset(0, 1).Select
End If
End If
End Sub

Read other 2 answers
RELEVANCY SCORE 80.8

on a worksheet i have, i am entering numbers into one cell(a1), cell a2 is a running total of all entries made in a1, this works well enough, is there anyway by using code or formulas that i can also have keep a note of each of the entries made in cell c1, i.e if entries made in a1 are 5,7,11,15, giving a total of 38 in a2, i would like the 4 seperate numbers to be shown elsewhere on the worksheet
 

A:Solved: data entry excel

Read other 10 answers
RELEVANCY SCORE 75.2

Hi all,

I have a monthly report that has a certain column (always column BF) that contains the numbers 1-5, either singly or in any combination thereof. I have to copy this into 5 columns (BQ through BU) and I want those columns titled Q2 - 1, Q2 - 2, Q2 - 3, Q2 - 4 and Q2 - 5.
I need all the 1s in Q2 - 1, all the 2s in Q2 - 2 and so on.
Since the number of items in each cell varies, (there is no 1, , 3,4, , with blanks for non-existing numbers, rather one cell may have 2 and the one below it may have 1,3,5) is there a macro or a formula that would quickly copy every item into the right column?
It isn't vital, I suppose, I can copy, sort and cut and paste, but I would like to save the time....

Thanks in advance
 

A:Solved: Excel 97 - want to automatically move data

Read other 9 answers
RELEVANCY SCORE 74.8

Hi there,

I don't have enough experience in VBA excel or word, and would you mind helping for the following:
Q1
The below macro code add row below the last row. And Would you mind telling me what is the code that can add row for word document table between the last row and the row before the last?

ActiveDocument.Tables(1).Rows.Add

Q2:
My second question is related to export/import between two different programs or files ( Excel and word document)
Would you mind providing me the proper code for
Wordtable.copy
Workbook.xls - sheet1.past speical value
Suppose the word tables excel workbookD sheet 1 are as follow

Table 1 in word document
--------------------
Cell 11 - Cell 12
Cell 12 - Cell 22
--------------------
Table 2 in Word document
------------------------------------
Cell 11 - Cell 12 - Cell 13
Cell 21 - Cell 22 - Cell 23
------------------------------------

WorkbookD.xls Sheet1
Rows Column
A B C D
1
2 wt1.Cell 11 WT2.Cell 11 WT2.Cell 12 WT2.Cell 13
3 WT2.Cell 21 WT2.Cell 22 WT2.Cell 23

How I write a macro to make the value or text in Cell 11. in word table 1 to be copied and past in Cell A2 in sheet1 of WorkbookD.xls
and the value or text of the range from Cell 11 to Cell23 of table 2 or word.doc to be copied and past in sheet1 of WorkbookD.xls from range B23 for n rows in table1 and table 2 of word.doc.

Thanks

Hamdy"
 

Read other answers
RELEVANCY SCORE 72

Hello my fellow databasers.

The Information:
I am currently working for a company that is tracking their part(s)
expenses per each customer job.

All customers' expenses are entered into the same 'primary' workbook so entering information is easier than going to each customer workbook. The column headings are as follows.

Customer Name - Date - Part Used - Cost - Invoice # - Additional Notes

There is 1 primary workbook and then each customer has their own workbook.

I have researched for a week now and am not savvy enough with Excel to know exactly what I should search for. I believe a macro is what I want though.
The question:
How, or what would I do, to have each workbook search for its relative 'Customer Name' and paste (auto populate) the information into the workbooks?

ex. I entered a part for John Doe within Primary Workbook. The second workbook sees John Doe, copies the row of all parts that have John Doe in the first column and populates it in the second workbook.

Also, would I need to create a separate Vlookup first to add a value to my customers so it wasn't text based to help the above equation work?
I know I could copy and paste each one, but sometimes we retroactively change values of costs, and for the amount of time I could save by creating ... a macro? or some formula would be well worth continued research. Any help is appreciated.

Application:

It's important for my employer to be able to see what parts were used ... Read more

A:Solved: Excel 2010: Macro or substitute to automatically copy data between workbooks

hi
A macro can do what you need but have you considered using filters on the primary workbook where you can select the customer name and only those records will be displayed? This will eliminate the need for multiple workbooks and make your life much simpler. An added benefit would be the ability to filter on other criteria like Date Or Part # so you can see across Customers what occurred on a specific date or which customers ordered a specific part.
Alternatively, this would be an ideal application for Access which would make data entry simpler and provide the information you need in the format you need.
 

Read other 2 answers
RELEVANCY SCORE 70.4

When using the excel spreadsheet and entering numbers and letters, it pauses for almost a minute when I click from box to box. What could prossibly be the problem of data entry on excel having a pause when tryin to enter information?

A:Excel data entry pauses

I don't know what would cause this - but would suggest uninstalling the Microsoft Office programs and then reinstalling them.

Read other 1 answers
RELEVANCY SCORE 70.4

Please help.

I'm am on Excel, and in my first column designated as "DATE" 50% of the time when I input a date it will display it in the cell but now it is converting it to a row of #symbols and the input looks like this...

######

this happens no matter what dat I put in now. I have gone up to Format, cell and it tells me it is set to display DATE but I'm only getting: ######
And now it is doing it randomly in my Dollar amount column too.
Please Advise,

Thank you so much
 

A:EXCEL Data Entry Problem

Read other 7 answers
RELEVANCY SCORE 70.4

Hey,

I have made a worksheet and I have this cell range A to S. Now I want that used must put data in cell range A to R. Can anyone help?

Thank you
 

A:Excel Force Data Entry

With thanks to Zack Barresse: try this link: http://www.vbaexpress.com/kb/getarticle.php?kb_id=364

P.S. At ALL time please mention your Excel version!
 

Read other 1 answers
RELEVANCY SCORE 70.4

Hello,

Is it possible to keep track of data entries in Excel?

I have daily report log that I need to maintain between several users. I have 'completed' and 'pending' column as well as 'date' column

What I am trying to achieve?

I am hoping to create an 'OVERVIEW' sheet where:
- I can display number of 'completed' task (I have managed to achieved this)
- Display number of 'pending' task (managed to achieved this)
- Display number of newest entries, (perhaps identified by the latest 'date') -is there any formula to do this?

Thank you for your kind help. Much obliged.
 

A:Is it possible to keep track data entry in Excel

Read other 7 answers
RELEVANCY SCORE 70.4

I use Win XP, Excel 2002 and have just encountered an issue I cannot solve. When working with cells formatted for either numbers or currency, entry of a number shows an extra 12 places to the left of the decimal when no decimal is entered (123 becomes 1230000000000). If a decimal is entered (123.), the number displays and functions properly. When I change the format of the cells involved to text, the following is displayed when a whole number (123) is entered: 1.23E+12 I have opened new files without modifying the format at all and this is still occurring. What is going on??
 

Read other answers
RELEVANCY SCORE 68.8

Hello. I need help finding a solution to a specific problem I'm facing. I need to import data automatically from an Excel spreadsheet into a web-based form multiple times (over 300 times in fact) The data is neatly organized in the spreadsheet and each field in the web form directly correlates to a column in the spreadsheet. So I don't think this should be too terribly difficult to accomplish. The only problem is that in addition to text fields, the form also features drop down menus. But like i said, there is data in the spreadsheet that directly correlates to a selection in the drop down menu.

So, to put if briefly the following needs to happen:
1. The data is input from the spreadsheet to the web form.
2. A button needs to be clicked to submit the form.
3. A link needs to be clicked to bring the form up again.

This needs to be repeated until all the data is entered.

I think I've covered everything. I hope I've made it as clear as possible. Thanks a lot for your help! This would be saving me hours upon hours of work.
 

A:Automated web form data entry from Excel spreadsheet?

You could write an AutoHotkey script to do that. You would need to:

Activate the Excel spreadsheet window. (WinActivate)
Go to a particular cell in the spreadsheet. (Send tabs)
Copy the data. (Send Ctrl-C)
Activate the browser window. (WinActivate)
Go to a particular box in the web form. (MouseMove)
Paste the data. (Send Ctrl-V)

Then put all of that into a loop to run as many times as the number of cells to be copied. (Loop)

Submit the form. (MouseClick)
Bring up a new form. (MouseClick)

Then put all of that into a loop to run 300 times. (Loop)

The terms in the parenthesis like "WinActivate" and "MouseClick" are the actual AutoHotkey commands you would use.
 

Read other 2 answers
RELEVANCY SCORE 64.8

Hi Guys,

I've an excel sheet which has some data and I want that excel to be automatically mailed every month end to few mail ID's. How to acheive this ?

-santhu
 

A:Excel should mail its data everymonth end automatically

Read other 11 answers
RELEVANCY SCORE 64.8

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

Read other answers
RELEVANCY SCORE 64.8

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

A:Excel: Automatically import data from another workbook

bparker said:

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you canClick to expand...

Hi bparker - Not sure I'm reading your intent right, but if you can save the "19991118damlbmp_zone" etc sheets into a book on the desktop you name "Book11" and then open a new book called "Book10" and run the code from Book10 - you can use something like this:

Code:
[SIZE=2]Sub COPYIT()
'this is run from the book named Book10
Dim N%
Application.ScreenUpdating = False
On Error Resume Next '<< error is - "books already open"
Workbooks.Open Filename:="C:\WINDOWS\Desktop\Book11.xls"
For N = 1 To Sheets.Count
Workbooks("Book11.xls").Activate
Sheets("Sheet" & N).Select
Range("A1", Range("A65536").End(xlUp).Rows.EntireRow).Select
Selection.Copy
Windows("Book10.xls").Activate
Sheet... Read more

Read other 3 answers
RELEVANCY SCORE 63.6

I have a spreadsheet that connects to a database.
When I open the spreadsheet, I got asked if I wanted to refresh the data. I did so, and clicked yes.
Some time later, after getting bored ticking 'yes' every time I opened the sheet I ticked the 'don't ask me again' button.
Now every time I open a sheet that pulls data from a remote data source, it automatically connects and updates the data - I no longer want this to happen!!!!! Any way I can switch this off as easily as I switched it on????

andy
 

A:how do i stop EXCEL automatically updating from a remote data source?

hilight all live data and right click and select Data Range properties. Remove the tick from Enable Background Refresh. then ok then Save.
 

Read other 2 answers
RELEVANCY SCORE 63.6

Hi,

I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

So that the excel size won't be that big and also it saves processing time.
 

A:Solved: Access data export into Excel as the data linked to excel.

Read other 16 answers
RELEVANCY SCORE 62.4

Hey guys

I am using Excel 2007 and have a massive spreadsheet which is hard to read when printed out on my non-color laser printer.

Is there a way to automatically enter a border every 5 lines to separate the data for easier reading?

For example for a three line border:

aaaa bbbb cccc dddd eeee

dddd eeee gggg hhhh gggg

kkkk nnnn oooo pppp qqqq
------------------------------------------------
aaaa bbbb cccc dddd eeee

dddd eeee gggg hhhh gggg

kkkk nnnn oooo pppp qqqq
------------------------------------------------
aaaa bbbb cccc dddd eeee

dddd eeee gggg hhhh gggg

kkkk nnnn oooo pppp qqqq

The dashes represent the lines which would allow the eye to follow the same row to the far right.

Hope someone can help me. It would be a real chore to manually enter the borders.

Thanx.

Brian
 

A:Entering borders automatically

Matbe this sort of thing?
Code:
Sub rulelines()
Dim i As Integer
Dim oRng As Range
For i = 5 To 35 Step 5 ' alter to suit
Set oRng = Sheets("sheet1").Range("A" & CStr(i))
With oRng.EntireRow.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
End With
Next i
End Sub

 

Read other 2 answers
RELEVANCY SCORE 60.4

For the last week or two, my computer has slowed down drastically when I am entering search data on Amazon, newegg, ebay, and other sites. I have to type one letter at a time and wait a few seconds for the next letter to enter.

I have all kinds of security, spyware, and anti-virus software installed and think it might be my modem, I bought a new Motorola modem which did not help. Cox Cable told my that my previous modem was very old which is true.

I am using Internet Explorer 8 on Windows 7 Professional. All other typing on the computer is OK and will accept data as quickly as I can enter it.

Any ideas on what might be causing this?

Thanks
 

A:Solved: Slow data entry

Read other 8 answers
RELEVANCY SCORE 60

hi all

i nave a userfom that is activated from a button on sheet1, a listbox is shown for the user to make a selection, this then is shown in cell p3 on sheet2, the problem is if i lock the cell and then protect sheet2, an error keeps appearing, i need the sheet protected and there are 2 cells that are unlocked for data entry, but i need cell p3 to be protected.
 

A:Solved: cell locked/data entry

If the cells does not need to be unlocked for use, then all you need is to Unprotect and Protect the sheet in your button code

Button is pressed

If listbox value <>"" then
sheets("Sheet2").Unprotect
Sheets("Sheet2").Range("P3") = lisbox value
sheets("Sheet2").Protect

If the sheet is protected with a password you can add the passwrod to the lines

sheets("Sheet2").Unprotect Password:="your password as text"

sheets("Sheet2").Protect Password:="your password as text"

If you need some help, just holler
 

Read other 2 answers
RELEVANCY SCORE 60

Hello. Thanks in advance for any help that this forum can provide in solving this problem.

I have a form in access based on tblSubmissionTracker that has some comboboxs that allow a user to select predefined values for records to be updated to tblSubmissionTracker. This all works good.

The fields in tblSubmissionTracker are Country, Sector, Business, Report_Date, Submitted.

Inside the form, I have a subform, subfrmContactDisplay, that is based on tblContacts. subfrmContactDisplay is set to display the following fields from tblContacts: Country, Sector, Primary Contact, E-mail, and some others.

What I want to happen is each time a user enters a selection for country, business in the main form the subform shows the corresponding tblContact record for that country sector combination (each business is linked to a sector, and the sector populates in the main form via a list box linked to a query, which uses the business selected in the main form as a parameter). I also want to be able to edit fields in that record, should they need editing.

I've placed code on the change event of the business combobox to requery the sector list box and then requery the subform.

Through the process of building this I haven't been able to get it to work properly. I've tried playing with many of the options, but to no avail. Sometimes I get some parts working, other times, I don't. Right now, I have the mainform set to data entry and all edit options checked to yes (add, de... Read more

A:Solved: Data Entry Form with SubForm

It sounds like you may be over complicating it.
First of all if you set the mainform to Data Entry = yes it means you can only enter new records in it.
Second you should not need to requery the Subform if the Master/Child links are working correctly.
Can you post a zipped Access 2000-2003 version on here with some simple dummy data.
Or at least post a Screen Print of the Table Relationships and the Forms in design view.
 

Read other 2 answers
RELEVANCY SCORE 60

Hello, I have a form/subform data entry question.

When a name and date is entered into my Main form, any existing records for that name/date combination are displayed in the subform. If the data entry operator wants to add additional records for that name/date combination, depending on the number of existing subform records, he may have to scroll to the last subform entry in order to view a blank new record. How can I get the subform to display a blank record at the top to eliminate the need to scroll?

Thank you for your help.
 

A:Solved: AC2007 - SubForm Data Entry

Unfortunately as far as I know you can't.
What you can do is add a Command button that takes the user to a new record, the command button Wizard will create this for you.
 

Read other 2 answers
RELEVANCY SCORE 59.6

Running XP and Office Basic 2007. Each time I go into Excel it does a configuration before opening. If I cancel the configuration it will still open and run. How do I stop this from happening?
 

A:Solved: Excel does a configuration on entry

Read other 9 answers
RELEVANCY SCORE 59.2

I run Office 2000 on a Win XP Pro system. I've been using MS Office since the early 90's, so I know the basics of Excel pretty well. And now I have a seriously weird problem!

I have a simple spreadsheet I've been using for several years. Today, for no detectable reason, when I enter a number, it appears as if divided by 100. That is, I enter 1, it appears as 0.01. I enter 100, it appears as 1.

I've checked formatting etc, and nothing has changed. I tried creating a totally new spreadsheet, but got the same result.

It's not a big problem, as in 5 minutes I can reproduce the whole thing in OpenOffice Calc, and it will work fine. But I'm bemused, and wondering if anyone else has had this happen.

Oh, and right at this moment I'm running a virus check!

I've attached a copy of the spreadsheet in case anyone would like to take a look.
 

A:Solved: Excel Number Entry Problem

Read other 9 answers
RELEVANCY SCORE 58.8

I was losing track of things on my website, so I thought a data base would be very helpful. I've set out to learn Access, but I'm still a beginner and I'm stuck on 3 things so far.

I have set up and related several tables including:
website pages (title, description, date written, etc.) auto number primary key
graphics (file name, size, description) file name primary key
keywords (word, stat1, stat2, stat3) word primary key

I've also set up junction tables since the website pages table has a many to many relationship with both graphics and keywords.

Question 1: How do I make a form that has multiple sub-forms?

I tried to use the wizard to make a data entry form. I wanted a form with multiple sub-forms.
If I enter the fields from 2 tables, I can easily make a form with a sub-form. If I enter fields from all 3 tables, the wizard acts completely differently and I can't figure out how to do sub-forms.

Question 2: How can I make a combo box that will cover multiple fields at once?

I fill the graphics table as I make the graphics. I wanted to use a combo box so I could choose an existing graphic OR add a new one. The combo box works fine for the file name.
The problem:
I want it to auto fill the size and description if I choose an existing file name OR allow me to enter size & description if I enter a new file name.

Question 3: How can I handle many to many relationships between records within one table?

I want to track links from each page to ... Read more

A:Solved: Access 2003 Data Entry Forms - beginner needs help please

Read other 16 answers
RELEVANCY SCORE 58.8

I have a database with approximately 15 tables and forms. There is a form created for every table. When a form is updated, I want the other forms with the same fields to also automatically update without having to re-enter the information in a different form. Is this possible? Please advise.

Thanks,
Tonya
 

A:Solved: Access 2007: Forms for Data Entry-Update

Read other 8 answers
RELEVANCY SCORE 58.4

hey,
just wondered if anybody knew of a possible way to lock the borders of an excel sheet. i have attached one week of a works diary i made using excel but just have a problem with the borders. this file is shared in our office network and gets edited hourly by all different staff. jobs usually get put back a day or two or get assigned to a different member of the electrical team. when office staff drag the data in one cell and move it to another it takes the border with it and after a while all the borders become out of place and it looks v.messy so i have to spend time re-doing all the borders so its easily visible again.

i understand that you can do a paste special and just copy the values, but surely there must be some way to lock the borders of cells or make them a background of some sort

any ideas welcome

thanks

d3ell
 

A:Excel borders

I am not really sure what you mean by "borders" here. Are you trying to make it so a column always has a fixed width? Do you want the column to always be visible? In your file, is it column E that you are referring to? If so, it would be somewhat easier to do this if your column E was actually column A and you could either freeze the pane or split the window so it was always visible.
You could also format the cells so that either the text would wrap or would shrink to fit (I would recommend wrapping - shrinking can make it illegible rather rapidly).
 

Read other 3 answers
RELEVANCY SCORE 58

Hello,

I have two problems:

1.
I have a lot of scanning data, all date and time stamped. All the scans show different status of shipped packages (all shipments have unique ID#, but there are multiple scans on route for all of them to track the packages). I want to find all the packages, for which there was "misdirected" scan, then for all of them, show the scan before. So, the end result would be all the scans that show for each package where it was misdirected (the terminal# of the scan before the misdirect scan).

2.
I want to automate this: run 5 queries every two hours between 8am and 10pm, copy and paste all results into Excel to specified areas (e.g. first query results to A1, second to A5000, third to A10000, etc. or onto different tabs), save as .csv to a specific folder, then send it as attachment to a given e-mail address. Even partial solution can be good.
I only know macros (somewhat), not as much VBA, so I tried that with the TransferSpreadsheet command, but can't get it work.

Any help is greatly appreciated.
 

A:Solved: ACCESS: Show second latest data and export data to excel from macro

Read other 14 answers
RELEVANCY SCORE 58

Excel 2003 SP3
Could anybody suggest a way, using whatever method you prefer to copy existing data to another tab, but have the data go transparent by 50%(or thereabouts, so you can just see it), but keep the headings normal font.
Thanks
 

A:Solved: Excel 2003 help to copy data to new tab and make data transparent

Read other 6 answers
RELEVANCY SCORE 58

When i export my inventory from my DB into an excel file, my trailer brands are listed as they are in my DB (of course). But when i bulk upload them with XML feed to trailer inventory sites (HTW.com & HTT.com for our example here). My inventory is listed on their site, but it's not searchable because the brand search is a drop down menu on these sites.

Say i goto HTW.com and do a search for 'Blue Ribbon' trailers none of my blue ribbon trailers show up because all of mine are listed as 'BLUE RIBBON TRAILERS, LTD' and the site is searching for 'Blue Ribbon' and although they are the same trailer brand HTW.com does not see them.

What i'm looking for is maybe a Macro or even formula that once i tell it what site i'm working on, will go through my list and replace all my spellings with the proper ones for that site...

Attached is an XLS file with 3 columns, the first is my list as is from my DB, the other 2 columns are the proper spelling for each corresponding site...

Excel's find and replace feature is a VERY crude fix to this, but since it's so time consuming it's NOT a viable solution.

Any takers??

Slurpee? Zack? Anyone??
 

A:Solved: Excel -Macro or Formula? Replace my data with similar required data - sample

for the record, a complete solution would be GREAT, but not necessary...
I just need someone to point me in the right direction and maybe a small working sample of like 5 brands and i'll expand the list from there...

cheers
 

Read other 3 answers
RELEVANCY SCORE 57.6

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

A:Solved: Excel macro to extract Word form data into Excel

Read other 7 answers
RELEVANCY SCORE 57.6

I've created a spreadsheet and have formatted each cell/row/column with appropriate borders. It looks fine on my two computers (MacBook and Mac desktop) when I create a PDF through the print format. However, when I send the PDF to someone else, the formatted borders disappear irregularly on her PC. When she creates her own PDF from the .xls document, she continues to have problems with inconsistent borders. Cell fill is empty. Any recommendations? Thanks.
 

A:Excel borders disappearing

Hi there, welcome to the board!

Is this a print issue on the PC as well? Or just viewing? If it's just a viewing problem, I'm thinking it might be a display issue.
 

Read other 1 answers
RELEVANCY SCORE 57.6

Whenever I print from excel 2003, wherever I have a page break the borders get really messed up. I have them all formatted correctly and the borders show up fine in the normal and page break views but in the print preview and actual print outs half of them are missing. For ex cells A1-A5 will have a dark border on the left but A6-A13 have nothing on the left then A14-A20 will have the dark border on the left. Any suggestions?
 

Read other answers
RELEVANCY SCORE 57.2

I wish to know if it is possible to update a field on one sheet with the last entry of another sheets column?

as info is added to one sheets column the data on the other sheet is automaticall altered to show the last entry in the first sheets column where i entered the data in the first place
 

A:Solved: EXCEL: update field on one sheet with the last entry of another sheets column

Read other 16 answers
RELEVANCY SCORE 56.8

Dear friends:

Please see screenshot. For some reason, the column borders are missing. The entries are copies from another Excel list.

Would appreciate your help.

Thank you.

Benjamin
 

A:Excel Column Borders Missing

Read other 13 answers
RELEVANCY SCORE 56.8

All of a sudden my excel worksheets with borders &/or shading will print the first copy with borders/shading. All other copies on multiprint request have no borders &/or shading?? (all text is in it's place) Could my trying out F11 on worksheets to produce charts have caused a problem in the applications files? It is the only thing I can think of I did differently than normal prior to this problem arising.
 

A:[Resolved] Excel 97 worksheet borders

Sounds to me like you need to take the steps in Article III under hard drive maintenance:

Tech Support Guy's April Newsletter
 

Read other 2 answers
RELEVANCY SCORE 56.8

I have a column of cells on a form I am creating where I don't want the same value repeated (input by the user). When the value is repeated, I would like a message box to appear telling the user to change the value to something else. I would also like the border of the row of cells containing the cell in error to change to a bold red. I don't think the code is very complicated but I'm just getting started in macros. Also, I would like this to happen as the user goes from cell to cell (i.e. not when a command button is pressed or the worksheet opened). Can someone please help me? Thanks.
 

A:Excel Macro Advice - Borders

Before you go down the macro route, check this article from an MVP -- http://www.contextures.com/xlDataVal07.html#Unique
 

Read other 3 answers
RELEVANCY SCORE 56.8

Please help ,

I have one sheet with headings,with 50 more sheets which include data,in data we have one emp code which is unique and more data for that emp.,format in all the sheets is same except the summary sheet(main sheet),what i want when i enter the Emp code in suumary sheet,the excel automatically search the data from subsquent sheet (basis emp code)and enter the data in next columns against emp code in summary sheet.

Regds
Mayank s
+919376914028,
 

A:Solved: Transfer of data from different excel to main excel

Read other 12 answers
RELEVANCY SCORE 56.4

I have a form to update the hardware of a PC for an asset database (see image attached), it features a main form which shows the current information for that computer and a subform which creates a new record for that PC with all the new information. The problem is that when i enter new information into the subform and click onto the main form it automatically creates and saves the new record which is what i want to stop.
I would like the subform to save/cancel the data entry through the save and cancel buttons i have rather then it creating a new record automatically.
Any help would be appreciated.
 

A:Solved: Microsoft Access 2007-2010: Stopping Automatic Saving On Data Entry Form

Read other 8 answers
RELEVANCY SCORE 55.6

Hi All,

I need to make a macro that will add borders to certain cells.
I have a generated report from another product so I don't know how many rows there will be until the report is generated. The number of rows is specified inside the report, so I do have access to it. It is stored in cell C5.

So what I want to do is add borders around C5 number of rows starting at A7..E7

I tried using a rule, to just put borders around cells that contain data, but that won't work because sometimes cells are blank and I still want the border around them.

Help?! Please

Thanks a bunch!!!
Lori
 

A:Excel Macro to add borders based on cell contents?

Hi Lori

Here is a macro that will take the value in C5 e.g. 10 and then apply borders to all cells in A7 to E16
Code:
Sub add_borders()
lRow = Range("C5") + 6
Range("A7:E" & lRow).Select
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlC9ontinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
End Sub
 

Read other 1 answers
RELEVANCY SCORE 55.2

Excel is automatically saving documents as a pdf. When I click save as the document says excel spreadsheet but when the document is saved it is a pdf. Please help.
 

A:Solved: excel automatically saving as pdf

Read other 7 answers
RELEVANCY SCORE 55.2

I have tried creating a data access page several different ways, but am unable to add, edit, or delete my data. I can view it. I've even started from a new database with one table, but am still unable to edit or add data. I've checked the properties of which appear to be fine. Has anyone else had this trouble? I'm using Access 2003.
 

Read other answers
RELEVANCY SCORE 54.4

Hi, I am trying to automatically have sorted in excel 2 columns in sheet 2 with data linked with sheet 1 so that when you enter data in sheet 1, the data in sheet 2 is being automatically sorted.

My data on sheet 2 are in 2 columns: Project ID and Score. The data are in cells B2 to B101 and C2 to C101.

The data in sheet 2 are linked to data on sheet 1. The "project ID" column (B2 to B101) of sheet 2 is linked to cells D8 to CY8 and the "score columns (C2 to C101) of sheet 2 is linked to cells D79 to CY79.

The idea is that when score is entered in sheet 1, the project ID and score of sheet 2 gets automatically sorted so that we see at the top which project has the highest ranking.

Can someone help me out with the code to use? I am a beginner...

Thank you!!

ps: it is quite urgent
 

A:Solved: automatically sorting in excel 2003

Read other 16 answers
RELEVANCY SCORE 54.4

I have a rather large file that I would like to print. I have other files like it that were done in Excel and they came out just like I wanted them to. The entries are arranged in rows and columns. I was able to number the rows and put headers over each column. The one in question is arranged in rows but not in columns. I can open it in Excel but I have no idea how to get it to arrange into columns. Is there any way Excel can do this for me? I'd really rather not do this manually because there are over three thousand rows that need to be in 12 columns.
 

A:Solved: Can Excel automatically arrange columns for me?

Read other 13 answers
RELEVANCY SCORE 54.4

I have the follow code behind the ThisWorkbook_Open Event:
Code:

If Weekday(Date, 1) = 6 Then
'Do nothing
Else
ThisWorkbook.Close
End If

Is this the best way to perform this operation?

Also, if the day was not yet Friday, how would I keep the workbook from closing if I needed to open it for modifications?
 

A:Solved: Excel VBA Automatically Close Workbook

Read other 8 answers
RELEVANCY SCORE 54.4

I have an entire column of data that I need in one cell. When combined I need each piece of data to be surrounded by " " and a , between each one.

151
183
2001

results = "151","183","2001"
 

A:Solved: Excel Column of data place in one cell with "data", "data" results

ASAP's "Merge row data" ("Columns and rows" category) will do 99% of the work for you.

http://www.asap-utilities.com/

(edit: "entire column" -- do you mean full from top to bottom? )
 

Read other 2 answers
RELEVANCY SCORE 54

Hi, I have approx 25,000 rows of data relating to parts held in inventory, on a spreadsheet in Excel 2003 SP2 .

One common cell on each line is the Supplier Stock Code and the data in it is duplicated on different rows as the same Supplier Part is held under several different Part ID's on our system, ie,

Cell A2 0-320311-00
Cell A3 0-320311-00
Cell A4 0-320311-00
Cell A5 0-330317-29
Cell A6 0-330317-29
Cell A7 0-330317-29
Cell A8 03400BK08345
Cell A9 03400BK08345
Cell A10 03400BK08345
Cell A11 03400BK08345

I have sorted the data into Supplier Stock Code order and need to find a way to automatically insert a blank row (or two) after each change, ie, in the example above it would be between rows 4 & 5, and 7 & 8.

Does anyone know of a Macro which will do this?

Many thanks,

MarG38
 

A:Solved: Excel Macro to automatically insert rows

First things first -- welcome to the board.

2nd thing:

"insert a blank row (or two) after each change"

Hmm: for what purpose? The "official" line is "DON'T do that, it's VERY bad design". K?

So what I did was drag your last entry down to r25000, to generate 03400BK08346,
03400BK08347, and so on. "Test data".

Then I ran the code at the bottom of this post. It ground away for 12 minutes (make coffee, visit bathroom, yada yada) & then fell over on account of "ran out of worksheet" (bear in mind I had c.25K unique values, you have far fewer).

Last (but most definitely not least) thing: back up your work before trying the code.

HTH

Sub test()
Application.ScreenUpdating = False
LastVal = Range("A" & Rows.Count).End(xlUp)

Do Until LV2 = 1
x = Range("A" & Rows.Count).End(xlUp).Row
x = Range("A" & x).End(xlUp).Row

If Cells(x, 1) = LastVal Then
LV2 = 1
Else
y = Application.Match(Cells(x, 1), Columns(1), 0)
z = WorksheetFunction.CountIf(Columns(1), Cells(x, 1))
Cells(y + z, 1).Resize(2).EntireRow.Insert
End If
Loop

Application.ScreenUpdating = True
End Sub
 

Read other 2 answers