37

Excel Macro

UpworkUSNot specifiedintermediate
Microsoft ExcelExcel MacrosSpreadsheet AutomationMicrosoft Power BIPower QueryGoogle SheetsGoogle Apps ScriptDashboardVisual Basic for ApplicationsSpreadsheet MacrosGoogle Sheets AutomationData Analytics & Visualization SoftwareCSVAnalyticsSpreadsheet Skills
match header information from the document called "SETSS Student Invoices" to headings in "Yellow" in the excel document called "Practice spreadsheet", in chatgpt. So I need a set of commands. I did it once and it worked. When I did it the 2nd time, it didn't work. These are the five headings in the Excel spreadsheet that I want filled out: It's about 4 to 5 columns. SCIN ATTEND CODE SCIN ACT GRP SIZE SCIN START TIME SCIN END TIME SCIN SCHOOL OTHER In the Attend Code: It will be "P" for present down the whole column (I can do that!_ The SCIN Group Size, will be values "1, 2 or 3", taken from the group sizes of the file called "setss student invoices" So basically the group size, start time, end time with AM or PM and the last field where it says "SCIN SCHOOL". That would be "S" all the way down. So I did this in Chatgpt. It worked wihen I typed a series of commands, but not sure if it's best done in an Excel macro.
View Original Listing
Unlock AI intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo

Client

Spent: $296.2Rating: 5.0Verified