Previous Topic Next Topic

VBA help!

Closed
amandashipp Posts 1 Registration date Monday 15 December 2014 Status Member Last seen 15 December 2014 - 15 Dec 2014 à 12:33
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 18 Dec 2014 à 17:26
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 responses

Réponse 1 / 2
ArashMan Posts 38 Registration date Monday 15 December 2014 Status Member Last seen 18 February 2015 1
16 Dec 2014 à 01:51
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
Réponse 2 / 2
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 262
18 Dec 2014 à 17:26
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.