Does anyone now how to background shade every other alpha character in a column, I have sorted rows of data on one column which contain just single variable amounts of alpha chars A<>Z
I found this code and thought I might tweek it, but I find its a little to Cumbersometo adapt to suit my...
Thanks for your response, I am working 12hr shifts at the mo ,so no time to test or upload ,but I am really really greatful for your response, i will do a,s,a
Thanks
I have a few questions to your code
re - just replace MsgBox "It's working!", vbInformation
with my code
I tried using
call RDB_Workbook_To_PDF
but nothing happened, is there a way, or am I just not calling the sub properly, as i'd like to call 2X subs, the other would call another sub to save...
many thanks, and as always works a treat.
I had a rather long winded approach below, but I learned a few things on the way :)
Public Sub SelectFirstBlankCellBB()
' this vba selects each blankkC row as it steps through the For loop in Column F
'then when it finds a blank it it copies the...
upload sample sheet one is what I have so far and sheet 2 is what I'd like
Thanks guys and girls
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
I think I almost have it, if anyone can help tidy this up, the only thing is it gets the session time above the wrong session, so I am lost on this part...Many thanks in advance if anyone out there is listening
The below Vba stops at each blank row as it steps through the For loop in Column F...
So that all said in english is:
Goto the first block in column and take the first cell value from column F and copy or store the value then move the line above and move 2X cells to the left and add the word "Session time = " & cell_value (possibly merging ,formatting bordering the 2X cells...
Hi,
And thanks for taking the time to look :)
I have a spreadsheet with one column... (F) that contains various different session times for each person for any given day. So for the first session I may have 20 peoples names attending on each row with the session time, (I already have the vba...
Thanks, for your suggestions, I did try recording a macro, but the "Daily_extracted_datasheet098230928348.csv" that I record a macro on will have a different number appended to it each time it is ran even if its on the same day, so the worksheet change event somehow doesn't work and doesn't run...
Does anyone know the best way. To automate this vba. As i said in an earlier post i cant have my user s paste code every morning. Most are not pc savi. And just have difficulty finding and running a crystal report and extracting to csv format. And running a shortcut key on the keyboard. So i...
Yep. I hear you. But i do need the worsheet to save on every change to a pdf. As i need other people supervisors to ne able to see the last recorded times in real-time via the saved Pdf
And please also before you suggest.i dont wish to share the workbook
...also if the user closes without saving...
Yes, sorry But I need it to save on every change
Unfortunately. I am trying to automate the vba on a new Daily downloaded worksheet. So can.t tell users to paste every day...thanks for your suggestion though
I need help with the coding part of autosave to Pdf if any changes occurs on on a worksheet and also to overwrite the newly created existing pdf , I managed to find vba to save save pdf (via WWW-Google)
as below
Sub RDB_Workbook_To_PDF1()
'Stop
Dim filename As String...
I have a csv file that I need vba code to search through two specific columns row by row (I & J): and if an exact match found delete the entire row
So far I have long winded VBA that almost works, but unfortunately it only looks at one specific ie: column( J) at the moment, So what i need is...
Well done and thank you so much for all your efforts, for what you have done with this issue although it's not completley solved. You have managed to take it way past my expectations of what I thought could be done with the problem. Ultimately though, I have to say if it doesn't work properly...
Hi, firstly thanks, I tried running as you suggested the code a second time around, but nothing happens. I guess it's because if it didn't find the first time around then it won't find any more swaps, No matter how many times I try, yet there was clearly one other available a 2X way or 3Xway...