Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
I am not exactly following what you want
can you provide a copy of your sheet to create some sort of visual reference
not exactly what I had in mind, but it helps
if you see a paperclip icon at the top of your chat window
you can upload your excel file that way
but works on excel files
that doesn't help either
I'm sorry you are experiencing problems with the attach tool
can you try this site
you upload the actual xls file there
then they give you a file ID#
paste that ID# XXXXX
see attached. The first 4 sheets is the full table. Then I have a proposal (5th sheet) which I have a macro which zeros out all of the rows with a zero value in column 4. Then I do the same for the final sheet. But I loose the bottom border which separates the 'division codes'. Then I have to manually input each border. I hope this explanation helps you better understand it.
every time the 1000s place changes
you want a blue bottom border across the row
and you want that to be done with macro
is this correct so far?
come back here when ready to continue
File ID: 929784
Looks good so far. Except it did not place a border between 12000 and 14200. I need to make sure that it does this through the last set of numbers between the 15000 and 16000. Also, I need the borders to stop at column E. Finally, I need to apply it to the Proposal sheet with the light line.
I do not need it done in the Summary worksheet. I need done on the Bid worksheet and the Proposal worksheet but with a light line (the top left line of the border format). Also, can you add this to be done after the delete 0 macros so after the macro removes all rows which have 0 values then the border macro runs.
A few items to edit:
1. The border in the 'Bid' worksheet should be the thick one you previously had.
2. The border in the 'Proposal' worksheet is good with one exceptions; the border should go from column A to column D only. Currently it is going through column E.
3. Finally, I want to combine all three macros to one. This macro should perform the following task.
a. 'Proposal' worksheet. Delete all rows with a 0 value in the D column.
b. 'Bid' worksheet. Delete all rows with a 0 value in the D column. This has be done after 'part a' above. If not, since the 'Proposal' work sheet receives it's value from the 'Bid' worksheet, the Proposal will have a '#REF!' in the column D cell in some of the rows and the macro will not work. Unless you have a better way of doing it.
c. Add thick blue border to the 'Bid' worksheet.
d. Add the light border to the 'Proposal' worksheet.
Yes. Deletion first. If not you will delete the borders after you place them. This does not have to happen for the 'ICE Summary' sheet. That sheet is stagnant and comes in from another software.
One last thing. When the macro is complete with the Proposal worksheet. I would like to have the curser placed on cell B7. When the macro has completed with the B worksheet, have the cursor placed in cell D3. Finally, have the message box read 'BIDFORM IS READY!'
Hello PC Guy,
I would like to enhance the macro we built last week. I am importing an excel worksheet into an existing workbook. The work sheet is called ICE to Excel. This export from the another software will open Excel and I would like the following to occur:
1. Enable Event Handler to run the following macro when the Excel workbook is opened.
2. Delete or ignore the last row 'Total Estimate and amount'.
3. Text to column first row to separate code values and description.
4. Run DelZeroRowsAddBorders Macro. (previously built)
5. The quantity of rows that is brought in will be unknown. Allow to add to Bid rows and Proposal Rows if more are required according to the ICE to Excel import.
I tried to upload the Excel sheet I'm working but I am not sure if you are getting it. If not send me the other link so I can send you the spreadsheet again.
ICE is the name of the estimating program I use.
'ICE to Excel' is the name I gave to the worksheet I use to import the information from ICE to Excel.
The ICE program has an export to Excel feature in the reports menu. I named the report 'ICE to Excel'. When I export the report to Excel, it opens the workbook I browsed to and inputs the information into the ICE to Excel worksheet.
Did you receive the Excel spreadsheet I attached?
How do I go about opening a new question. I want to make sure I work with you. Send me the link to upload the Excel file to you.
The Excel workbook is called Bidform. There is a worksheet in the Bidform workbook called ICE to Excel. There are two other worksheets that in the Bidform. None of the worksheet names ever change.