Excel Formula/VBA Assistance
Closed
SFRIAR616
Posts
6
Registration date
Friday September 15, 2017
Status
Member
Last seen
November 14, 2017
-
Nov 13, 2017 at 06:46 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 14, 2017 at 05:17 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Nov 14, 2017 at 05:17 AM
Related:
- Excel Formula/VBA Assistance
- Number to words in excel formula without vba - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Enable vba in excel - Guide
- Vba case like - Guide
2 responses
Thanks for posting.
Understand, Excel cannot manipulate data (make changes to other cells on the sheet/alter values), unless you press a button to trigger it.
I have wire framed this type of manipulation here:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
Cut and paste of a row. Stuff like that!
Understand, Excel cannot manipulate data (make changes to other cells on the sheet/alter values), unless you press a button to trigger it.
I have wire framed this type of manipulation here:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
Cut and paste of a row. Stuff like that!
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Updated on Nov 14, 2017 at 05:18 AM
Updated on Nov 14, 2017 at 05:18 AM
Hello SFriar616,
Further to what Mark said, you could probably use a Worksheet_Change event in the two source sheets to send the data to the relevant destination sheets. You could use a separate criteria (such as, to be original, OK) so that you only send the individual rows of data that you want to the destination sheets.
From here (the destination sheets), using the same criteria brought over from the source sheets, you could send the relevant data to the Master sheet.
As for clearing the data from the Available Equipment/Mobilised Equipment Sheets, the code that you have in Module 1 (MoveStuff) will do that each time that you run that particular code. This line in that code:-
clears these sheets prior to any new data being transferred across.
Just an idea for you to ponder.
Cheerio,
vcoolio.
Further to what Mark said, you could probably use a Worksheet_Change event in the two source sheets to send the data to the relevant destination sheets. You could use a separate criteria (such as, to be original, OK) so that you only send the individual rows of data that you want to the destination sheets.
From here (the destination sheets), using the same criteria brought over from the source sheets, you could send the relevant data to the Master sheet.
As for clearing the data from the Available Equipment/Mobilised Equipment Sheets, the code that you have in Module 1 (MoveStuff) will do that each time that you run that particular code. This line in that code:-
Sheets(ar(1, i)).UsedRange.Offset(1).ClearContents
clears these sheets prior to any new data being transferred across.
Just an idea for you to ponder.
Cheerio,
vcoolio.
Nov 14, 2017 at 04:10 AM
I am a bit of a layman when it comes to VBA, I can do the basic stuff like linking the spreadsheets, but when it comes to the more complex stuff its way above my understanding.
I have had a look at the link you sent me and it has totally confused me.
Could you explain to me in layman terms and suggest any online courses which I could undertake which would give me a better understanding of vba.
Thanks,