I am not very good at Excel and this Forum has helped me in the past so i am asking another question. I have a file that is created automatically for our Bar Code software and i have to modify the file before i can use it. It has a column with a cost and every cell has a different cost. Some of the cells need to be modified. Example If the cell says $8.99 I need it to be $9.99. The dollar signs do not show on the sheet just shows 8.99. I know there must be a way to do this faster than one cell at a time copy and paste.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
@If
- Thread starter Jafwiz
- Start date
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,198
- Office Version
- 365
- Platform
- Windows
- Mobile
It probably isn't Excel blocking it but Windows because it is a downloaded file.
In the XL2BB instuctions is the link below. Try the instructions at the bottom of the "Preparing to Install the Add-In" section.
Install an Excel Add-In - Peltier Tech
A lot of Excel procedures are packaged in Add-Ins. An Add-In is basically a workbook containing some code, that has some other unique properties. An add-in usually has some user interface elements, such as buttons on the ribbon or on context (right-click) menus, so you can access its features...
Upvote
0
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
This is what the sheet looks like.
I need column 7 that has i first number to be changed to the second number so if it shows 10.99 it needs to be 12.99 If it shows 16.99 change to 17.99
8.99-9.99
10.99-12.99
11.99-12.99
13.99-14.99
15.99-17.99
16.99-17.99
20.99-24.99
22.99-24.99
23.99-24.99
25.99-29.99
26.99-29.99
28.99-29.99
| Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 |
96801 | EVALFA | 8377DRB | 698298069580 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8377SRB | 698298069573 | MADE IN | USA | 1 | ||
96801 | EVALFA | 1009B | 695066473334 | MADE IN | USA | 1 | ||
96801 | EVALFA | 1009C | 695066473341 | MADE IN | USA | 1 | ||
96801 | EVALFA | 1009N | 695066473358 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8359DRW | 695066510947 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8359GRW | 695066613259 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8359SRW | 695066610067 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8377DRK | 698298056146 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8377DTK | 698298078155 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8377SRK | 698298069641 | MADE IN | USA | 1 | ||
96801 | EVALFA | 8377STK | 698298078209 | MADE IN | USA | 1 | ||
96805 | DISKNI | 0651C2 | 695066010720 | USA | $18.00 | 25 | ||
96411 | TALKMO | 0586D70 | 698298090096 | MOSAIC | INDIGENOUS | 20.99 | 7 | |
96411 | TALKMO | 3426D2 | 695066031053 | MOSAIC | INDIGENOUS | 13.99 | 7 | |
96411 | TALKMO | 8073C03A | 695066484095 | MOSAIC | INDIGENOUS | 22.99 | 7 | |
96411 | TALKMO | 8080BD | 695066410094 | MOSAIC | INDIGENOUS | 11.99 | 9 | |
96411 | TALKMO | 8073DRB | 698298087027 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 8073SRB | 698298106391 | MOSAIC | INDIGENOUS | 16.99 | 7 | |
96411 | TALKMO | 8077DRB | 698298097415 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 2326V2 | 698298109354 | MOSAIC | INDIGENOUS | 20.99 | 7 | |
96411 | TALKMO | 2643C | 695066025786 | MOSAIC | INDIGENOUS | 25.99 | 7 | |
96411 | TALKMO | 6770V | 698298109330 | MOSAIC | INDIGENOUS | 19.99 | 9 | |
96411 | TALKMO | 0203VM | 698298108807 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 0574V2 | 698298108685 | MOSAIC | INDIGENOUS | 14.99 | 4 | |
96411 | TALKMO | 0582V | 698298107084 | MOSAIC | INDIGENOUS | 14.99 | 4 | |
96411 | TALKMO | 0584V | 698298108647 | MOSAIC | INDIGENOUS | 14.99 | 4 | |
96411 | TALKMO | 0585V | 698298109651 | MOSAIC | INDIGENOUS | 14.99 | 4 | |
96411 | TALKMO | 0811C6 | 698298149923 | MOSAIC | INDIGENOUS | 22.99 | 4 | |
96411 | TALKMO | 1059C | 698298145307 | MOSAIC | INDIGENOUS | 13.99 | 4 | |
96411 | TALKMO | 1185C | 695066098162 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 4643V1 | 698298109606 | MOSAIC | INDIGENOUS | 14.99 | 4 | |
96411 | TALKMO | 5056C | 695066064167 | MOSAIC | INDIGENOUS | 19.99 | 4 | |
96411 | TALKMO | 5057C | 695066064198 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 5058C | 695066064211 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 5058CE2 | 698298128935 | MOSAIC | INDIGENOUS | 19.99 | 4 | |
96411 | TALKMO | 5058CT2 | 698298129390 | MOSAIC | INDIGENOUS | 19.99 | 4 | |
96411 | TALKMO | 5060V | 698298109613 | MOSAIC | INDIGENOUS | 19.99 | 4 | |
96411 | TALKMO | 5068C | 695066064501 | MOSAIC | INDIGENOUS | 19.99 | 4 | |
96411 | TALKMO | 5111V62 | 698298109620 | MOSAIC | INDIGENOUS | 17.99 | 4 | |
96411 | TALKMO | 5128V | 698298108715 | MOSAIC | INDIGENOUS | 14.99 | 4 | |
96411 | TALKMO | 5140C | 695066066871 | MOSAIC | INDIGENOUS | 17.99 | 4 | |
96411 | TALKMO | 5386C | 698298145505 | MOSAIC | INDIGENOUS | 13.99 | 4 | |
96411 | TALKMO | 6079C3E | 695066101893 | MOSAIC | INDIGENOUS | 17.99 | 4 | |
96411 | TALKMO | 6445V | 698298108739 | MOSAIC | INDIGENOUS | 22.99 | 4 | |
96411 | TALKMO | 6526V62 | 698298109576 | MOSAIC | INDIGENOUS | 19.99 | 4 | |
96411 | TALKMO | 6532V81 | 698298109569 | MOSAIC | INDIGENOUS | 20.99 | 4 | |
96411 | TALKMO | 6929V | 698298108746 | MOSAIC | INDIGENOUS | 19.99 | 4 | |
96411 | TALKMO | 8080D62 | 698298106483 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 9752D62 | 698298106544 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 9753S62 | 698298106513 | MOSAIC | INDIGENOUS | 16.99 | 4 | |
96411 | TALKMO | 0104D60 | 695066613426 | MOSAIC | INDIGENOUS | 17.99 | 4 | |
96411 | TALKMO | 0106D60 | 695066613464 | MOSAIC | INDIGENOUS | 17.99 | 4 | |
96411 | TALKMO | 0106S60 | 695066613471 | MOSAIC | INDIGENOUS | 17.99 | 6 | |
96411 | TALKMO | 0200S61 | 698298050458 | MOSAIC | INDIGENOUS | 17.99 | 6 | |
96411 | TALKMO | 0202D61 | 698298050892 | MOSAIC | INDIGENOUS | 17.99 | 6 | |
96411 | TALKMO | 0586D60 | 698298081391 | MOSAIC | INDIGENOUS | 17.99 | 5 | |
96411 | TALKMO | 0587D61 | 698298081872 | MOSAIC | INDIGENOUS | 20.99 | 6 | |
96411 | TALKMO | 1279D603 | 695066613624 | MOSAIC | INDIGENOUS | 17.99 | 4 | |
96411 | TALKMO | 6269D61 | 695066610227 | MOSAIC | INDIGENOUS | 17.99 | 5 | |
96411 | TALKMO | 0900L | 695066011451 | MOSAIC | INDIGENOUS | 16.99 | 5 | |
96411 | TALKMO | 5035C | 695066063627 | MOSAIC | INDIGENOUS | 16.99 | 5 | |
96411 | TALKMO | 5036C | 695066063641 | MOSAIC | INDIGENOUS | 16.99 | 5 | |
96411 | TALKMO | 5037C | 695066063672 | MOSAIC | INDIGENOUS | 16.99 | 5 | |
96411 | TALKMO | 0104C | 695066050887 | MOSAIC | INDIGENOUS | 14.99 | 7 | |
96411 | TALKMO | 0104N | 695066117740 | MOSAIC | INDIGENOUS | 14.99 | 7 | |
96411 | TALKMO | 0106DRW | 695066009069 | MOSAIC | INDIGENOUS | 14.99 | 7 | |
96411 | TALKMO | 0584VR | 698298109446 | MOSAIC | INDIGENOUS | 13.99 | 5 | |
96411 | TALKMO | 0586DRW | 698298080820 | MOSAIC | INDIGENOUS | 14.99 | 5 | |
96411 | TALKMO | 0715V1 | 698298109439 | MOSAIC | INDIGENOUS | 13.99 | 7 | |
96411 | TALKMO | 0715V2 | 698298109422 | MOSAIC | INDIGENOUS | 13.99 | 7 | |
96411 | TALKMO | 1091D2 | 695066012717 | MOSAIC | INDIGENOUS | 13.99 | 7 | |
96411 | TALKMO | 1091S2 | 698298047823 | MOSAIC | INDIGENOUS | 13.99 | 7 | |
96411 | TALKMO | 1279DRW3 | 695066169121 | MOSAIC | INDIGENOUS | 14.99 | 5 | |
96411 | TALKMO | 1279SRW3 | 695066348335 | MOSAIC | INDIGENOUS | 14.99 | 5 | |
96411 | TALKMO | 1391C3E | 695066014865 | MOSAIC | INDIGENOUS | 16.99 | 7 | |
96411 | TALKMO | 3215VR | 698298108548 | MOSAIC | INDIGENOUS | 16.99 | 5 | |
96411 | TALKMO | 5200DRW | 695066559755 | MOSAIC | INDIGENOUS | 14.99 | 4 | |
96411 | TALKMO | 5388V | 698298109408 | MOSAIC | INDIGENOUS | 17.99 | 4 | |
96411 | TALKMO | 8405DRW | 698298052254 | MOSAIC | INDIGENOUS | 14.99 | 5 | |
96411 | TALKMO | 8073DRK | 698298090676 | MOSAIC | INDIGENOUS | 10.99 | 7 | |
96411 | TALKMO | 8405DRK | 698298056627 | MOSAIC | INDIGENOUS | 10.99 | 7 | |
96411 | TALKMO | K-AZ03-B | 698298054579 | MOSAIC | INDIGENOUS | 10.99 | 7 | |
96411 | TALKMO | K-AZ03-C | 698298054586 | MOSAIC | INDIGENOUS | 10.99 | 11 | |
96411 | TALKMO | K-AZ04-B | 698298054630 | MOSAIC | INDIGENOUS | 10.99 | 9 |
I need column 7 that has i first number to be changed to the second number so if it shows 10.99 it needs to be 12.99 If it shows 16.99 change to 17.99
8.99-9.99
10.99-12.99
11.99-12.99
13.99-14.99
15.99-17.99
16.99-17.99
20.99-24.99
22.99-24.99
23.99-24.99
25.99-29.99
26.99-29.99
28.99-29.99
Upvote
0
| Book1 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | ||
| 2 | 96801 | EVALFA | 8377DRB | 698298069580 | MADE IN | USA | 1 | ||||
| 3 | 96801 | EVALFA | 8377SRB | 698298069573 | MADE IN | USA | 1 | ||||
| 4 | 96801 | EVALFA | 1009B | 695066473334 | MADE IN | USA | 1 | ||||
| 5 | 96801 | EVALFA | 1009C | 695066473341 | MADE IN | USA | 1 | ||||
| 6 | 96801 | EVALFA | 1009N | 695066473358 | MADE IN | USA | 1 | ||||
| 7 | 96801 | EVALFA | 8359DRW | 695066510947 | MADE IN | USA | 1 | ||||
| 8 | 96801 | EVALFA | 8359GRW | 695066613259 | MADE IN | USA | 1 | ||||
| 9 | 96801 | EVALFA | 8359SRW | 695066610067 | MADE IN | USA | 1 | ||||
| 10 | 96801 | EVALFA | 8377DRK | 698298056146 | MADE IN | USA | 1 | ||||
| 11 | 96801 | EVALFA | 8377DTK | 698298078155 | MADE IN | USA | 1 | ||||
| 12 | 96801 | EVALFA | 8377SRK | 698298069641 | MADE IN | USA | 1 | ||||
| 13 | 96801 | EVALFA | 8377STK | 698298078209 | MADE IN | USA | 1 | ||||
| 14 | 96805 | DISKNI | 0651C2 | 695066010720 | USA | $18.00 | 25 | ||||
| 15 | 96411 | TALKMO | 0586D70 | 698298090096 | MOSAIC | INDIGENOUS | 20.99 | 7 | |||
| 16 | 96411 | TALKMO | 3426D2 | 695066031053 | MOSAIC | INDIGENOUS | 13.99 | 7 | |||
| 17 | 96411 | TALKMO | 8073C03A | 695066484095 | MOSAIC | INDIGENOUS | 22.99 | 7 | |||
| 18 | 96411 | TALKMO | 8080BD | 695066410094 | MOSAIC | INDIGENOUS | 11.99 | 9 | |||
| 19 | 96411 | TALKMO | 8073DRB | 698298087027 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 20 | 96411 | TALKMO | 8073SRB | 698298106391 | MOSAIC | INDIGENOUS | 16.99 | 7 | |||
| 21 | 96411 | TALKMO | 8077DRB | 698298097415 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 22 | 96411 | TALKMO | 2326V2 | 698298109354 | MOSAIC | INDIGENOUS | 20.99 | 7 | |||
| 23 | 96411 | TALKMO | 2643C | 695066025786 | MOSAIC | INDIGENOUS | 25.99 | 7 | |||
| 24 | 96411 | TALKMO | 6770V | 698298109330 | MOSAIC | INDIGENOUS | 19.99 | 9 | |||
| 25 | 96411 | TALKMO | 0203VM | 698298108807 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 26 | 96411 | TALKMO | 0574V2 | 698298108685 | MOSAIC | INDIGENOUS | 14.99 | 4 | |||
| 27 | 96411 | TALKMO | 0582V | 698298107084 | MOSAIC | INDIGENOUS | 14.99 | 4 | |||
| 28 | 96411 | TALKMO | 0584V | 698298108647 | MOSAIC | INDIGENOUS | 14.99 | 4 | |||
| 29 | 96411 | TALKMO | 0585V | 698298109651 | MOSAIC | INDIGENOUS | 14.99 | 4 | |||
| 30 | 96411 | TALKMO | 0811C6 | 698298149923 | MOSAIC | INDIGENOUS | 22.99 | 4 | |||
| 31 | 96411 | TALKMO | 1059C | 698298145307 | MOSAIC | INDIGENOUS | 13.99 | 4 | |||
| 32 | 96411 | TALKMO | 1185C | 695066098162 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 33 | 96411 | TALKMO | 4643V1 | 698298109606 | MOSAIC | INDIGENOUS | 14.99 | 4 | |||
| 34 | 96411 | TALKMO | 5056C | 695066064167 | MOSAIC | INDIGENOUS | 19.99 | 4 | |||
| 35 | 96411 | TALKMO | 5057C | 695066064198 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 36 | 96411 | TALKMO | 5058C | 695066064211 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 37 | 96411 | TALKMO | 5058CE2 | 698298128935 | MOSAIC | INDIGENOUS | 19.99 | 4 | |||
| 38 | 96411 | TALKMO | 5058CT2 | 698298129390 | MOSAIC | INDIGENOUS | 19.99 | 4 | |||
| 39 | 96411 | TALKMO | 5060V | 698298109613 | MOSAIC | INDIGENOUS | 19.99 | 4 | |||
| 40 | 96411 | TALKMO | 5068C | 695066064501 | MOSAIC | INDIGENOUS | 19.99 | 4 | |||
| 41 | 96411 | TALKMO | 5111V62 | 698298109620 | MOSAIC | INDIGENOUS | 17.99 | 4 | |||
| 42 | 96411 | TALKMO | 5128V | 698298108715 | MOSAIC | INDIGENOUS | 14.99 | 4 | |||
| 43 | 96411 | TALKMO | 5140C | 695066066871 | MOSAIC | INDIGENOUS | 17.99 | 4 | |||
| 44 | 96411 | TALKMO | 5386C | 698298145505 | MOSAIC | INDIGENOUS | 13.99 | 4 | |||
| 45 | 96411 | TALKMO | 6079C3E | 695066101893 | MOSAIC | INDIGENOUS | 17.99 | 4 | |||
| 46 | 96411 | TALKMO | 6445V | 698298108739 | MOSAIC | INDIGENOUS | 22.99 | 4 | |||
| 47 | 96411 | TALKMO | 6526V62 | 698298109576 | MOSAIC | INDIGENOUS | 19.99 | 4 | |||
| 48 | 96411 | TALKMO | 6532V81 | 698298109569 | MOSAIC | INDIGENOUS | 20.99 | 4 | |||
| 49 | 96411 | TALKMO | 6929V | 698298108746 | MOSAIC | INDIGENOUS | 19.99 | 4 | |||
| 50 | 96411 | TALKMO | 8080D62 | 698298106483 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 51 | 96411 | TALKMO | 9752D62 | 698298106544 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 52 | 96411 | TALKMO | 9753S62 | 698298106513 | MOSAIC | INDIGENOUS | 16.99 | 4 | |||
| 53 | 96411 | TALKMO | 0104D60 | 695066613426 | MOSAIC | INDIGENOUS | 17.99 | 4 | |||
| 54 | 96411 | TALKMO | 0106D60 | 695066613464 | MOSAIC | INDIGENOUS | 17.99 | 4 | |||
| 55 | 96411 | TALKMO | 0106S60 | 695066613471 | MOSAIC | INDIGENOUS | 17.99 | 6 | |||
| 56 | 96411 | TALKMO | 0200S61 | 698298050458 | MOSAIC | INDIGENOUS | 17.99 | 6 | |||
| 57 | 96411 | TALKMO | 0202D61 | 698298050892 | MOSAIC | INDIGENOUS | 17.99 | 6 | |||
| 58 | 96411 | TALKMO | 0586D60 | 698298081391 | MOSAIC | INDIGENOUS | 17.99 | 5 | |||
| 59 | 96411 | TALKMO | 0587D61 | 698298081872 | MOSAIC | INDIGENOUS | 20.99 | 6 | |||
| 60 | 96411 | TALKMO | 1279D603 | 695066613624 | MOSAIC | INDIGENOUS | 17.99 | 4 | |||
| 61 | 96411 | TALKMO | 6269D61 | 695066610227 | MOSAIC | INDIGENOUS | 17.99 | 5 | |||
| 62 | 96411 | TALKMO | 0900L | 695066011451 | MOSAIC | INDIGENOUS | 16.99 | 5 | |||
| 63 | 96411 | TALKMO | 5035C | 695066063627 | MOSAIC | INDIGENOUS | 16.99 | 5 | |||
| 64 | 96411 | TALKMO | 5036C | 695066063641 | MOSAIC | INDIGENOUS | 16.99 | 5 | |||
| 65 | 96411 | TALKMO | 5037C | 695066063672 | MOSAIC | INDIGENOUS | 16.99 | 5 | |||
| 66 | 96411 | TALKMO | 0104C | 695066050887 | MOSAIC | INDIGENOUS | 14.99 | 7 | |||
| 67 | 96411 | TALKMO | 0104N | 695066117740 | MOSAIC | INDIGENOUS | 14.99 | 7 | |||
| 68 | 96411 | TALKMO | 0106DRW | 695066009069 | MOSAIC | INDIGENOUS | 14.99 | 7 | |||
| 69 | 96411 | TALKMO | 0584VR | 698298109446 | MOSAIC | INDIGENOUS | 13.99 | 5 | |||
| 70 | 96411 | TALKMO | 0586DRW | 698298080820 | MOSAIC | INDIGENOUS | 14.99 | 5 | |||
| 71 | 96411 | TALKMO | 0715V1 | 698298109439 | MOSAIC | INDIGENOUS | 13.99 | 7 | |||
| 72 | 96411 | TALKMO | 0715V2 | 698298109422 | MOSAIC | INDIGENOUS | 13.99 | 7 | |||
| 73 | 96411 | TALKMO | 1091D2 | 695066012717 | MOSAIC | INDIGENOUS | 13.99 | 7 | |||
| 74 | 96411 | TALKMO | 1091S2 | 698298047823 | MOSAIC | INDIGENOUS | 13.99 | 7 | |||
| 75 | 96411 | TALKMO | 1279DRW3 | 695066169121 | MOSAIC | INDIGENOUS | 14.99 | 5 | |||
| 76 | 96411 | TALKMO | 1279SRW3 | 695066348335 | MOSAIC | INDIGENOUS | 14.99 | 5 | |||
| 77 | 96411 | TALKMO | 1391C3E | 695066014865 | MOSAIC | INDIGENOUS | 16.99 | 7 | |||
| 78 | 96411 | TALKMO | 3215VR | 698298108548 | MOSAIC | INDIGENOUS | 16.99 | 5 | |||
| 79 | 96411 | TALKMO | 5200DRW | 695066559755 | MOSAIC | INDIGENOUS | 14.99 | 4 | |||
| 80 | 96411 | TALKMO | 5388V | 698298109408 | MOSAIC | INDIGENOUS | 17.99 | 4 | |||
| 81 | 96411 | TALKMO | 8405DRW | 698298052254 | MOSAIC | INDIGENOUS | 14.99 | 5 | |||
| 82 | 96411 | TALKMO | 8073DRK | 698298090676 | MOSAIC | INDIGENOUS | 10.99 | 7 | |||
| 83 | 96411 | TALKMO | 8405DRK | 698298056627 | MOSAIC | INDIGENOUS | 10.99 | 7 | |||
| 84 | 96411 | TALKMO | K-AZ03-B | 698298054579 | MOSAIC | INDIGENOUS | 10.99 | 7 | |||
| 85 | 96411 | TALKMO | K-AZ03-C | 698298054586 | MOSAIC | INDIGENOUS | 10.99 | 11 | |||
| 86 | 96411 | TALKMO | K-AZ04-B | 698298054630 | MOSAIC | INDIGENOUS | 10.99 | 9 | |||
BB001 | |||||||||||
Upvote
0
It is just a file I did in notepad for you to see. The main file comes out of my mainframe like I showed you but the new costs are just typed.
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,309
- Office Version
- 365
- Platform
- Windows
OK, I don't think we are on the same wavelength here. So let me try explaining a different way.
In programming it in VBA, we need to tell VBA exactly where to go to get both data files, how those files are laid out, and what to do with them.
Where is this "MainFrame" file stored? Will it already be open, or are we having the VBA code open it up (if so, we need to know the specifics, i.e. where it is stored and what is its name)?
Also, is this the only data in this Mainframe file? Is there any header or trailer data?
And I am not sure what you meant when you said this earlier:
Can you explain that?
Remember, while you are very familiar with these files and what you want to do, we are not. We only know what you share with us. So please be detailed as possible.
Otherwise the solution we post might not work for you, because we were forced to make assumptions about some of the details.
Upvote
0
I will try to answer the best i can.
First question my main frame or server generates the file i uploaded. I take that file to my desktop label software that creates Bar code Labels from that file. I need to modify that file before it goes to the Label software that is where Excel comes in it open the original file into excel using Data, from Text/csv all files load. After that i see the file with all the columns and rows. When it comes over column D where the UPC code is comes over formatted as General and it looks like this 6.98298E+11 i have to format the column to number to show correctly. I then change column G the prices according to the one i showed you. After its all done i format column G to Currency to show the $ . Then i have to Export change file type To CSV so i can then import to my label software but it needs the same format as the original column headers. Worked fine when i did the find and replace just wanted to see if there was something easier. Hope that answers your questions. Thanks for your Help on this
|
|
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,309
- Office Version
- 365
- Platform
- Windows
That seems to address the details of your data file, but you still haven't told me where the price conversion table is coming from (there are 2 files at play here, right?).
I need to know all of the details of that too, and if that file is already going to be open when the VBA code runs, or whether the VBA code needs to find it somewhere.
Upvote
0
Similar threads
- Question
- Question
