Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access to Excel to (MSDOS)CSV
I have a table in Access XP that I currently export to excel then I perform the following steps: 1. Delete Row 1 (Header row) 2. Set the format on Column A to "Alignment" - Left (Indent) 3. Set the format on Column B to "Number" - 2 decimal places 4. Set the format on...- tomw99
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel - Updating data in a cell based on compare of two other columns
Thanks.... that was the perfect solution!!!- tomw99
- Post #3
- Forum: Microsoft: Office
-
Excel - Updating data in a cell based on compare of two other columns
I have two sheets: Sheet One Item# - Description - Price 12345 - Orange - ????? Sheet Two Item# - Description - Price - Units......Much more data 23456 - Apple - $2.33 65432 - Pear - $1.45 12345 - Orange(LB) - $1.89 I need a formula for the price cell in sheet one that...- tomw99
- Thread
- Replies: 2
- Forum: Microsoft: Office
