VBA help!

Closed
amandashipp Posts 1 Registration date Monday December 15, 2014 Status Member Last seen December 15, 2014 - Dec 15, 2014 at 12:33 PM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Dec 18, 2014 at 05:26 PM
Hello,
I am absolutely a novice when it comes to macros and VBA and need some help.

I have a workbook with 6 worksheets. The first work sheet ("All Grants FY15") has 5 columns ("Date", "Grant", "Type", "Amount" and "Category", A2:E2). I am using this worksheet to enter all grant expenses. The remaining worksheets ("City ESG", "County ESG", "CoC HMIS", "SSVF HMIS", and "HMIS Program Fees") have the same columns at the same placement. In each of these subsequent worksheets, I have the name of the grant (which matches the value that will be placed on "All Grants FY15", B2:B500) placed at F2.

I am looking for a way to loop through "All Grants FY15", read the value at B2:B500, and copy that row into the next blank row on the corresponding worksheet where F2 on that worksheet equals B2 on the "All Grants FY15".

Does that make sense?
A

2 replies

ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 16, 2014 at 01:51 AM
you should go to destination cell and type = the you should select the source cell now these cells are equal , then you should extend the cell
i hope it works
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
Dec 18, 2014 at 05:26 PM
Hello Amanda,

Perhaps it would be best if you could upload a sample of your work book. Use a file sharing site such as DropBox.

We could then sort through it and see if we can solve the issue for you.

Kind regards,
vcoolio.
0