Last seen: Jul 3, 2025
Sure, Add a column with this formula: =Table.ColumnCount([Custom])
Prepare a more accurate sample file then, to reflect your data structure.
Hi Chris, You can try the attached file.
baxbax said I am not sure adding the code in your example will help me solve my issue above ...If the user can simply enter another teams number in t...
Updated the code to add new rows in inventory, added a button also to make it easy for you.
That's what the code does, just try it, add the code in a module then assign it to a button. There is no report generation here, that's exactly wha...
The input box will return a text string, even if you type only numbers in InputBox, even if Type:=2. you can test the type of the result with : Msg...
No File attached, make sure you press the button "Start Upload" (next to the add Files button) after you add a file to the upload queue.
I guess you don't want a team to see other teams data, you have other options. For example, you can setup a login sheet, users will select the team...
You can simply use the Like operator: If "aaz1" like "*#*" then 'it has digits But best is to restrict what users are allowed to type. Applic...
You can also try a clean re-installation of office package, this will remove any remaining registry entries. (see Option 2, completely uninstall ...
There are a few workarounds: You can try using the SelectionChange event to detect if the user selected the B2 cell and move away from that cell: (...
I removed the automatic Change Type step from GetData2 function, that had a reference to each column.
Try V7 yahoo, see the file attached, should be faster, here is a sample link: Note that the symbols should not be altered as in the previous versi...
Can you provide that table of 150 symbols you're using?