Got it to run now, I had to remove a temp file path in the code. Was this correct? I think I am having an issue updating links in the files? Keeps stopping and asking about updating the links.
Posts by steve400243
-
-
Great Thank you - will test it out in a little while and revert with any questions or comments. I appreciate the quick work.
-
Pay Pal sent, please see above message for Ozgrid payment transaction ID.
-
Good Question, Data will always start in row 13 - No blank lines will ever be between data.
-
forgot to mention that 10% has been paid to Ozgrid Payapal -
Transaction ID # 85B43637DL6810443
-
Here is an example file, this one has 25 House Bills.
-
Many Thanks GCE.
-
I use the following VBA to open each file in a specified location and copy certain data from each file to a report.
Code- Sub t()
- Dim wb As Workbook, sh As Worksheet, ary As Variant, fPath As String, fName As String, i As Long, rw As Long
- fPath = "X:\SEA Shares\warehouse\CFS and FMM Program\SEA Devanned January-2020\"
- Set sh = Workbooks("New").Sheets(1)
- ary = Array("C3", "C4", "C5", "H2", "H3", "H4")
- fName = Dir(fPath & "*.xls*") Do While fName <> "" If fName <> ThisWorkbook.Name Then Set wb = Workbooks.Open(fPath & fName) For i = 2 To 7 rw = sh.Cells(Rows.Count, 2).End(xlUp)(2).Row sh.Cells(rw, i) = wb.Sheets(1).Range(ary(i - 2)).Value Next wb.Close False End If fName = Dir Loop
- End Sub
I need it to also copy from each file, when opened, additional data and save as shown, in the example attached. all files opened will be the same format. They will all have a different number of House Bills, But row 35 would be the last row used in each file. I only want it to copy the rows with data.
The data from each file's cells noted in red. Please let me know if that makes sense. Thanks for your help.
Please let me know questions or comments. -
Thanks for your time Rikcando, I appreciate it. It works as needed.
-
Hello, I have a worksheet with multiple lines of data, up to 500 +. There is a master number, column C, and there can be multiple house bill numbers in each Master Number. Column D. I need a way to have all the like Master numbers and corresponding house bill numbers, and the corresponding rows and Columns – A thru Y - be shaded a different alternating color. Please see the example, and I’m sorry if I’m not explaining this well enough. Thanks for all help. I could not figure out how to do this. grouping test.xlsx
-
Hello the attached worksheet works fine on office 2010, but when a user tries to work with it in 2013 it gets an error code of "could not load an object because it is not available on this machine"?? any ideas? Thank you in advance [ATTACH]n1193441[/ATTACH]
-
Re: trying to create vba to copy data when option button is selected
Quote from Logit;794633See your other forum posting
Thank you. I will.
-
Hello, on the attached worksheet I am looking for VBA Then when the transfer to complete option is selected, transfer the data starting in A3 to I3 to the complete tab and auto saving for history. Then clearing all data starting in row 3 on the 1st tab making the worksheet ready for the next user. Also the date and time listed in I1 like the example shown on the complete tab. Thank you in advance for all help.
-
Re: USD $20.00 to amend the installed macro to do a new feature
This is working as needed, Thank you Kris.
-
Re: USD $20.00 to amend the installed macro to do a new feature
Quote from Krishnakumar;788224Payment received, thanks !
Please find attached the file.
Great thank you, I will test it out in a bit, and let you know how it is going. Thanks for the quick work.
-
Re: USD $20.00 to amend the installed macro to do a new feature
Hello Kris, PayPal sent - Transaction ID: 00T77252K33111400
-
Re: USD $20.00 to amend the installed macro to do a new feature
Go ahead and post later. I'm at home now without a working pc. I will send the balance in the am, Seattle time. Send me your PayPal in a private message. I'll be at work in about 10 hours. Have a good day and thank you for the quick work.
-
Re: USD $20.00 to amend the installed macro to do a new feature
Hi Krishna Kumar, showing the charges in col b, etc. sounds fine, not adding additional rows. Thank you
-
Re: USD $20.00 to amend the installed macro to do a new feature
Quote from Krishnakumar;788134Hi
What about if you create another namerange 'AccessList' by concatenating Col K & Col L and apply that name in Billing sheet ?
If this makes sense, it's done, otherwise I can look at this for you.
please have a look at it. I would appreciate it! Thank you
-
$2.00 sent to ozgrid paypal - Transaction ID: 499496217K197552N
I need someone with alot more skill than me to look at this. The attached worksheet was put together with alot of help form the forums. It is working fine when i put in all the information, I start at C4 on the billing sheet tab, with the Picked up date, and tab thru the rest of the options. But I now need the Accessorial charges to list out if selected? Currently after the first one is selected, a msg box comes up asking if you would like to select another accessorial charge, if yes it just adds to the total and does not show record of it on the Billing Sheet. I need the Accessorial charges selected to list out in row 21, under the Accessorial cell in A20 if possible. The total box is fine, the dollar amount does not need to list out with the selected Accessorial charges. Is this doable?