Forum Discussion
MS Office 365 Excel
Thanks. I highlight a whole row and then choose 'Format/AutoFit Row Height' but the row height reverts to standard single row height no matter how much is in the various cells. Is there a choice to enable/disable this function in 'Option' or elsewhere?
I have another question for you and a suggestion based on an assumption.
- The question: what is the general content of this spreadsheet?
- The assumption: from what you've described so far, it sounds like much, if not all, of the content is textual in nature, not numeric. It could be (my assumption) that you're using Excel because of its inherent and very helpful row and column layout more than for its ability to handle and process numeric data.
- IF that assumption is even close--i.e., if in fact you're using Excel primarily as a repository for text in a row and column layout--then my suggestion would be to use Word instead of Excel, because Word's Table facility gives you much more intuitive control over such things as column width, row height, with the latter "automatically" accommodating the amount of text present. If I recall correctly, Word can even accommodate basic math (e.g., sums of values in columns).
Thank you, I have managed to sort out the autoformat row height issue in Excel and will consider your recommendation to use Word for text only.
i am trying to import prices and item properties from some hardware store.
i am a constructor, and to make a budget i have to
- look for item sku number
- open items page
- verify if it is in stock, how many
- if not enough, look for delivery option, how long it will take
- copy items sku
- memorize price
- paste it to correct cell in my budget table
- type in a price
- in other column type in what store i am getting it fromi know that you can automate such a things with vba. just struggling to make it because i know nothing about vba, that why watching lot of tutorials and starting to learn code,
my plan for automatization is
- create a workbook for all items data
- create worksheet for each hardware store i work with
- for each worksheet write a code to import items data with bunch properties of item
- create sum sheet with items sku and price only, but from different storesthere are going more steps to connect budget file to this "items database".
in each store sheet i have a table with column of "item" and "sku" that i type in once as i am getting new and new item. if i can import all items from the store at one - even better. but i cannot even talk it thru how to do that.
so, i have a column with some sku (example 850888, which id dry pine 2x4).
and want to import all info available about this item in to its columns. if columns with some property does not exist - create one.
my logic for coding for beginning
- open webpage https://www.sodimac.cl/sodimac-cl/
- go to search box- for each sku in a column (for now it is 850888)
- copy sku
- paste to search box
- press search button
the are more steps to process info provided, but i cannot even open a browser
know that you can just send a request and get page info without browser, but not sure if it will work because i cannot even open a browser.
this is what i am trying to do.Thank you for that very thorough explanation. I can see now why Excel. I'm NOT a person who uses or understands VBA so I'm going to defer to some who are....What you describe, however, is not going to be easy, especially if you're talking about multiple sources for the information.
It makes me wonder if there's not already a solution out there, for people who are in the construction business. In some ways I'd be surprised if there hasn't been a Jeff Bezos clone who's come up with an amazon for builders....
- oh crap, i posted reply to wrong topic)
wondered why i am not getting any replies.
for this topic alt, h, w should work
