168 reputation
4
bio website ohbees.com.au
location Brisbane, Australia
age 35
visits member for 2 years
seen Dec 18 at 6:40

I am a programmer/developer/analyst, currently specialising in SharePoint, VBA for Excel and PHP/HTML/SQL for Wordpress installations.

I have some experience with Python, Perl and C#.Net technologies, which I need to work on a bit more.


Feb
17
answered Auto share files synced to Sharepoint Online document library using OneDrive Pro
Feb
17
asked Auto share files synced to Sharepoint Online document library using OneDrive Pro
Jan
16
comment Data validation - require nearby cell not be blank
@Pnuts yeah not 100% sure but thought it might be right. And if there are a pair of cells, then yes the other answer is much better :)
Jan
16
comment How to change value in Excel drop down list
@Borek I'm just wondering if my answer below has helped at all?
Jan
16
comment Data validation - require nearby cell not be blank
Looks good and similar to my answer which I posted later. Yours wasn't up at the time. :)
Jan
16
answered Data validation - require nearby cell not be blank
Jan
16
comment Data validation - require nearby cell not be blank
You could do it with VBA without people needing to click on macros. Use an worksheet_change event to monitor if a comment cell is modified and then check if the associated data field is blank or not. If they are all in a standard layout (data in column 3, comment column 5) then it is pretty simple.
Jan
11
answered How to change value in Excel drop down list
Jan
11
awarded  Organizer
Jan
11
revised Move column data based on last column
add more generic tag - not specific to version
Jan
11
suggested approved edit on Move column data based on last column
Jan
11
answered Move column data based on last column
Jan
11
comment Create a form as a worksheet in Excel that adds records to another worksheet
@HoldenFenner I'm just wondering if my answer was of any use.
Jan
10
comment How to change value in Excel drop down list
@Borek You could use a combobox control, but then that requires VBA as well.
Jan
10
comment How to change value in Excel drop down list
Sorry Borek but it isn't possible without a macro or vba. Data validation is about checking the data at entry time. You would need to trigger something to update the cells with that value.
Jan
10
awarded  Teacher
Jan
10
comment Make a cell resize and fill contents into a cell when data is on separate lines
@norman It's cool. I remember when I first had this issue and it perplexed me for a while too!
Jan
10
answered Make a cell resize and fill contents into a cell when data is on separate lines
Jan
7
answered Create a form as a worksheet in Excel that adds records to another worksheet
Dec
28
comment Trouble seeing flash drive on Windows 7
I would have thought that the drive would use the next available drive letter? Alternatively you could try selecting a new drive letter under 'Control Panel -> Administrative Tools -> Computer Management' and select 'Disk Management' on the left hand side. You can then select your flash drive (or the current F: partition) right click and go "Change Drive Letter and Paths"